In this Page
Expression |
| |
---|---|---|
Description | This example is one way of doing an if-then-else expression. | |
Example | For example, to set a default pipeline variable in a document object, if you use the following expression for a mapper variable
|
Expression |
| |
---|---|---|
Description | The expression verifies if $customer.lastname and $customer.lastname.trim() has a value. If it does, then the value of $customer.lastname.trim() is applied to the target path, otherwise 'default' gets applied to the target path. |
Expression |
| |
---|---|---|
Description | The expression verifies if $customer.lastname exists in the input document. It returns True if $customer.lastname exists, else it shows 'default' as a string and applies it to the target path. |
Expression |
| |
---|---|---|
Description | The expression verifies if a property exists in the input document and if $customer.lastname and $customer.lastname.trim() provide a value. If it does then it applies its value to the target path, otherwise it applies 'default' to the target path. |
Expression |
| ||
---|---|---|---|
Description | Either expression grabs the first letter of the $first_name field, converts it to lowercase, then adds it to the $last_name value and appends "@example.com" before writing it to $Email. |
Expression |
| |
---|---|---|
Description | The expression creates the current date time in the PST timezone and formats its output into a string in the form of yyyy-MM-dd. |
Expression |
| |
---|---|---|
Description | The expression creates the current date time and format its output into a string to include the letter "T" and "Z". Characters outside of normal SQLDate specials can be added by escaping them. |
Expression |
| |
---|---|---|
Description | The expression creates the current date time in the local time zone and formats its output into a string for the ISO date time format. |
Expression |
| |
---|---|---|
Description | This expression parses a string representation of $StandardDate into a DateTime object. The string representation should have one of the following formats:
|
Expression |
| ||
---|---|---|---|
Description | These examples parse the date into a DateTime object using the provided format. |
Expression |
| |
---|---|---|
Description | This expression takes today's date and formats the output in a string indicating the month in text. |
Expression |
| |
---|---|---|
Description | Used in a Filter Snap, this expression finds only those items that have $Priority set to either Resolve Immediately or High Attention. |
Expression |
| |
---|---|---|
Description | Used in a Filter Snap, this expression finds only those items that are in the $Workflow step of Ready for Testing and $Priority is set to either Resolve Immediately or High Attention. |
Expression |
| |
---|---|---|
Description | Used in a Filter Snap, this expression finds only those items that have a $CloseDate within the last 24 hours. |
Expression |
| |
---|---|---|
Description | This expression turns the value of the $ID field into a HTML link pointing to the location found in the $Link field. |
This series of expressions maps data from:
[ { "ORG_ASSIGNMENT": [ { "ORGTXT": "Network Services", "JOBTXT": "Service technician", "POSTXT": "Manager" } ] |
to name/value pairs within an array:
[ "Organization": { "Unit": [ [ "Position", "Manager" ], [ "Grade", "Service technician" ], [ "Division", "Network Services" ] ] } ] |
Expression |
| |
---|---|---|
Target path | $Users.User[*].Organization.Unit[0] |
Expression |
| |
---|---|---|
Target path | $Users.User[*].Organization.Unit[1] |
Expression |
| |
---|---|---|
Target path | $Users.User[*].Organization.Unit[3] |