×

Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2024 releases!

Home
Orientation
Expression Editor
Expression Editor
Expressions combine or manipulate one or more pieces of data into a new piece of data using mathematical or boolean logic, as well as a set of built-in functions; therefore, they must follow the standard algebraic rules for order of operations.

Workflow IPI
Get Started
Tutorials
Orientation
- Workflow Overview
- User Interface
- Resources
- Search for Resources
- Expression Editor
  - Expression Editor
    Expressions combine or manipulate one or more pieces of data into a new piece of data using mathematical or boolean logic, as well as a set of built-in functions; therefore, they must follow the standard algebraic rules for order of operations.
    - Expression Functions
      A function performs a calculation between values in order to produce another value. When functions are used in an expression, they aid in the expression's evaluation.
    - Math Functions in Expressions
      Math functions are used for mathematical calculations in an expression.
    - Conversion Functions in Expressions
      Conversion functions convert expressions of one data type to another data type when data type conversions are not automatically performed by SQL Server.
    - Logical Functions in Expressions
      Logical functions perform an operation or comparison on objects and expressions.
    - Text Functions in Expressions
      Text functions perform an operation on a string input value and return a string or numeric value.
    - Date Functions in Expressions
      Date functions perform an operation on a date and time input value and return a string, numeric, or date and time value.
    - Expression Operators
      An operator performs an operation in an expression on one or more elements that hold value.
    - Expression Variables
      Variables are previously configured components in Workflow models that can be included in an expression for evaluation.
    - String, Numeric, and Boolean Literals in Expressions
      A literal is a textual representation of a particular value in an expression.
Configure Your Environment
Security
Resource Information and Configuration
Data Administration
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

Expression Editor

Expressions combine or manipulate one or more pieces of data into a new piece of data using mathematical or boolean logic, as well as a set of built-in functions; therefore, they must follow the standard algebraic rules for order of operations.

You can build simple or complex expressions. They are user-defined and consist of one or more of the following components:

Functions
Operators
Variables
Literals

The following table describes the general attributes that are available in all expression editor dialog boxes:

Attribute	Value	Description
Enter Expression	User-defined	Specifies an expression using the available functions, variables, values, and operators.
Operator buttons	System-defined	Click to insert an operator into your expression.
Check Syntax	System-defined	Click to confirm if an expression has been completed and ordered correctly.
Test	System-defined	Click to evaluate the expression. The Test Expression dialog box appears.
Test Expression dialog box	N/A	Click the Test button to open this dialog box. Click Evaluate to evaluate the expression. Or, if you use a predefined variable as part of your expression, enter the value here.
Functions tab	N/A	Displays the functions available to build your expression. Double-click a function to insert it into your expression.
Variables tab	N/A	Displays the variables available to build your expression. Double-click a variable to insert it into your expression.
Workflow Variables tab	N/A	Displays the workflow variables available to build your expression. This tab is only available when you are in a workflow.

Note: The property you are creating an expression for and its data type are displayed in the Expression Editor in the upper left and upper right, respectively.