Condition

Query language construction. Condition for selecting entries. Allowed field values: Period; Recorder; LineNumber; Active; AccountDr; ExtDimensionDr<ExtDimension number>; ExtDimensionTypeDr<ExtDimension number>; AccountCr; ExtDimensionCr<ExtDimension number>; ExtDimensionTypeCr<ExtDimension number>; <Dimension name>; <Dimension name>Cr; <Dimension name>Cr; <Resource name>; <Resource name>Dr; <Resource name>Cr; <Attribute name>.
Important! Using the "not equal" comparison is not allowed for fields ExtDimension<N>, ExtDimensionDr<N>, and ExtDimensionCr<N>. If you want to use the "not equal" condition, either use in the WHERE section of the query (and not in virtual table conditions), or add a comparison with extra dimension type.
For example, the condition Account = Account Or ExtDimensionDr1 <> Contractor should look like this:
Account = Account Or (ExtDimensionDr1 <> Contractor And ExtDimenstionDrType1 = ExtDimensionTypeContractor).
Important! Extra dimension numbers do not match the extra dimension numbers in the table.

---