Condition

Query language construction. Value by which data is filtered. Allowed field values: Period, Recorder, LineNumber, Active, Account, ExtDimension<ExtDimension number>, ExtDimensionType<ExtDimension number>, <Dimension name>, <Resource name>, <Attribute name>.
Important! Using the "not equal" comparison is not allowed for fields ExtDimension<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 ExtDimension1 <> Contractor should look like this: Account = Account Or (ExtDimension <> Contractor And ExtDimenstionDrType1 = ExtDimensionTypeContractor).
Important! Extra dimension numbers do not match the extra dimension numbers in the table.

---