KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Using the google appengine datastore, is there a way to perform a gql query that specifies a WHERE clause on a StringProperty datatype that is case insensitive? I am not always sure what case the value will be in. The docs specify that the where is case sensitive for my values, is there a way to make this insensitive? for instance the db Model would be this: from google.appengine.ext import db class Product(db.Model): id = db.IntegerProperty() category = db.StringProperty() and the data looks like this: id category =================== 1 cat1 2 cat2 3 Cat1 4 CAT1 5 CAT3 6 Cat4 7 CaT1 8 CAT5 i would like to say gqlstring = "WHERE category = '{0}'".format('cat1') returnvalue = Product.gql(gqlstring) and have returnvalue contain id category =================== 1 cat1 3 Cat1 4 CAT1 7 CaT1
Tags (comma-separated)
Save Edits
Cancel