Conditions with Expressions (Code Improvement)
For better performance and improve your coding way, you can add expressions in conditions.
*When possible, it is recommended to use expressions in conditions instead of coding macros.
An expression in a condition can calculate an attribute value within an expression of different intrinsic attributes, with the following format:
Where:
• MetaAttribute is either:
• attribute of the MetaClass or MetaAssociation
• intrinsic or calculated with a trigger
• Operator is either:
• =, not =
• <, >
• <=, >=
• in, Not in
• Expression can be a mixed of the following:
• +, -, *, /
• attribute of the MetaClass or MetaAssociation (intrinsic or calculated with a trigger)
• SQL Server Function (e.g.: dateadd, log)
• parameter
• object variable
*The expression cannot include calculated attributes nor Tagged Values.
Examples
Select [Application] Where [Cost] > [Expenses]+10
Select [Application] Where Not [Property contained].[Link creation date] between dateadd(year, -5, getdate()) And dateadd(year, -1, getdate()) And [Property contained].[Creation Date] > dateadd(year, -5, getdate()) And [Property contained].[Link modification date] = "04/04/2022"