Re: using gt and lt in a query

On Thu, Nov 14, 2019 at 1:28 PM Erick Erickson wrote: > You might be able to make this work with function queries…. > > > I managed to decipher something along the lines of this: http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt: 0 TO

Re: using gt and lt in a query

You might be able to make this work with function queries…. Best, Erick > On Nov 14, 2019, at 1:26 PM, Shawn Heisey wrote: > > On 11/14/2019 11:09 AM, rhys J wrote: >> But I'm not doing a range, I'm doing a query on whether one field is >> greater than another field. Or am I missing something h

Re: using gt and lt in a query

On 11/14/2019 11:09 AM, rhys J wrote: But I'm not doing a range, I'm doing a query on whether one field is greater than another field. Or am I missing something here? I am unaware of any way to do that with simple query syntax. Sometimes there is capability that I do not know about, though.

Re: using gt and lt in a query

> Range queries are done with brackets and/or braces. A square bracket > indicates that the range should include the precise value mentioned, and > a curly brace indicates that the range should exclude the precise value > mentioned. > > > https://lucene.apache.org/solr/guide/8_2/the-standard-query

Re: using gt and lt in a query

On 11/14/2019 10:49 AM, rhys J wrote: I am trying to duplicate this line from a db query: (debt.orig_princ_amt > 0 AND debt.princ_paid > 0 AND debt.orig_princ_amt > debt.princ_paid) I have the following, but it returns no results: Range queries are done with brackets and/or braces. A square

using gt and lt in a query

I am trying to duplicate this line from a db query: (debt.orig_princ_amt > 0 AND debt.princ_paid > 0 AND debt.orig_princ_amt > debt.princ_paid) I have the following, but it returns no results: http://localhost:8983/solr/debt/select?q=orig_princ_amt