Go + App Engine数据存储区：如何过滤出为空的行？

Question

How do I filter out rows that are null? I know it's hard to find only-null rows, but hopefully this should be easier.

I'd like to do the following:

q := datastore.NewQuery("MY_KIND").Filter("MY_ID !=", nil)

... but Filter doesn't support the != comparator. FYI, using this GQL syntax in the Datastore Viewer works just fine:

SELECT * FROM MY_KIND WHERE MY_ID != NULL

Answer 1

You can use greater filter with the appropriate value (> 0 for numbers, > "" for strings).

Typically an ID cannot be an empty string or zero.