Query Language
ActiveSpaces software supports a restricted subset of the SQL query language.
To specify a query, supply a filter expression. For example:
column_name > 100
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.
Filter expressions are not case sensitive. Query evaluation converts keywords and column names to lower case before evaluation.
Copyright © Cloud Software Group, Inc. All rights reserved.