2017년 1월 13일 금요일

Fusion Tables - Querysyntax Problems


I have problems with a query String in Fusion Tables.

In FusiontablesControlGetRowswithConditions I need to query alternative sets in two categories (database columns) of a record

Condition: Category1 IN  ('a', 'b', 'c') OR Category2 IN  ('d', 'e', 'f')

This does not work with OR, only with AND.

Who can I realize that without querying the fusiontable 2 times?

--
According to the Fusion Tables SQL Syntax page at https://developers.google.com/fusiontables/docs/v2/sql-reference#Select
there is no 'OR" support.

There's no UNION facility either.

It's not looking good.

-- 
Ok. Thank You!

Mark

--


댓글 없음:

댓글 쓰기