On Thu, Nov 14, 2019 at 1:28 PM Erick Erickson <erickerick...@gmail.com> 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 <http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt%3A%200%20TO> * AND <http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt%3A%200%20TO%20*%20AND> princ_paid:0 <http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt%3A%200%20TO%20*%20AND%20princ_paid%3A%20%200> TO <http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt%3A%200%20TO%20*%20AND%20princ_paid%3A%20%200%20TO> *& <http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt%3A%200%20TO%20*%20AND%20princ_paid%3A%20%200%20TO%20*%20AND>fq={!frange l=0}if( gt(orig_princ_amt <http://10.40.10.14:8983/solr/debt/select?q=orig_princ_amt%3A%200%20TO%20*%20AND%20princ_paid%3A%20%200%20TO%20*%20AND%20gt(%20orig_princ_amt>, princ_paid),1, 0 ) but it's still not giving me the entire results that the database gives. So I'm not sure what I am missing? Thanks, Rhys