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"