Dear all, Apparently, Google App Engine datastore does not support "WHERE myfield LIKE '%search%'" feature...
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. Traceback (most recent call last): File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/restricted.py", line 194, in restricted exec ccode in environment File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/applications/ddlagoon/controllers/default.py:index", line 365, in <module> File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/globals.py", line 149, in <lambda> self._caller = lambda f: f() File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/applications/ddlagoon/controllers/default.py:index", line 75, in index File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/dal.py", line 5697, in select return self.db._adapter.select(self.query,fields,attributes) File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/dal.py", line 3351, in select (items, tablename, fields) = self.select_raw(query,fields,attributes) File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/dal.py", line 3308, in select_raw filters = self.expand(query) File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/dal.py", line 3190, in expand return expression.op(expression.first, expression.second) File "/base/data/home/apps/s~ddl-lagoon/1.354289280423718203/gluon/dal.py", line 3267, in CONTAINS raise SyntaxError, "Not supported" SyntaxError: Not supported Is there any way to get the same effect in GAE? How can we "search" into the datastore?