Logical Expressions in Query Language

You can use the following logical expressions in selection operations and criteria:

<Logical expression>

<Expression> |
<Expression> <Comparison Operation> <Expression> |
<Expression> [NOT] In [HIERARCHY] ( <Value List> | <Value Array> ) |
<Expression> [NOT] IN [HIERARCHY] ( <Query Description> ) |
<Expression> [NOT] BETWEEN <Expression> AND <Expression> |
<Expression> IS [NOT] NULL |
<Expression> REFERENCE <Table Name> |
<Expression> [NOT] LIKE <STRING type literal> [ESCAPE <STRING type literal>]

Logical expression can be:

  • an ordinary query language <expression>, if its result has a logical type;
  • <Comparison operation> for two query language expressions; such operations are executed in compliance with the values comparison rules;
  • an operator for checking equality or inequality of the expression's result with one of the listed values or with values from results of another query;
  • an operator for checking whether the expression's result falls into a certain range;
  • an operator for checking NULL expression result;
  • an operator for checking reference expression values for references to a certain table;
  • an operator for checking string values for matching a pattern.

 

See also: Use of Expressions in the Query Language

1C:Enterprise Developer's Community