SQLQuery: Not Returning Expected Result
Hi All,
We currently store objects in gigaspace in the following format
Unique ID (java.lang.String) Number (java.lang.Long) 1 12345678 2 1000 3 56
When I ran the query (this can be proven even on the admin ui), Number < 700, it should return only row 3 but unfortunately it returned all 3 records. What should be the construction of the query in order to only return row 3
Regards, Donnie
{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=3820]{quote}