surinder-insonix / datanucleus-appengine

Automatically exported from code.google.com/p/datanucleus-appengine
0 stars 0 forks source link

Add support for LIKE or CONTAINS in Where clause #193

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
To my dismay, I have discovered that there is no way to perform a query with 
LIKE "%xxx%" or CONTAINS "xxx" in the where clause.  It would be super nifty 
to have that feature.  Any chances?

Original issue reported on code.google.com by adelaney...@gtempaccount.com on 11 Feb 2010 at 8:53

GoogleCodeExporter commented 8 years ago
collectionField.contains(xxx)
stringField.matches(xxx%)

Original comment by googleco...@yahoo.co.uk on 13 Feb 2010 at 8:18

GoogleCodeExporter commented 8 years ago
The datastore doesn't support generic substring matching so there is no 
scalable way to 
fulfill LIKE "%xxx".  Prefix matching is supported though:  LIKE "xxxx%".  If 
generic 
substring matching is important please star the issue for full-text search:

http://code.google.com/p/googleappengine/issues/detail?id=217

Original comment by max.r...@gmail.com on 18 Feb 2010 at 12:36