[ROOT] / doc / toc / ARCQuery / Class / QueryExpressionWhere

Execute , IsMatch , SyntaxHelp , TryCheckForExistenceOfKey , Value


Executes a 'WHERE {key} {operator} {value}' against the given collection.

This class offers extensive functionality.
TODO: Document functionality better.

See FunctionKey for possible functions that can be applied to properties.

See RelationalOperator for list of possible operators.

Understands use of ValueComparer like ValueComparerDateTime

TODO: Expand syntax, in order to support 'AND' and 'OR'. TODO: Currently 'AND' can be simulated by chaining multiple QueryExpressionWhere, but not 'OR'.

TODO: Allow 'IS NULL' and 'IS NOT NULL' in addition to 'EQ NULL' and 'NEQ NULL'

TODO: Include support for regular expressions (but keep easy syntax for 'ordinary' users).

See SyntaxHelp.


ExecuteTransforms the given input collection into a resulting collection.
IsMatchReturns TRUE if property matches criteria.
SyntaxHelpWHERE {key} {operator} {value}
TryCheckForExistenceOfKeyUsed by query expressions in order to catch wrong field names used or misspelling of field names.
ValueThe Value should ideally be as strongly typed as possible. Note that it may be of type -ValueEnum- relevant for queries like WHERE Name = NULL.

Details

Generated 2024-04-16 23:15:34.655 UTC