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 <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> * AND <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> 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) I should have 1075459 results, but I get 0. Thanks, Rhys
