This table is a searchable listing of all Appian functions, including those that render interface components or execute smart services. You can filter by function category and/or feature compatibility with portals, offline mobile, or custom record field expressions.
Category | Sub Category | CatDesc | SubCatDesc | Name | Description | Syntax | Example | Result | Compatibility |
---|---|---|---|---|---|---|---|---|---|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dashboardLayoutColumns() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!formLayoutColumns() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sectionLayoutColumns() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | thread() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | message() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | a!flatten() | Converts an array that contains other arrays into an array of single items. |
a!flatten([array]) | a!flatten(merge({1,2},{11, 12})) | {1, 11, 2, 12} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | a!update() | Inserts new values or replaces existing values at the specified index or field name and returns the resulting updated data. |
a!update([data], [index], [value]) | a!update(a!map(a: 1, b: 2), "a", 5) | a!map(a: 5, b: 2) |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | append() | Appends a value or values to the given array, and returns the resulting array. |
append([array], [value]) | append({10, 20, 30}, 99) | {10, 20, 30, 99} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | index() | Returns the data[index] if it is valid or else returns the default value. |
index([data], [index], [default]) | index({10, 20, 30}, 2, 1) | 20 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | insert() | Inserts a value into the given array and returns the resulting array. |
insert([array], [value], [index]) | insert({10, 20, 30, 40}, 99, 1) | {99, 10, 20, 30, 40} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | joinarray() | Concatenates the elements of an array together into one string and inserts a string separator between each element. |
joinarray([array], [separator]) | joinarray({1, 2, 3, 4}, "|") | 1|2|3|4 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | ldrop() | Drops a given number of values from the left side of an array and returns the resulting array. |
ldrop([array], [number]) | ldrop({10, 20, 30}, 1) | {20, 30} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | length() | This function returns the number of elements in an array. |
length([array]) | length({10, 20, 30}) | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | rdrop() | Drops a given number of values from the right side of an array, and returns the resulting array. |
rdrop([array], [number]) | rdrop({10, 20, 30}, 1) | {10, 20} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | remove() | Removes the value at a given index from an array, and returns the resulting array. |
remove([array], [index]) | remove({10, 20, 30}, 2) | {10, 30} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | reverse() | Returns an array in reverse order. |
reverse([array]) | reverse({10, 20, 30}) | {30, 20, 10} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | updatearray() | Inserts new values or modifies existing values at the specified index of a given array, and returns the resulting array. |
updatearray([array], [index], [value]) | updatearray({10, 20, 30}, 2, 99) | {10, 99, 30} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | where() | Returns the indices where the values in the input array are true. |
where([booleanArray], [default]) | where({true, false, true}) | {1, 3} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | wherecontains() | Receives one or more values and returns an array of indices that indicate the position of the values within the array. |
wherecontains([values], [array]) | wherecontains(20, {10, 20, 30}) | {2} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | bin2dec() | Converts a Binary number as text to a Decimal number. |
bin2dec([value]) | bin2dec(10000) | 16 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | bin2hex() | Converts a Binary number as text to a Hex number as text. |
bin2hex([value], [place]) | bin2hex(1100100) | 64 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | bin2oct() | Converts a Binary number as text to an Octal number as text. |
bin2oct([value], [place]) | bin2oct(1100100) | 144 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | dec2bin() | Converts a Decimal number to a Binary number as text. |
dec2bin([value], [place]) | dec2bin(16) | 10000 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | dec2hex() | Converts a Decimal number to a Binary number as text. |
dec2hex([value], [place]) | dec2hex(16) | 10 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | dec2oct() | Converts a Decimal number to an Octal number as text. |
dec2oct([value], [place]) | dec2oct(16) | 20 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | hex2bin() | Converts a Hex number as text to a Binary number as text. |
hex2bin([value], [place]) | hex2bin(64) | 1100100 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | hex2dec() | Converts a Hex number as text to a Decimal number. |
hex2dec([value]) | hex2dec(10) | 16 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | hex2oct() | Converts a Hex number as text to an Octal number as text. |
hex2oct([value], [place]) | hex2oct(64) | 144 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | oct2bin() | Converts an Octal number as text to a Binary number as text. |
oct2bin([value], [place]) | oct2bin(144) | 1100100 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | oct2dec() | Converts an Octal number as text to a Decimal number. |
oct2dec([value]) | oct2dec(20) | 16 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | oct2hex() | Converts an Octal number as text to a Hex number as text. |
oct2hex([value], [place]) | oct2hex(144) | 64 |
~portal~om+crf
Partially compatible
Portals
Partially compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCopyDocumentFromAppian() | Copies an Appian document to a location in the CMIS target system, specified by the value of the objectId parameter. |
a!cmiCopyDocumentFromAppian([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [properties], [appianDocument], [appianDocumentVersion], [appianDocumentAllowExpired]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCopyDocumentToAppian() | Copies a document from the CMIS target system to Appian, creating a new version of an existing Appian document. |
a!cmiCopyDocumentToAppian([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [appianDocument]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCopyDocumentToAppianFolder() | Copies a document from the CMIS target system to an Appian folder, creating a new document. |
a!cmiCopyDocumentToAppianFolder([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [appianFolder]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCreateFolder() | Creates a folder in the CMIS target system. |
a!cmiCreateFolder([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [parentId], [properties]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiDelete() | Deletes an object in the CMIS target system. |
a!cmiDelete([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [allVersions]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetFolderChildren() | Retrieves the children of the folder given as the |
a!cmiGetFolderChildren([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [folderId], [pagingInfo]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetObjectIdByPath() | Retrieves the object id of a CMIS object based on the value given as the |
a!cmiGetObjectIdByPath([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [path]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetProperties() | Retrieves the properties of the CMIS object given as the |
a!cmiGetProperties([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetRepoInfo() | Retrieves information about the target CMIS target system repository. |
a!cmiGetRepoInfo([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynAssociate() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynCreate() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynDelete() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynDisassociate() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynRetrieve() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynRetrieveMultiple() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynUpdate() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpAuthenticationBasic() | Creates an object that contains the information required to perform HTTP Basic authentication. |
a!httpAuthenticationBasic([username], [password], [preemptive]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpFormPart() | Creates an HTTP form part which can be passed in an integration’s multipart request body. |
a!httpFormPart([name], [contentType], [value]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpHeader() | Creates an HTTP header object which can be passed to an HTTP function. |
a!httpHeader([name], [value]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!httpQuery() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpQueryParameter() | Creates an HTTP query parameter object which can be passed to an HTTP function. |
a!httpQueryParameter([name], [value]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!httpWrite() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!scsField() | Creates an object which contains the information required to access data in the Secure Credentials Store. |
a!scsField([externalSystemKey], [fieldKey], [usePerUser]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | reCAPTCHA | ConnectorUsed to integrate Appian with popular enterprise software solutions. | reCAPTCHAThe reCAPTCHA connector allows you to connect to Google reCAPTCHA services. | a!verifyRecaptcha() | Allows you to verify the reCAPTCHA connection was successful and access reCAPTCHA scores to help protect your Portal against potentially malicious activity. |
a!verifyRecaptcha([onSuccess], [onError]) | Click on the function name for examples. |
+portal-om-crf
Compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | SAP | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SAPThe SAP connector uses the SAP JCo 3.0 middleware library to connect to a SAP ERP systems release 3.1H or later. | a!sapBapiParameters() | Retrieves the list of parameters required to call the given SAP BAPI. |
a!sapBapiParameters([scsExternalSystemKey], [usePerUserCredentials], [hostname], [clientNumber], [systemNumber], [connectionProperties], [bapi]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | SAP | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SAPThe SAP connector uses the SAP JCo 3.0 middleware library to connect to a SAP ERP systems release 3.1H or later. | a!sapInvoke() | Invokes the given BAPI, returning the result. |
a!sapInvoke([scsExternalSystemKey], [usePerUserCredentials], [hostname], [clientNumber], [systemNumber], [connectionProperties], [bapi], [importParameters], [tableParameters]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sapInvokeWriter() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblCreate() | Creates a new record in Siebel. |
a!sblCreate([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [parameters], [fieldValues]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblDelete() | Deletes a record from Siebel. |
a!sblDelete([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [parameters]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblInvoke() | Invokes the method in Siebel, returning the result. |
a!sblInvoke([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [businessService], [method], [parameters]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblInvokeWriter() | Invokes the method that will result in a modification to data in Siebel. |
a!sblInvokeWriter([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [businessService], [method], [parameters]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblQuery() | Retrieves records from Siebel. |
a!sblQuery([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [sort], [parameters]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblUpdateFieldValue() | Updates the values of the given record in Siebel. |
a!sblUpdateFieldValue([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [fieldValues], [parameters]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcDelete() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcDescribeGlobal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcDescribeSObjects() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcInsert() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcQuery() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcSearch() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcUpdate() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpCopyDocumentFromAppian() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpCopyDocumentToAppian() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpInvoke() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpInvokeWriter() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsConfig() | Constructs the config parameter to the |
a!wsConfig([wsdlUrl], [service], [port], [operation], [wsdlCredentials], [endpointcredentials], [extensions]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsHttpCredentials() | Constructs a WsHttpCredentials object for use with |
a!wsHttpCredentials([username], [password], [domain]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsHttpHeaderField() | Constructs a WsHttpHeaderField object for use with |
a!wsHttpHeaderField([name], [name]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsUsernameToken() | Constructs a WsUsernameToken object for use with |
a!wsUsernameToken([username], [password]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsUsernameTokenScs() | Constructs a WsUsernameTokenScs object for use with |
a!wsUsernameTokenScs([systemKey], [usePerUser]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Conversion | ConversionUsed to cast data from one data type into another. | displayvalue() | Tries to match a value in a given array with a value at the same index in a replacement array and returns either the value at the same index or a default value if the value is not found. |
displayvalue([value], [inArray], [replacement], [default]) | displayvalue( 1, {0, 1, 2}, {"Low", "Medium", "High"}, "Unknown" ) | Medium |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | externalize() | Converts the given value to a string representation so that it can be saved externally. |
externalize([value]) | externalize(todocument(1)) |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
|||
Conversion | ConversionUsed to cast data from one data type into another. | internalize() | Converts the given externalized string representation of a value to the original value. |
internalize([externalizedText], [default]) | internalize(externalize(todocument(1))) | [Document:1] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toboolean() | Converts a value to Boolean. |
toboolean([value]) | toboolean(0) | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | tocommunity() | Converts a value to Community. |
tocommunity([value]) | tocommunity(1) | [Community:1] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | todate() | Converts a value to Date with Timezone. |
todate([value]) | todate(0) | 1/1/2035 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | todatetime() | Converts a value to Date and Time. |
todatetime([value]) | todatetime(date(2005, 12, 13)) | 12/13/05 12:00 AM GMT |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | todecimal() | Converts a value to Decimal (double precision floating point). |
todecimal([value]) | todecimal("3.6") | 3.6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | todiscussionthread() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Conversion | ConversionUsed to cast data from one data type into another. | todocument() | Converts a value to Document. |
todocument([value]) | todocument(1) | [Document:1] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toemailaddress() | Converts a value to email address. |
toemailaddress([value]) | toemailaddress("john.doe"&char(64)&"company.com") | john.doe@company.com |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toemailrecipient() | Converts a value to email recipient. |
toemailrecipient([value]) | toemailrecipient(togroup(1)) | [Group:1] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | tofolder() | Converts a value to Folder. |
tofolder([value]) | tofolder({"1","2"}) | [Folder:1], [Folder:2] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | toforum() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Conversion | ConversionUsed to cast data from one data type into another. | tointeger() | Converts a value to Integer. |
tointeger([value]) | tointeger("3") | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | tointervalds() | Converts a value to Interval (Day to Second). |
tointervalds([value]) | tointervalds("11h 10m 30s") | 111030::00:00:00.000 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toknowledgecenter() | Converts a value to Knowledge Center. |
toknowledgecenter([value]) | toknowledgecenter("2") | [Knowledge Center:2] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | tomessage() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | topage() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | toportlet() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Conversion | ConversionUsed to cast data from one data type into another. | tostring() | Converts a value to Text. |
tostring([value]) | tostring(17) | "17" |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | totime() | Converts a value to Time. |
totime([value]) | totime(datetime(2005, 12, 13, 12, 0, 0)) | 12:00 PM GMT |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | touniformstring() | Converts a value to Text, preserving the original scalar or array structure. |
touniformstring([value]) | touniformstring("John Doe 1060 West Addison Chicago", "IL") | {"John Doe 1060 West Addison Chicago", "IL"} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Custom Record Field | Custom Record Field | a!customFieldDateDiff() | Used to create a custom record field, this function returns the difference between two dates as a Number (Integer). The difference can be returned in days, hours, minutes, or seconds. Returns null when the |
a!customFieldDateDiff([startDate], [endDate], [interval]) | Click on the function name for examples. |
-portal-om~crf
Incompatible
Portals
Incompatible Offline Mobile Partially compatible Custom Record Field Expressions |
|||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | caladddays() | This function adds a given number of working days as designated on the process calendar to a Date and Time value, and returns a Date and Time value that falls within the work time defined in the process calendar. |
caladddays([start_datetime], [number], [calendar_name]) | caladddays(datetime(2011, 12, 13, 12, 0, 0), 0) | 12/13/2011 12:00 PM GMT |
-portal-om+crf
Incompatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | caladdhours() | This function adds a given number of hours to a Date and Time plus any non-working hours (as designated on the process calendar) and returns the resulting Date and Time. |
caladdhours([start_datetime], [number], [calendar_name]) | caladdhours(datetime(2011, 12, 13, 12, 0, 0), 12) | 12/14/2011 4:00 PM GMT |
-portal-om+crf
Incompatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calisworkday() | This returns whether or not the given Date and Time is a work day, according to the calendar defined for the system. |
calisworkday([datetime], [calendar_name]) | calisworkday(datetime(2011, 12, 13, 12, 0, 0)) | true |
-portal-om+crf
Incompatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calisworktime() | This returns whether or not the given Date and Time is within working hours, according to the calendars defined for the system. |
calisworktime([datetime], [calendar_name]) | calisworktime(datetime(2011, 12, 13, 12, 0, 0)) | true |
-portal-om+crf
Incompatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calworkdays() | This returns the actual number of work days between two Date and Times (both inclusive), according to the calendar defined for the system. |
calworkdays([start_datetime], [end_datetime], [calendar_name]) | calworkdays(datetime(2011, 12, 13, 12, 0, 0), datetime(2011, 12, 20, 12, 0, 0)) | 6 |
-portal-om+crf
Incompatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calworkhours() | This returns the actual number of work hours between two given Date and Times (both inclusive), according to the calendar defined for the system. |
calworkhours([start_datetime], [end_datetime], [calendar_name]) | calworkhours(datetime(2011, 12, 12, 12, 0, 0), datetime(2011, 12, 13, 12, 0, 0)) | 8 |
-portal-om+crf
Incompatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | date() | Converts text into data accepted by the date data type and functions that require date parameters. |
date([year], [month], [day]) | date(2011, 12, 13) | 12/13/2011 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | datetime() | Converts the given Date and Time into a serial number that holds the Date and Time data type. |
datetime([year], [month], [day], [hour], [minute], [second]) | datetime(2011, 12, 13, 12, 0, 0) | 12/13/2011 12:00 PM GMT |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | datevalue() | Converts a value to a date. |
datevalue([value]) | datevalue(0) | 1/1/2035 |
+portal-om+crf
Compatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | day() | Returns the day of the month from the day specified. |
day([date]) | day(datetime(2011, 12, 13, 12, 0, 0)) | 13 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | dayofyear() | Returns the day number within the year. |
dayofyear([date]) | dayofyear(date(1957, 03, 14)) | 73 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | days360() | Returns the number of days between two dates, based on a 360-day calendar. |
days360([start_date], [end_date], [method]) | days360(today(), today() + 365, 0) | 360 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | daysinmonth() | Returns the number of days in the given month in the given year. |
daysinmonth([month], [year]) | daysinmonth(2, 1800) | 28 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | edate() | Returns the date that is the number of months before or after the given starting date. |
edate([starting_date], [months]) | edate(date(2011, 12, 13), -6) | 6/13/11 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | eomonth() | Returns the date for the last day of the month that is the number of months before or after the given starting date. |
eomonth([starting_date], [months]) | eomonth(date(2011, 12, 13), -6) | 6/30/2011 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | gmt() | Subtracts a time zone offset from a given Date and Time. |
gmt([datetime], [timezone]) | gmt(datetime(2011, 12, 13, 12, 05), "America/New_York") | 12/13/2011 5:05 PM GMT |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | hour() | Returns the hour from the time specified. |
hour([time]) | hour(time(14, 20, 23)) | 14 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | intervalds() | Converts the given time components into an equivalent time duration, an interval expressing days to seconds. This value is treated as a duration (Joe ran the marathon in 3 hours and 23 minutes), not a point in time. |
intervalds([hour], [minute], [second]) | intervalds(2, 4, 5) | 0::02:04:05.000 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | isleapyear() | Returns a Boolean value for whether the given year is a leap year. |
isleapyear([year]) | isleapyear(1996) | True |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | lastndays() | Returns a Boolean value for whether the given date is within the last given number of days. |
lastndays([date], [n]) | lastndays(date(2011, 12, 13), 6) | False |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | local() | This is a Date and Time addition function, adding time zone offset to given Date and Time. |
local([datetime], [timezone]) | local(datetime(2011, 12, 13, 12, 05), "America/New_York") | 12/13/2011 7:05 AM GMT |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | milli() | This function returns the millisecond portion of a timestamp or the decimal number that represents 1 millisecond in days. |
milli([time]) | milli(datetime(2011, 12, 13, 12, 0, 0, 25)) | 25 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | minute() | Returns the minute from the time specified. |
minute([time], [minute]) | minute(time(14, 20, 23)) | 20 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | month() | Returns the month from the specified date. |
month([date]) | month(date(2011, 12, 13)) | 12 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | networkdays() | Returns the number of working days between two specified dates. |
networkdays([starting_date], [ending_date], [holidays]) | networkdays(date(2011, 12, 13), date(2011, 12, 20)) | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | now() | Returns the current Date and Time as a serial number. |
now([]) | now() | 2/2/2022 2:02 PM |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | second() | Returns the seconds from the specified time. |
second([time]) | second(time(14, 20, 23)) | 23 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | time() | Converts the given time into an equivalent time value. |
time([hour], [minute], [second], [millisecond]) | time(14, 20, 23) | 2:20 PM |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | timevalue() | Converts the given time into an equivalent interval. |
timevalue([time_text]) | timevalue(time(14, 20, 23)) | 2:20 PM |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | timezone() | Returns the default offset in minutes from GMT, which is generally the process initiator's time zone. |
timezone([]) | timezone() | 0 |
+portal-om+crf
Compatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | timezoneid() | Returns the time zone ID for the current context. |
timezoneid([]) | timezoneid() | GMT |
+portal-om+crf
Compatible
Portals
Incompatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | today() | Returns the current day in GMT. |
today([]) | today() | 2/2/2022 |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | weekday() | Returns the day of the week of the specified date. |
weekday([date], [return_type]) | weekday(date(2011, 12, 13)) | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | weeknum() | Returns the week number within the year for the given date using a given methodology. |
weeknum([date], [methodology]) | weeknum(date(2011, 12, 13)) | 51 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | workday() | Returns the date the given number of workdays before or after the given date. |
workday([starting_date], [days], [holidays]) | workday(date(2011, 12, 13), -6) | 12/5/2011 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | year() | Returns the year for the date specified. |
year([date]) | year(date(2011, 12, 13)) | 2011 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | yearfrac() | Determine the fraction of the year. |
yearfrac([start_date], [end_date], [method]) | yearfrac(today(), today() + 270, 3) | 0.739726 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Smart Service | Document Management | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Document Management | a!docExtractionResult() | Retrieves results from a doc extraction run started by the Start Doc Extraction Smart Service. |
a!docExtractionResult([docExtractionId], [typeNumber], [confidenceThreshold], [isStructuredDoc]) | a!docExtractionResult(docExtractionId:5) | ANYTYPEDATACDT |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
Smart Service | Document Management | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Document Management | a!docExtractionStatus() | Retrieves the status of a doc extraction run started by the Start Doc Extraction Smart Service. |
a!docExtractionStatus([docExtractionId]) | a!docExtractionStatus(docExtractionId:5) | IN_PROGRESS |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
Evaluation | EvaluationUsed in expression to perform complex evaluations. | a!localVariables() | Lets you define one or more local variables for use within an expression. When used within an interface, the value of each variable can be refreshed under a variety of conditions, configured using a!refreshVariable(). When used outside of an interface, all refresh properties configured using a!refreshVariable() are ignored. |
a!localVariables([localVar1], [localVarN], [expression]) | Click on the function name for examples. |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | a!refreshVariable() | The configuration for a specific local variable for use within a!localVariables(). When used within an interface, the value of the variable can be refreshed under a variety of conditions. When used outside of an interface, all refresh properties are ignored. |
a!refreshVariable([value], [refreshAlways], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange], [refreshAfter]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | bind() | Use in conjunction with the load function to bind getter and setter functions to a variable. When the variable is read, the getter function or rule will be called. When the variable is saved into, the writer returned by the setter function or rule will be called. The setter function must return a writer. |
bind([get], [set]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | load() | Lets you define local variables within an expression for an interface and evaluate the expression with the new variables, then re-evaluate the function with the local variables' values from the previous evaluation. |
load([localVar1], [localVarN], [expression]) | Click on the function name for examples. |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | a!save() | In interface saveInto parameters, updates the target with the given value. Use a!save for each item that you want to modify or alter in a |
a!save([target], [value]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | with() | Lets you define local variables within a function and evaluate the expression with the new variables. |
with([localVar1], [localVarN], [expression]) | with(local!a:10, local!b:20, local!a+local!b) | 30 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!defaultValue() | Returns a default value when the specified value is null or empty. When there are multiple default parameters, each parameter is evaluated in order and the first non-null and non-empty default will be returned. |
a!defaultValue([value], [default]) | a!defaultValue( null, date(2021,10,1), null) | `2021-10-01` |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!keys() | Returns the keys of the provided map, dictionary, CDT, or record. |
a!keys([value]) | a!keys(a!map(a: 1, b: 2)) | {"a"=>nil, "b"=>nil} |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!listType() | Returns the list type number for a given type number. |
a!listType([typeNumber]) | a!listType(typeof(1)) |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | byReference() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Informational | InformationalUsed within expressions to expose system values and translate other information. | cast() | Converts a value from its existing type to the specified type. |
cast([typeNumber], [value]) | cast(type!Date,"01-01-2017") | 1/1/2017 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | error() | Raises an error with the given message, used for invalidating execution.This function never returns a value. |
error([message]) | error("This is an error message.") | Expression evaluation error at function 'error': This is an error message. |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | infinity() | Represents a constant number that stands for positive infinity or a negative infinity if you negate the value. |
infinity([]) | infinity() | ∞ |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | isinfinite() | Tests given numbers against positive and negative infinity, returning |
isinfinite([number]) | isinfinite(1.5, 1.1) | false; false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | isnegativeinfinity() | Tests given numbers against negative infinity, returning true if number is negative infinity, false if number is not negative infinity. |
isnegativeinfinity([number]) | isnegativeinfinity(1) | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!isNotNullOrEmpty() | Returns |
a!isNotNullOrEmpty([value]) |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||||
Informational | InformationalUsed within expressions to expose system values and translate other information. | isnull() | Returns true if value is null, false otherwise. |
isnull([value]) | isnull("") | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!isNullOrEmpty() | Returns |
a!isNullOrEmpty([value]) |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||||
Informational | InformationalUsed within expressions to expose system values and translate other information. | ispositiveinfinity() | Tests given numbers against positive infinity, returning |
ispositiveinfinity([number]) | ispositiveinfinity(1) | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | nan() | Constant number representing Not A Number, generally used for comparison to the result of mathematical operations with invalid inputs. This is equivalent to a decimal (floating point) null, but nan() is provided for more explicit usage in mathematical expressions. |
nan([]) | nan() | null |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | null() | Returns a null value. |
null([value]) | null() | null |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | runtimetypeof() | Returns the numerical representation of an Appian system data type when used during process execution. |
runtimetypeof([value]) | runtimetypeof( 12345) | 9 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | typename() | Returns the type name of a given type number. |
typename([typeNumber]) | typename(typeof(1)) | Number (Integer) |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | typeof() | Returns the type number of a given value. |
typeof([value]) | typeof("a") | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | and() | Returns |
and([value]) | and(true(), false()) | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | choose() | Evaluates the |
choose([key], [choice1], [choiceN]) | choose(2, "a", "b", "c") | b |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | false() | Returns the Boolean value |
false([returns]) | false() | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | if() | Returns |
if([condition], [valueIfTrue], [valueIfFalse]) | if(isleapyear(2021), 1, 2) | 2 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | a!match() | Evaluates the value against multiple conditions and returns a value based on a match. If no match is found, the default is returned. For example, if "a" then "b" else "c". |
a!match([value], [equals], [whenTrue], [then], [default]) | Click on the function name for examples. |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
|||
Logical | LogicalUsed within expressions to derive logical results. | not() | Converts |
not([value]) | not(true(), false()) | false, true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | or() | Returns |
or([value]) | or(true(), false()) | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | true() | Returns the Boolean value |
true([returns]) | true() | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | a!forEach() | Evaluates an expression for each item in a list and returns a new array of the results. |
a!forEach([items], [expression]) | a!forEach(items: {1, 2, 3}, expression: fv!item + 10) | {11, 12, 13} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | all() | Calls a rule or function that returns either true or false for each item in list, asks the question, "Do all items in this list yield true for this rule/function?", and returns true if all items in list evaluates to true. |
all([predicate], [list], [context]) | all(fn!isnull, {10, null, 30}) | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | any() | Calls a rule or function that returns either true or false for each item in list by asking the question, "Do any items in this list yield true for this rule/function?" with the intent to discover if any item(s) yield true. |
any([predicate], [list], [context]) | any(fn!isnull, {10, null, 30}) | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | apply() | Calls a rule or function for each item in a list, and provides any contexts specified. |
apply([function], [list], [context]) | apply(fn!sum, {-1, 2, 3}, 2) | {1, 4, 5} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | filter() | Calls a predicate for each item in a list and returns any items for which the returned value is true. |
filter([predicate], [list], [context]) | filter(fn!isleapyear, {2015, 2016, 2017}) | {2016} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | merge() | Takes a variable number of lists and merges them into a single list (or a list of lists) that is the size of the largest list provided. |
merge([list]) | merge({10, 20}, {30, 40}) | {{10, 30}, {20, 40}} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | none() | Calls a rule or function that returns either true or false for each item in list by asking the question, "Do all items in this list yield false for this rule/function?" with the intent to discover if no items will yield true. |
none([predicate], [list], [context]) | none(fn!isnull, {1, null, 3}) | false |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | reduce() | Calls a rule or function for each item in a list, passing the result of each call to the next one, and returns the value of the last computation. |
reduce([function], [initial], [list], [context]) | reduce(fn!sum, 1, {2, 3, 4}) | 10 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | reject() | Calls a predicate for each item in a list, rejects any items for which the returned value is true, and returns all remaining items. |
reject([predicate], [list], [context]) | reject(fn!isnull, {1, null, 3}) | {1, 3} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | abs() | Returns the absolute value(s) of the specified number(s). |
abs([number]) | abs(-1) | 1 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | ceiling() | Rounds the number up to the nearest multiple of the specified significance. |
ceiling([number], [significance]) | ceiling(1.6) | 2 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | combin() | Calculates the number of unique ways to choose m elements from a pool of n elements. |
combin([n], [m]) | combin(4, 2) | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | a!distanceBetween() | Returns the distance between the two locations (in meters) specified by the start and end coordinates. The distance is calculated by tracing a line between the two locations that follows the curvature of the Earth, and measuring the length of the resulting arc. |
a!distanceBetween([startLatitude], [startLongitude], [endLatitude], [endLongitude]) | a!distanceBetween(startLatitude: 38.932290, startLongitude: -77.218490, endLatitude: 38.963058, endLongitude: -77.363701) | 13015.34 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | e() | Returns the value of e. |
e([]) | e() | 2.718282 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | enumerate() | Returns a list of integer numbers from 0 through n-1. |
enumerate([n]) | enumerate(5) | 0, 1, 2, 3, 4 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | even() | Rounds positive numbers up to nearest even integer and negative numbers down to the nearest even integer. |
even([number]) | even(5) | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | exp() | Returns e raised to the specified power. |
exp([power]) | exp(2) | 7.389056 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | fact() | The factorial of specified number. |
fact([number]) | fact(4) | 24 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | factdouble() | The double factorial of specified number (mathematically n!!). |
factdouble([number]) | factdouble(3) | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | floor() | Rounds the number down to the nearest multiple of the specified significance. |
floor([number], [significance]) | floor(2.8888, .01) | 2.88 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | int() | Rounds the specified number down to the nearest integer. |
int([number]) | int(2.8888) | 2 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | ln() | Returns the natural logarithm of the specified number, which is the power that e must be raised to in order to equal the specified number. |
ln([number]) | ln(e()) | 1 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | log() | Returns the logarithm of the number using the specified base, which is the power that base must be raised to, to equal the number. |
log([number], [base]) | log(25, 5) | 2 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | mod() | Returns the remainder of dividend when divided by the divisor. |
mod([dividend], [divisor]) | mod(40, 15) | 10 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | mround() | Rounds the number to the specified multiple. |
mround([number], [multiple]) | mround(2.8888, .01) | 2.89 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | multinomial() | Adds the specified integers and divides the factorial of the sum by the factorial of the individual numbers. |
multinomial([integer]) | multinomial(1, 2, 3) | 60 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | odd() | Rounds positive numbers up to nearest odd integer and negative numbers down to the nearest odd integer. |
odd([number]) | odd(10) | 11 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | pi() | Returns the value of pi. |
pi([]) | pi() | 3.141593 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | power() | Returns the base number raised to the specified exponent. |
power([base], [exponent]) | power(10, 2) | 100 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | product() | Returns the product of the specified numbers. |
product([factor]) | product(10, 2) | 20 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | quotient() | Returns the quotient when numerator is divided by the denominator, and drops the remainder. |
quotient([numerator], [denominator]) | quotient(20, 10) | 2 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | rand() | Returns a random number between 0 and 1 based on an even probability distribution, which is seeded by the transaction time. |
rand([count]) | rand() | 0.4506349 |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | round() | Rounds off the number to the specified number of digits. |
round([number], [num_digits]) | round(2.8888, 2) | 2.89 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | rounddown() | Rounds the number down to the specified digit. |
rounddown([number], [num_digits]) | round(2.8888, 2) | 2.88 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | roundup() | Rounds the number up to the specified digit. |
roundup([number], [num_digits]) | round(2.8888, 2) | 2.89 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sign() | Returns the number divided by its absolute value, which is 1 if the number is positive and -1 if the number is negative. |
sign([number]) | sign(-10) | -1 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sqrt() | Returns the square root(s) of the specified number(s). |
sqrt([number]) | sqrt(25) | 5 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sqrtpi() | Multiplies the number by pi, then returns the square root of the product. |
sqrtpi([number]) | sqrtpi(25 / pi()) | 5 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sum() | Returns the sum of the specified numbers. |
sum([addend]) | sum(1, 2, 3) | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sumsq() | Squares each number and then returns the sum of the squares. |
sumsq([number]) | sumsq(2,3) | 13 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | trunc() | Truncates a decimal number to the specified number of places after the decimal point. |
trunc([value], [numberOfDecimals]) | trunc(2.8888, 3) | 2.888 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!doesGroupExist() | Verifies whether a group with the specified group ID already exists in the environment. |
a!doesGroupExist([groupId]) | a!doesGroupExist(6) | true |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupMembers() | Returns a DataSubset of group members of a given group. |
a!groupMembers([group], [direct], [memberType], [pagingInfo]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupsByName() | Returns an array of groups with the given name, or an empty array if no group exists. |
a!groupsByName([groupName]) | a!groupsByName("Purchase Request Viewers - " & ri!prId) | {[Group:8]} |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupsByType() | Returns a DataSubset of the groups of a given group type. |
a!groupsByType([groupType], [pagingInfo]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupsForUser() | Returns the groups where the user is a member or has Administrator permissions. |
a!groupsForUser([username], [isGroupAdministrator], [groupTypes]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!isUserMemberOfGroup() | Identifies whether or not a user is a member of the specified groups. By default, this function returns true if the user is in at least one of the specified groups. |
a!isUserMemberOfGroup([username], [groups], [matchAllGroups]) | a!isUserMemberOfGroup("john.doe", 2) | false |
~portal+om-crf
Partially compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | getdistinctusers() | Retrieves users from a set of users and groups. |
getdistinctusers([peopleArray]) | getdistinctusers(topeople(cons!MY_GROUP)) | {test.user1, test.user2} |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | getgroupattribute() | Retrieves the value of the specified group attribute for the given group. |
getgroupattribute([group], [attribute]) | getgroupattribute(cons!MY_GROUP, "created") | 12/16/05 6:37 PM GMT |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | group() | Returns information for group. |
group([groupId], [property]) | group(2, "created") | 12/16/05 6:37 PM GMT |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | isusermemberofgroup 21r2() | Identifies whether or not a user belongs to a group. |
isusermemberofgroup_21r2([username], [groupId]) | isusermemberofgroup_21r2("john.doe", 2) | false |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | isusernametaken() | Verifies whether a user account with the specified username is already present. |
isusernametaken([username]) | isusernametaken("john.doe") | true |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | loggedInUser() | Returns the current user logged in to the application. |
loggedInUser([]) | loggedInUser() | current.user |
~portal+om-crf
Partially compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | supervisor() | Returns the supervisor of the user if they have one. |
supervisor([userinfo]) | supervisor("john.doe") | jane.smith |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | togroup() | Converts a value to Group. |
togroup([value]) | togroup(1) | [Group:1] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | topeople() | Converts a value to People. |
topeople([value]) | topeople(1, "john.doe") | {[Group:1], john.doe} |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | touser() | Converts a value to User. |
touser([value]) | touser("john.doe") | john.doe |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | user() | Returns information for a user. |
user([username], [property]) | user("jane.smith", "created") | 12/20/05 10:36 PM GMT |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!aggregationFields() | Used to define a query against record data that performs an aggregation in |
a!aggregationFields([groupings], [measures]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | a!isNativeMobile() | Returns true if the interface is being viewed within the Appian for Mobile application. Returns false otherwise. |
a!isNativeMobile([]) | Click on the function name for examples. | Boolean |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | a!isPageWidth() | Returns true if the interface is being viewed on a page that falls within the specified width ranges. Returns false otherwise. This function checks the width of the content area on the page, which may not be the width of the entire window. |
a!isPageWidth([pageWidths]) |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | a!urlForTask() | This function returns the URL of a process task given the task ID. |
a!urlForTask([taskIds], [returnTaskPathOnly]) | a!urlForTask(taskIds: 12345, returnTaskPathOnly: false) | https://<sitename>/suite/tempo/tasks/task/<task_path> |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | averagetaskcompletiontimeforprocessmodel() | Returns the average elapsed time in days between task assignment and task completion for all assigned, accepted, and completed tasks in all processes started from a given process model. |
averagetaskcompletiontimeforprocessmodel([Id], [includeSubProcessData]) | averagetaskcompletiontimeforprocessmodel(4) | 0.6979317434217448 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | averagetasklagtimeforprocessmodel() | Returns the average elapsed time in days between task assignment and task acceptance for all assigned, accepted, and completed tasks in processes for the specified process model. |
averagetasklagtimeforprocessmodel([Id], [includeSubProcessData]) | averagetasklagtimeforprocessmodel(4) | 0.4155682319223637 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | averagetaskworktimeforprocessmodel() | Returns the average elapsed time in days between task acceptance and task completion for all accepted and completed tasks in processes for this process model. |
averagetaskworktimeforprocessmodel([Id], [includeSubProcessData]) | averagetaskworktimeforprocessmodel(processModelId) | 0.00003523892184732956 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | community() | Returns the properties of a given community. |
community([communityId], [property]) | community(1, "numberOfDocuments") | 40 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | datetext() | Interprets the date or datetime specified in the user's preferred calendar and returns its string representation using given format. |
datetext([value], [format]) | datetext(userdatevalue("8/18/1427"), "yyyy/MM/dd") | 1427/8/18 |
+portal-om-crf
Compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | document() | Returns property information for a document. |
document([documentId], [property]) | document(101, "expirationDate") | 12/21/05 2:28 PM GMT |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | folder() | Returns a property of the requested folder. |
folder([folderId], [property]) | folder(54, "knowledgeCenterName") | System Knowledge Center |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | getprocessemail() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | getprocessmodelemail() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | isNativePhone() [Deprecated] |
isNativePhone() |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | isNativeTablet() [Deprecated] |
isNativeTablet() |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | isInDaylightSavingTime() | Returns whether the given date and timezone are in daylight saving time. |
isInDaylightSavingTime([date], [timezone]) | isInDaylightSavingTime(date(2005,12,13), "America/Los_Angeles") | false |
~portal+om-crf
Partially compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | knowledgecenter() | Returns the properties of a knowledge center. |
knowledgecenter([knowledgeCenterId], [property]) | knowledgecenter(2, "name") | System Knowledge Center |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktocommunity() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktocommunityinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktodocument() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktodocumentinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktofolder() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktofolderinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktogroup() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktogroupinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoknowledgecenter() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoknowledgecenterinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessdashboard() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessdashboardinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessmodeldashboard() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessmodeldashboardinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktouser() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktouserinternal() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numontimeprocessesforprocessmodel() | This function eturns the number of active and completed processes of the specified process model that are on time (not past the deadline). |
numontimeprocessesforprocessmodel([processModelId], [includeSubProcessData]) | numontimeprocessesforprocessmodel(processModelId, true) | 38 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numontimetasksforprocessmodel() | Returns the number of tasks in process instances of the specified process model that are currently on time (if the task is still active) or were completed on time. |
numontimetasksforprocessmodel([processModelId], [includeSubProcessData]) | numontimetasksforprocessmodel(processModelId, true) | 147 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numoverdueprocessesforprocessmodel() | Returns the number of active and completed processes for the specified process model, which are past the deadline. |
numoverdueprocessesforprocessmodel([processModelId], [includeSubProcessData]) | numoverdueprocessesforprocessmodel(processModelId) | 1 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numoverduetasksforprocessmodel() | Returns the number of tasks in both active and completed process instances of the specified process model, which are currently overdue (if the task is still active) or were completed past their deadline. |
numoverduetasksforprocessmodel([processModelId], [includeSubProcessData]) | numoverduetasksforprocessmodel(processModelId) | 10 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numprocessesforprocessmodelforstatus() | Counts and returns the number of process instances with the specified status for the process model. |
numprocessesforprocessmodelforstatus([processModelId], [status], [includeSubProcessData]) | numprocessesforprocessmodelforstatus(processModelId, "completed") | 38 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numtasksforprocessmodelforstatus() | Returns the number of tasks with the specified status in process instances of the process model. |
numtasksforprocessmodelforstatus([processModelId], [status], [includeSubProcessData]) | numtasksforprocessmodelforstatus(processModelId, "completed", true) | 112 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | offsetFromGMT() | Returns the offset (in minutes) from GMT of the given date and timezone. |
offsetFromGMT([date], [timezone]) | offsetFromGMT(date(2005,12,13), "America/Los_Angeles") | -480 |
~portal+om+crf
Partially compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | page() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | property() | This function extracts a bean's property under a given key name (the |
property([bean], [nameOfProperty], [valueIfMissing]) | property(msg!properties, "name", "no name was sent") | no name was sent |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | queryrecord() [Deprecated] |
queryrecord( recordType, query ) |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | repeat() | This function takes an input of Any Type and returns a list with the input repeated a specified number of times. |
repeat([times], [input]) | repeat(2, "strawberry") | {"strawberry", "strawberry"} |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | todatasubset() | The function takes an array of values as well as optional paging/sorting configurations and returns a DataSubset value with a subset of the array in a specified sort order and the total count of items in the initial array. |
todatasubset([arrayToPage], [pagingConfiguration]) | todatasubset({1, 2, 3}) | [startIndex=1, batchSize=-1, sort=, totalCount=3, data=1; 2; 3, identifiers=1; 2; 3] |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | topaginginfo() | Returns a PagingInfo value for use with the |
topaginginfo([startIndex], [batchSize]) | topaginginfo(1, 25) | [startIndex=1, batchSize=25] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | torecord() | Converts XML to a value of the given data type. |
torecord([xml], [type]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | toxml() | Converts a value to its equivalent XML form. |
toxml([value], [format], [name], [namespace]) | Click on the function name to see examples. |
|
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | urlforrecord() | This function allows you to return the URLs for one or more records or a record list view that can then be used in a link component. |
urlforrecord([recordType], [recordIds]) | urlforrecord(cons!MY_RECORD_TYPE) | "https://<sitename>/suite/tempo/records/type/<record_type>/view/all" |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | urlwithparameters() | This function allows you to build a URL from an expression, using arrays of process and constant data. |
urlwithparameters([parameterNames], [parameterValues]) | "<a href=" & urlwithparameters("/tio/viewPayments.do", {"claimNumber"}, 100) & ">View Payments</a>" | View Payments |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdate() | Identifies the date represented by year, month, and day and then interprets it in the user preferred calendar, converting it into a serial number. |
userdate([year], [month], [day]) | datetext(userdate(1427, 8, 18), "mm/dd/yyyy") | 8/18/1427 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdatetime() | Interprets the given date and time in the user preferred calendar and converts it into a serial number. |
userdatetime([year], [month], [day], [hour], [minute], [second]) | datetext(userdatetime(1427, 8, 18, 1, 2, 0)) | 08/18/1427 01:02 AM |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdatevalue() | Interprets the given date in the user preferred calendar and converts it into an equivalent serial number. |
userdatevalue([date_text]) | datetext(userdatevalue("8/18/1427"), "yyyy/MM/dd") returns | 38 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userday() | Returns the day of the month from the date or datetime specified in the user preferred calendar. |
userday([date]) | userday(11/31/2007) | 31 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdayofyear() | Returns the number of day within in a specified date/datetime. |
userdayofyear([date]) | userdayofyear(2/28/2006) | 58 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdaysinmonth() | Interprets the year/month specified in the user preferred calendar and returns the number of days in a that month. |
userdaysinmonth([month], [year]) | userdaysinmonth(04, 2006) | 30 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | useredate() | Returns the date that is the number of months before or after the given starting date in the user preferred calendar. |
useredate([start_date], [months]) | useredate(11/20/2006, -6) | 05/20/2006 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | usereomonth() | Returns the date for the last day of the month that is the number of months before or after the given starting date in the user preferred calendar. |
usereomonth([starting_date], [months]) | usereomonth(11/27/06, -6) | 5/31/06 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userisleapyear() | This functions lets you know if a given year is a leap year in the user preferred calendar. |
userisleapyear([year]) | userisleapyear(2021) | false |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userlocale() | Returns the preferred locale of the given user or the site primary locale if the user doesn't have a preference set. |
userlocale([user]) | userlocale("john.doe") | en_US |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | usermonth() | Returns the month from the specified date or datetime in the user preferred calendar. |
usermonth([date]) | usermonth(11/20/2006) | 11 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | usertimezone() | Returns the site primary timezone if the application is configured to override user preferences; otherwise it returns the preferred timezone of the given user or the site primary timezone if the user doesn't have a preference set. |
usertimezone([user]) | usertimezone(loggedinuser()) | GMT |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userweekday() | Returns the day of the week of the specified date or datetime in the user preferred calendar. |
userweekday([date], [return_type]) | userweekday(07/10/2006, 1) | 1 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userweeknum() | Returns the week number within the year for the given date or datetime in the user preferred calendar, using a given methodology. |
userweeknum([date], [methodology]) | userweeknum(02/06/2018, 1) | 6 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | useryear() | Returns the year from the date or datetime specified in the user preferred calendar. |
useryear([date]) | useryear(11/20/2018) | 2018 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | webservicequery() | Invokes a web service configured by a WsConfig object with the supplied input data. |
webservicequery([config], [data]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | webservicewrite() | Returns a Writer that can be used as the setter of a variable created using the bind() function. |
webservicewrite([config], [data]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | xpathdocument() | This function finds information in an XML document stored in Appian's document management system. |
xpathdocument([docId], [expression], [prefix]) | xpathdocument(cons!my_xml_document, "//temp/text()") & " degrees today" | Collab |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | xpathsnippet() | This function finds information in an XML document provided as Text. |
xpathsnippet([snippet], [expression], [prefix]) | xpathsnippet("<weather><temp>72.3</temp><sky>Cloudy</sky></weather>", "//temp/text()") & " degrees today" | 72.3 degrees today |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | contains() | Checks whether an array contains the value. |
contains([array], [value]) | contains({10, 20, 30}, 20) | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | difference() | Returns the values in array1 and not in array2. |
difference([array1], [array2]) | difference({10, 20, 30, 40}, {30, 40}) | {10, 20} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | intersection() | Returns only those elements that appear in all of the given arrays. |
intersection([array1], [array2]) | intersection({10, 20, 30}, {20, 30, 40}) | {20, 30} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | symmetricdifference() | Returns the values unique to two arrays but are not in the intersection of them. |
symmetricdifference([array1], [array2]) | symmetricdifference({10, 20, 30}, {20, 30, 40}) | {10, 40} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | union() | Returns all unique elements from the given arrays. |
union([array1], [array2]) | union({10, 20, 30}, {20, 30, 40}) | {10, 20, 30, 40} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
Statistical | StatisticalUsed within expressions to perform statistical operations. | avedev() | Returns the average deviation of the specified number(s). |
avedev([number]) | avedev(1, 2, 3, 4) | 1 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | average() | Returns the average of the specified number(s). |
average([number]) | average(1, 2, 3, 4) | 2.5 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | count() | Returns the number items in all arrays passed to the function. |
count([value]) | count({1, 2, 3, 4}) | 4 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | frequency() | Uses the bin array to create groups bounded by the elements of the array. |
frequency([data_array], [bins_array]) | frequency({64, 74, 75, 84, 85, 86, 95}, {70, 79, 89}) | {1, 2, 3, 1} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | gcd() | Returns the greatest common denominator of the specified non-negative number(s), which is the largest number that divides all the given numbers without a remainder. |
gcd([number]) | gcd(4, 12, 36) | 4 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | geomean() | Returns the geometric mean of the specified number(s). |
geomean([number]) | geomean(4, 9) | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | harmean() | Returns the harmonic mean of the specified number(s), which is the number of terms divided by the sum of the terms' reciprocals. |
harmean([number]) | harmean(1, 2, 3) | 1.636364 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | lcm() | Returns the least common multiple of the specified non-negative number(s), which is the smallest number that is a multiple of all the given numbers. |
lcm([number]) | lcm(5,10,15) | 30 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | lookup() | Returns location of data within multiple values, or valueIfNotPresent. |
lookup([multipleValues], [dataToLookup], [valueIfNotPresent]) | lookup({"a", "b", "c", "d"}, "c", -1) | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | max() | Returns the maximum of the specified number(s). |
max([number]) | max(1, 2, 3, 4) | 4 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | median() | Returns the median of the specified number(s). |
median([number]) | median(1, 2, 3, 4) | 2.5 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | min() | Returns the minimum of the specified number(s). |
min([number]) | min(1, 2, 3, 4) | 1 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | mode() | Returns the mode of the specified number(s), which is the most commonly repeated element. |
mode([number]) | mode(1, 2, 2, 3, 3, 3, 4) | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | rank() | Returns an integer representing the rank of the number in the specified array. |
rank([number], [array], [order]) | rank(2, {1, 2, 3, 4}, false) | 3 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | stdev() | Returns the standard deviation of the specified number(s). |
stdev([number]) | stdev(1, 2, 3, 4) | 1.290994 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | stdevp() | Returns the standard deviation of the specified number(s), assuming that the numbers form the entire data set and not just a sample. |
stdevp([number]) | stdevp(1, 2, 3, 4) | 1.118034 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | var() | Returns the variance of the specified number(s). |
var([number]) | var(1, 2, 3, 4) | 1.666667 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | varp() | Returns the variance of the specified number(s), assuming that the numbers form the entire data set and not just a sample. |
varp([number]) | varp(1, 2, 3, 4) | 1.25 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!applyComponents() | Calls a rule or function for each item in a list and supports the preservation of the local state on interfaces. |
a!applyComponents([function], [array], [arrayVariable]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!dataSubset() | Creates a value of type DataSubset for defining the source of expression-backed records and for use with |
a!dataSubset([startIndex], [batchSize], [sort], [totalCount], [data], [identifiers]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!deployment() | Returns a specific property of a direct deployment. |
a!deployment([deploymentUuid], [property]) | `deployment(101, "reviewedDate")` | `12/21/05 2:28 PM GMT` |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!entityData() | Creates an Entity Data for use with a!writeToMultipleDataStoreEntities() |
a!entityData([entity], [data]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!entityDataIdentifiers() | Creates an EntityDataIdentifiers configuration for use with a!deleteFromDataStoreEntities(). |
a!entityDataIdentifiers([entity], [identifiers]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!executeStoredProcedureForQuery() | Executes a stored procedure in a database. Since this function could run more than once, do not use it with stored procedures that modify data to avoid unintentional changes. |
a!executeStoredProcedureForQuery([dataSource], [procedureName], [inputs], [timeout]) | Click on the function name for examples. |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!facet() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!facetOption() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
System | SystemUsed within expressions to perform platform operations and data transformations | a!fromJson() | Converts a JSON string into an Appian value. |
a!fromJson([jsonText]) | a!fromJson("{""name"":""John Smith"", ""age"":49, ""likes"":[""green"",""dogs"",""long walks""]}") | [name:John Smith,age:49,likes:green; dogs; long walks] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!fromJson 19r2() | Converts a JSON string into an Appian value. |
a!fromJson_19r2([jsonText]) | a!fromJson("{""name"":""John Smith"", ""age"":49, ""likes"":[""green"",""dogs"",""long walks""]}") | [name:John Smith,age:49,likes:green; dogs; long walks] |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!httpResponse() | Returns an HTTP Response object for use in a Web API. |
a!httpResponse([statusCode], [headers], [body]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!httpResponse 17r4() | Returns an HTTP Response object for use in a Web API. |
a!httpResponse_17r4([statusCode], [headers], [body]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!iconIndicator() | Returns the specified image from a list of standard indicator icons. Indicator icons can be used on interface within a document image. |
a!iconIndicator([icon]) | Click on the function name for examples. |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!iconNewsEvent() | Returns the specified image from a list of standard news event icons in one of six colors: blue, green, gray, orange, purple, or red. |
a!iconNewsEvent([icon], [color]) | Click on the function name for examples. |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!integrationError() | Creates an integration error value. Use when configuring custom error handling for integration objects. |
a!integrationError([title], [message], [detail]) | Click on the function name for examples. |
|
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!jsonPath() | Finds information in a JSON string. JSONPath is used to navigate through elements and attributes in a JSON string. |
a!jsonPath([value], [expression]) | Click on the function name for examples. |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!latestHealthCheck() | Returns the start time, run status, zip file, and report for the latest Health Check run. |
a!latestHealthCheck([]) | a!latestHealthCheck() | [startDateTime=04/25/2020 16:18:38 GMT+00:00, runStatus=COMPLETED, zip=[Document:1408], report=[Document:1409]] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!listViewItem() | Creates a value of type ListViewItem for use with record type definitions. |
a!listViewItem([title], [details], [image], [timestamp]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!pagingInfo() | Creates a value of type PagingInfo for use with grids, queries, and |
a!pagingInfo([startIndex], [batchSize], [sort]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!query() | Creates a |
a!query([selection], [aggregation], [logicalExpression], [filter], [pagingInfo]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryAggregation() | Creates an |
a!queryAggregation([aggregationColumns]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryAggregationColumn() | Creates an |
a!queryAggregationColumn([field], [alias], [visible], [isGrouping], [aggregationFunction], [groupingFunction]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryColumn() | Creates a |
a!queryColumn([field], [alias], [visible]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryEntity() | Executes a query on a given data store entity and returns the result. |
a!queryEntity([entity], [query], [fetchTotalCount]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryEntity 18r3() | Executes a query on a given data store entity and returns the result. |
a!queryEntity_18r3([entity], [query]) | Click on the function name for examples. |
~portal+om-crf
Partially compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryFilter() | Creates a value of type |
a!queryFilter([field], [operator], [value], [applyWhen]) | a!queryFilter(field: "name", operator: "=", value: 1) | [field=name, operator==, valueExpression=, value=1] |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryLogicalExpression() | Creates a |
a!queryLogicalExpression([operator], [logicalExpressions], [filters], [ignoreFiltersWithEmptyValues]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryProcessAnalytics() | Executes process reports and returns the resulting data. |
a!queryProcessAnalytics([report], [query], [contextGroups], [contextProcessIds], [contextProcessModels], [contextUsers]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!querySelection() | Returns a |
a!querySelection([columns]) | a!querySelection(columns: a!queryColumn(field: "name")) | [columns=[field=name, alias=name, visible=true]] |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterChoices() | Creates choices of a user filter for an expression-backed record. |
a!recordFilterChoices([choiceLabels], [choiceValues]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterDateRange() | Creates a user filter for a record list. |
a!recordFilterDateRange([name], [field], [isVisible], [defaultFrom], [defaultTo]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterDateRange 20r2() | Creates a user filter for a record list. This is an older version of the |
a!recordFilterDateRange_20r2([name], [field], [defaultFrom], [defaultTo], [isVisible]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterList() | Creates a user filter category for the record list. |
a!recordFilterList([name], [options], [defaultOption], [isVisible], [allowMultipleSelections]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterListOption() | Creates a filter option for the |
a!recordFilterListOption([id], [name], [filter], [dataCount]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!sentimentScore() | Returns a list of scores representing the emotional or subjective sentiment expressed in each of the provided text values, ranging from 1.0 (positive) to -1.0 (negative). |
a!sentimentScore([text]) | a!sentimentScore({"Hi, I hope you're having a great day"}) | {0.79} |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!sortInfo() | Creates a value of type SortInfo for use with grids and record queries. |
a!sortInfo([field], [ascending]) | a!sortInfo(field: "a", ascending: true()) | [field=a, ascending=true] |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!storedProcedureInput() | Creates an input to be passed to the |
a!storedProcedureInput([name], [value]) | a!storedProcedureInput(name: "integer_input", value: 2) |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!submitUploadedFiles() | Submits all uploaded files in a!fileUploadField or a!signatureField components to their target folders. The function only executes inside a saveInto parameter. Only for use with Portals. |
a!submitUploadedFiles([onSuccess], [onError]) | Click on the function name for examples. |
+portal-om-crf
Compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!toJson() | Converts a value into a JSON string. |
a!toJson([value], [removeNullOrEmptyFields]) | a!toJson(a!pagingInfo(startIndex: 1, batchSize: 10)) | {"startIndex":1,"batchSize":10} |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!toJson 17r1() | Converts a value into a JSON string. |
a!toJson_17r1([value]) | a!toJson_17r1(a!pagingInfo(startIndex: 1, batchSize: 10)) | {"startIndex":1,"batchSize":10} |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!toRecordIdentifier() | Matches record IDs with their record type to return a value of type Record Identifier for each record ID passed to the function. |
a!toRecordIdentifier([recordType], [identifier]) | a!toRecordIdentifier(recordType!<Record Type Name>, 1) | 0 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!userRecordFacets() [Deprecated] |
a!userRecordFacets() |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|||||
System | SystemUsed within expressions to perform platform operations and data transformations | a!userRecordFilterList() | Returns the default user filters for the User record type. For use on the User record type only. |
a!userRecordFilterList([]) | 0 | 0 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!userRecordIdentifier() | Returns a value of type Record Identifier for each user passed to the function. |
a!userRecordIdentifier([users]) | a!userRecordIdentifier("john.smith") | 0 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!userRecordListViewItem() | Returns the default list view item for the User record type. For use on the User record type only. |
a!userRecordListViewItem([record]) | 0 | 0 |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!map() | Creates a map of values (Any Type) with each value stored at the corresponding string key. Values stored in maps are not wrapped in variants. |
a!map([key1], [keyN]) | a!map(id: 1, name: "Jane Doe") | a!map(id: 1, name: "Jane Doe") |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryRecordType() | Executes a query on a given record type and returns the result. |
a!queryRecordType([recordType], [fields], [filters], [pagingInfo], [fetchTotalCount], [relatedRecordData]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryRecordType 20r4() | Executes a query on a given record type and returns the result. This is an older version of the |
a!queryRecordType_20r4([recordType], [selection], [filters], [pagingInfo], [fetchTotalCount]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordData() | This function references a set of records from a record type and allows additional filtering in a read-only grid or chart that uses a record type as the source. When referencing one-to-many relationships in grid columns, you can filter, sort, and limit that related record set using the relatedRecordData parameter and the |
a!recordData([recordType], [filters], [relatedRecordData]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!relatedRecordData() | References a one-to-many relationship defined on a record type and allows for additional filtering, sorting, and limiting of the related record set. |
a!relatedRecordData([relationship], [limit], [sort], [filters]) | Click on the function name for examples. |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
|||
Smart Service | Testing | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Testing | a!testRunResultForId() | Provided a test-run ID, this function returns a TestRunResult data type containing the results of a rule test run. If the status of the test is IN PROGRESS, TestRunResult will contain only results for completed tests; if the status is COMPLETE, TestRunResult contains all test results. |
a!testRunResultForId([testRunId]) | Click on the function name for examples. |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Smart Service | Testing | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Testing | a!testRunStatusForId() | Provided a test-run ID, this function queries for the status of an expression rule test run. |
a!testRunStatusForId([testRunId]) | Click on the function name for examples. |
~portal~om-crf
Partially compatible
Portals
Partially compatible Offline Mobile Incompatible Custom Record Field Expressions |
|
Text | TextUsed within expressions for manipulating text strings of data. | cents() | Converts a number into its value in cents by effectively appending a cent sign to a fixed representation and one comma for every three digits preceding the decimal. |
cents([number], [decimals]) | cents( 123412 ) | 123,412.00¢ |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | char() | Converts a number into its Unicode character equivalent. |
char([number]) | char( 65 ) | A |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | charat() | Returns the character at given index within specified string. |
charat([text], [index]) | charat( "string", 2 ) | t |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | clean() | Returns the specified text, minus any characters not considered printable. Printable characters are the 95 printable ASCII characters plus three special characters: BACKSPACE (0x08), TAB (0x09), and NEWLINE (0x0a). |
clean([text]) | clean( "Please enter value in £" ) | Please enter value in |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | cleanwith() | Returns the specified text, minus any characters not in the list of valid characters. |
cleanwith([text], [with]) | cleanwith( "text string", "xte" ) | textt |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | code() | Converts the text into Unicode integers. |
code([text]) | code( "Convert to Unicode" ) | 67, 111, 110, 118, 101, 114, 116, 32, 116, 111, 32, 85, 110, 105, 99, 111, 100, 101 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | concat() | Concatenates the specified strings into one string, without a separator. |
concat([text]) | concat( {"a", "b", "c"}, {"d", "e", "f"} ) | abcdef |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | currency() | Converts a decimal number into a generic currency value by effectively adding a generic currency symbol (¤), a decimal point, and one comma for every three digits preceding the decimal. |
currency([number], [decimals]) | currency( 13213.43 ) | ¤13,213.43 |
~portal-om-crf
Partially compatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | dollar() | Converts a decimal number into a dollar value by effectively adding a dollar sign ($), a decimal point, and optional comma for every three digits preceding the decimal. |
dollar([number], [decimals], [no_commas]) | dollar( 13213.43 ) | $13,213.43 |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | euro() | Converts a decimal number into a euro value by effectively adding a euro symbol (€), a decimal point, and optional comma for every three digits preceding the decimal. |
euro([number], [decimals], [no_commas]) | euro( 13213.43 ) | €13,213.43 |
+portal+om-crf
Compatible
Portals
Compatible Offline Mobile Incompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | exact() | Compares two given text strings in a case-sensitive manner, returning true only if they are exactly the same. |
exact([text1], [text2]) | exact( "Copy of the other", "Copy of the other" ) | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | extract() | Returns the value (or values, if the text contains multiple delimited values) between the delimiters from the given text. |
extract([text], [startDelimiter], [endDelimiter]) | extract( "name: Bob, name: Karen, name: Sam", ":", "," ) | {"Bob", "Karen"} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | extractanswers() | Returns an array of strings that respond to the questions provided. |
extractanswers([questions], [text]) | extractanswers( {"What is your name?", "What is your age?"}, "1. What is your name? Ben 2. What is your age? 47 " ) | {"Ben", "47"} |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | find() | Returns index location of case-sensitive substring with given string. |
find([search_text], [within_text], [start_num]) | find( "to", "Boston", 1 ) | 4 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | fixed() | Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas. |
fixed([number], [decimals], [no_commas]) | fixed( 7.36819 ) | 7.37 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | fromHtml() [Deprecated] |
-portal-om-crf
Incompatible
Portals
Incompatible Offline Mobile Incompatible Custom Record Field Expressions |
||||||
Text | TextUsed within expressions for manipulating text strings of data. | initials() | Returns only the uppercase characters from within the given text. |
initials([text]) | initials( "John P. Smith" ) | JPS |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | insertkey() | Returns the provided text, wrapped with the specified delimiters. |
insertkey([key], [startDelimiter], [endDelimiter]) | insertKey( "hello", "[", "]" ) | [hello] |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | insertkeyval() | Returns the provided key-value pairs, wrapped with the specified delimiters. |
insertkeyval([key], [value], [startDelimiter], [endDelimiter]) | insertkeyval( {"hello", "goodbye"}, {"alpha", "beta"}, "[", "]") | [hello=alpha][goodbye=beta] |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | insertquestions() | Returns an array of questions with a ==EOQ== at the end, returning a single string that can be parsed with |
insertquestions([questions]) | insertquestions({"What is your name?", "What is your age?"}) | 1. What is your name? 2. What is your age? |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | keyval() | Returns the value(s) associated with the given key(s). |
keyval([text], [keys], [separators], [delimiters]) | keyval("[hello=alpha][goodbye=beta]", {"hello"}, "=", "]") | alpha |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | left() | Returns a specified number of characters from the text, starting from the first character. |
left([text], [num_chars]) | left("Boston",3) | Bos |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | leftb() | Returns a specified number of bytes from the text, starting from the first byte. |
leftb([text], [num_bytes]) | leftb("Boston",3) | Bos |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | len() | Returns the length in characters of the text. |
len([text]) | len("Boston") | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | lenb() | Returns the length in bytes of the text. |
lenb([text]) | lenb("Boston") | 6 |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | like() | Tests whether a string of text is like a given pattern. |
like([stringA], [stringB]) | like("brian","*ian") | true |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | lower() | Converts all characters in the text into lowercase (Unicode case folding). |
lower([text]) | lower("BOSTON") | boston |
+portal+om+crf
Compatible
Portals
Compatible Offline Mobile Compatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | mid() | Returns a substring from the middle of the specified text. |
mid([text], [start_num], [num_chars]) | mid("Boston", 4, 2) | to |
+portal+om+crf
|