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?