Using GQL to check if BlobProperty is NULL

Question

Hello,

I have a db.BlobProperty property (called "Icon") in my entity which contains an image binary. I want to run a GQL query to retrieve all entities with an image (i.e. their "Icon" property is not NULL).

Trying to use the following query:

"SELECT * FROM Names WHERE Icon!=NULL"

did not work... Trying to use .filter("Icon!=",None) did not work as well...

Any ideas?

Thanks!

Joel

Answer 1

You can't filter on blob properties - they're not indexed. Your best option is to add an indexed boolean property, which indicates if the blob is present or not.