General Syntax
The syntax listed in the table below are for SQL queries and should not be used with inline scripts.
The following table lists the general syntax used in Logi Info:
| Item | Description/Example |
|---|---|
| Comparison operators | ==, !=, <, >, <=, >= Note that = and <>are not supported. |
| Logical operators | AND, OR, with precedence controlled using parentheses |
| Column data value placeholder |
The column name, wrapped in square brackets: [UnitPrice] The column name is case-sensitive and there is no need to explicitly designate values as strings by surrounding their bracketed column names with quotation marks. |
| Token usage | Tokens, with the exception of @Data, may be used. |