Working with Built-in Functions
Built-in functions can be used in various places:
•As parameters for search and dashboard queries.
•As values or expression members in quick actions.
•As values or expression members in object and relationship rules.
•As values in workflow objects.
•As values in reports.
Each function description contains the following information:
•Name of the function.
•Brief description of the function.
•Syntax of the function.
•The business objects for which this function is enabled. See Notes on "Enabled For" for more information.
•Input parameters for the function. These inputs can be literals, field references, function calls, text concatenation, expressions, and so on. For details on expressions, see About Expressions.
•The type of value that the function returns. Possible values are as follows:
•List of text items (only valid in certain areas)
•An example of how the function is used.
The "Enabled For" section includes the following areas:
•Business Rules: Before-Save Rules
•Business Rules: Calculation (After Save, with or without Also Recalculate on Load)
•Business Rules: Calculation (Before Save or Always, without Also Recalculate On Load)
•Business Rules: Calculation (Before Save or Always, with Also Recalculate On Load)
•Business Rules: Editing Rules
•Business Rules: Initialization Rules
•Business Rules: Read-Only Rules, Required Rules, Validation Rules. This includes regular expression validation rules.
•Client Expressions. This includes form style, visibility, and toolbar expressions.
•Services. This includes workflows and escalation. In future releases, we may add more services.
•Quick Actions except for the user interface quick actions.
•UI Quick Actions
•Search/Dashboard without Field References
•Search/Dashboard with Field References. See Searching for Related Business Objects in a Saved Search for information about searching with field references.
Almost every built-in function has arguments. Some arguments are required and some are optional. If you leave out an optional arguments, the function uses a default value.
You can use an underscore or leave the argument blank. If you leave it blank, the application inserts an underscore.
For example, the EndOfQuarter() function takes three optional arguments. Therefore, the following are all equivalent:
Business rules and their associated expressions are executed in several places:
•On the client
•On the server
•As part of a Microsoft SQL query
•On the mobile client
See Using Values in Expressions for information about using 64-bit integers versus 32-bit integers.
Certain functions are deprecated. Expressions with these functions work; however, you cannot edit them and you cannot add new expressions with these functions.
The deprecated functions are:
Several functions will be deprecated in a future release. Expressions with these functions work and you can use them; however, the application displays a message that they will be deprecated. If possible, do not use these functions.
The functions that will be deprecated in a future release are: