Notice: Can't select Text, only String on GAE @ Google App Admin Tool

do NOT USE SELECT for title like this page for SQL escape.

String,Date,Int can be searched on datastore because sortable. Blob and Text can not be searched.

Example

name type
date Date
email String
html Text
name String
raw Text
wiki String

/file/Notice: Can't select Text, only String on GAE @ Google App Admin Tool/tas.png

DateTime

/file/Notice: Can't select Text, only String on GAE @ Google App Admin Tool/gd.png

SELECT * FROM Comment where date > DateTime('2000-12-31 23:59:59')
Result All Selected
Date
SELECT * FROM Comment where date > Date('2000-12-31')
Result All Selected
String
SELECT * FROM Comment where wiki>'j'
Result Selected except "index" (h i j k ... >> u >> z)
SELECT * FROM Comment where wiki>4
SELECT * FROM Comment where wiki>'4'
Result All Selected (0 1 2 3 4 5 >> 9 >> a >> h i j k ... >> u >> z). Same result. 1 and 0 not means true or false. it's literally order.
SELECT * FROM Comment where wiki='index'
Result Selected "index"
Text
SELECT * FROM Comment where raw='you can use wiki syntax.
#li
##st
----
<<<
{{{
no longer has job
}}}
<<<
;estupid
:ore'
Result Invalid Query
SELECT * FROM Comment where raw='you can use wiki syntax.\n#li\n##st\n----\n<<<\n{{{\nno\nlonger has job\n}}}\n<<<\n;estupid\n:ore'
Result No Result Found
SELECT * FROM Comment where raw='you can use wiki syntax.\\n#li\\n##st\\n----\\n<<<\\n{{{\\nno\\nlonger has job\\n}}}\\n<<<\\n;estupid\\n:ore'
Result No Result Found
SELECT * FROM Comment where raw>0
SELECT * FROM Comment where raw>'a'
SELECT * FROM Comment where raw='thanks'
Result No Result Found (Because Text and Blob haven't been indexed)
Because Text and Blob haven't been indexed, those values are never searchable.
    last modified: 11 July 2011 [ View wiki source Close ]
     
SEARCH DIFFERENCE ATTACHMENT RECENT POST