Skip to main content

What SQL and Equus functions are supported in Business Rules?

There are a total of 44 functions available to select from the Functions drop down list when choosing to use Functions to create Business Rule logic.   Once a function is selected, a summary and the s

Updated over 2 weeks ago

There are a total of 44 functions available to select from the Functions drop down list when choosing to use Functions to create Business Rule logic.

Once a function is selected, a summary and the syntax of the selected function is displayed in the Function Information section. The function's parameters are listed in the Parameters section and those that are required are marked with an asterisk (*).

summary and the syntax of the selected function

Equus (DBO) functions

  • CDR Line Item Amount Get

  • CE Line Item Value Get

  • Company Segment Code From Assignment

  • Company Segment Code From Name

  • Convert Money

  • Country Code From Name

  • Currency Name From Code

  • Exchange Rate Get

  • Get Country ISO2 Code

  • Home Country ISO2 From Assignment

  • Host Country ISO2 From Assignment

  • Service Order Status

  • State Province Code From Name

SQL functions

  • Absolute

  • Cast

  • Ceiling

  • Char Index

  • Coalesce

  • Concat

  • Convert

  • Date From Parts

  • Date Name

  • Date Part

  • Dateadd

  • Datediff

  • Day

  • Exponential

  • Floor

  • Format

  • Get Date

  • Get Currency

  • IsNull

  • Left

  • Length

  • Logarithm

  • LTrim

  • Month

  • Power

  • Replace

  • Right

  • Round

  • RTrim

  • Substring

  • Year

Did this answer your question?