phongyewtong phongyewtong - 1 month ago 16
MySQL Question

How do I use GQL to select a group that look like this Key('Group', '1779_1528')

How do I use GQL to select a group that look like this Key('Group', '1779_1528').

i tried:

Select * from User where group = '1779_1528'
Select * from User where group = Key('Group', '5335_5556')
Select * from User where group HAS ANCESTOR KEY('Group', '5335_5556')


got this error:

'Select * from User where group = '1779_1528' LIMIT 50': Encountered "group" at line 1, column 26. Was expecting one of: <UNQUOTED_NAME> ... <QUOTED_NAME> ... <NAME_BINDING_SITE> ... <POSITION_BINDING_SITE> ... <SINGLE_QUOTE_STRING> ... <DOUBLE_QUOTE_STRING> ... <INTEGER> ... <DOUBLE> ... "true" ... "false" ... "null" ...


enter image description here
enter image description here

Answer

Another alternative is to use filer to show the data you want

enter image description here