WiscIT - Expressions and Logic

This document explains how to configure Expressions within the WiscIT Cherwell Client.

Expressions are useful for deciding between cases or returning specific values

Creating an Expression

Expressions can be made from many places, so the steps below may not apply in your specific situation. These steps list how to create a general expression.

  1. Open the Expression Manager, either by opening it through a One-Step, Dashboard, or Search Editor.
  2. Set the association to the Business Object the expression will be used for.
  3. Right click in the Expression Manager, and select "New". You can also select the green (+) button. Note that you may not have access to all of the folders in WiscIT, see WiscIT - Folder Explanation in Cherwell.
  4. Give the expression a name and a description.
  5. Example of the Name and Description Fields in the Cherwell Editor
  6. Select the type of Expression that you would like to create in the "Editor" field. There are many different types that can return a variety of results. Some common ones are described in the below sections

Configuring a Logical Expression

Logical expressions will return true or false when run.

Example of the Logical Expression Editor
  1. On the left side of the argument, click the arrow to select a field to compare to. A list of fields from business objects from the current scope will populate the dropdown, and you can show or hide these fields by clicking the (+) button to the left of it.
  2. Select an operator like "Equals", "Like", or "Not Equal".
  3. On the right side, type in or select a field from the dropdown menu. This is the field that will be compared against.

A configured logical expression is shown below.

Example of the completed logical expression

Creating a Case Expression

The case expression will return something based on which logical condition is true. The case expression can have many different logical expressions inside of it.

Example of a Case Expression in the Editor
  1. Select the "If then empty" case.
  2. Enter a logical expression using the steps listed above.
  3. Under the "Then Assign this" section, select the value that you want to return in this situation. Note that you can return almost anything, including other expressions.

Creating a Text Expression

A text expression will return a string, usually of some data that has been text-formatted

Example of a Text Expression
  1. In the large text-box, right click and select a field.
  2. Right click the field that has appeared and select "Modifiers...". You can add text-modifiers that change the formatting.
  3. You can also type text into this expression, as well as several different fields until it returns the text in your desired format.


Keywords:
Cherwell expression logical cases case decide decision one-step onestep one step 
Doc ID:
91873
Owned by:
Will C. in WiscIT
Created:
2019-05-20
Updated:
2023-07-19
Sites:
DoIT Help Desk, WiscIT - Wisconsin IT Service Manager