Search code examples
pythongoogle-app-enginegqlgqlquery

Get the Records which contains a word (Case insensitive) in Gql?

Is it possible to write a single Gql Query for retrieving the record which contains a searching string?

Data store Contains following Records:

addax
Crest
Addrest
Drest
Armrest
admix

I need to get the Records which contains the word "Rest" (Case insensitive)

Solution

  • Full-Text-Search is not supported in AE yet, it's on the roadmap so we can look forward to it.

    If you are just trying to match single words in a case insensitive way, you could store all your words in a ListProperty, and ensure they are always stored in lowercase. That way you could easily query for them in a case insensitive mannor.