[ROOT] / doc / toc / ARCQuery / Class / QueryExpressionStrict
Execute , SyntaxHelp , TryCheckForExistenceOfKey
Describes Strictness ON / OFF when executing query.
Specified through QueryExpressionStrict and stored in CurrentStrictness.
Does not affect query result, only whether query will terminate or not due to perceived inconsistencies in the data.
A typical example where you may want to set 'STRICT OFF' is when you have queries results where sometimes a specific field is not set, and that field is used in a subsequent query expression, for instance 'WHERE' or 'ORDER BY'.
This is because -QueryExpression does not have any concept of schema / 'supposed to exist' fields, it only sees the actual data.
Example: If you have this:
Customer/42/FirstName = John
Customer/42/LastName = Smith
Customer/43/FirstName = Ann
Then the query "Customer/WHERE FirstName = 'Ann'/ORDER BY LastName'"
will fail because QueryExpressionOrderBy will not see any field 'LastName'.
This query
"Customer/WHERE FirstName = 'Ann'/STRICT OFF/ORDER BY LastName'"
on the other hand will succeed.
See SyntaxHelp.
| Execute | Transforms the given input collection into a resulting collection. |
| SyntaxHelp | STRICT {strictnessLevel} |
| TryCheckForExistenceOfKey | Used by query expressions in order to catch wrong field names used or misspelling of field names. |
Generated 2024-04-18 14:01:39.009 UTC