Iterator Query Language
ActiveSpaces software supports a restricted subset of the SQL query language.
To specify a query when using an iterator, supply a filter expression. For example:
column_name > 100
Iterator Queries return all columns of a table rather than a subset of specific columns. That is, all queries implicitly begin with SELECT * FROM table_name WHERE. Nonetheless, programs do not specify this string, they specify only the filter that would follow the WHERE keyword.
SQL keywords and table and column identifiers are not case sensitive when used in a filter expression. String values, surrounded by single quotes, are case-sensitive.
Related concepts
Copyright © Cloud Software Group, Inc. All rights reserved.