Edit Expression Binding dialog box

Use the Edit Expression Binding dialog box to specify expression binding for Edit and Static components.

This expression editor allows you to:

  • Break down the expression into functions and operands
  • Recursively edit embedded functions
  • Validate the expression

The expression is stored in the component data source in the form of expression( expression ).

Field/Option Description
Expression Displays the expression that is constructed based on the function or operator that you selected
Function Select what type of expression function or operator to perform on the values returned for the component:
  • Math operators: NEGATE, +, −, *, /, %
  • Math functions: ABS, CEILING, FLOOR, MAX, MIN, POWER, ROUND, SIGN, SQRT, TRUNC
  • Comparison operators: == or =, >=, <=, >, <, != or <>
  • Logical operators: AND or &&, NOT or !, OR or ||
  • Logical functions: CONTAINS, IF, ISEMPTY
  • Text functions: CONCAT, INSTR, LEFT, LEN, LOWER, LTRIM, REPLACE, RIGHT, RTRIM, SUBSTRING, TRIM, UPPER
  • Accumulator functions: AVGACCUM, AVGPAGEACCUM, CNTACCUM, CNTPAGEACCUM, MAXACCUM, MAXPAGEACCUM,MINACCUM, MINPAGEACCUM, SUMACCUM, SUMPAGEACCUM
  • Aggregate functions: AVG, AVGEXP, CNT, CNTEXP, MAXAGG, MAXEXP, MINAGG, MINEXP, SUM, SUMEXP
  • Date functions: CURDATE, CURDATETIME, DATE, DATEADD, DATEDIFF, DATEPART, ISOWEEKNUM
  • Mongoose functions: C, FORMAT, P, STRINGS, USERNAME, V
  • DataView functions: AVG, AVGEXP, CNT, CNTEXP, MAXAGG, MAXEXP, MINAGG, MINEXP, SUM, SUMEXP, DATAVIEWPROP, DATAVIEWEXP

See the Expression functions and operators topic.
Validate Click this button to validate the expression.
Edit Click this button to recursively open this expression editor to build or edit the operand value.
Related topics