Gql query returning unexpected empty

Question

I'm trying to use a query i know is supposed to return a value but it does'nt and i'm unable to filter using Type

heres the query:

SELECT Type FROM machinetype WHERE Brand = 'Avant'

heres the index serving:

Type ▲ , Brand ▲

Can you share the schema of machinetype model? – rdodev Mar 05 '14 at 21:22 — rdodev, Mar 05 '14 at 21:22
be sure you are saving Brand property as indexed. – musketyr Mar 06 '14 at 07:42 — musketyr, Mar 06 '14 at 07:42

loki · Answer 1 · 2014-03-06T16:22:22.543

1

There are no results returned because you are missing to fetch them.

Python:

q = db.GqlQuery("""SELECT Type FROM machinetype WHERE Brand = 'Avant'""")
results = q.fetch(10)

or for one result

results = q.get()

Another possibility is that you modelled Brand as Text which makes it non-indexable or you have the code running in production and did never run the query on the development server and the index was not created.

edited Mar 06 '14 at 16:22

answered Mar 05 '14 at 22:40

loki

2,271
5
32
46

im doing this in the datastore viewer so thats not the problem – user3062352 Mar 07 '14 at 12:31

Gql query returning unexpected empty

1 Answers1