Converts an array that contains other arrays into an array of single items.

a!flatten([array])

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])

Appends a value or values to the given array, and returns the resulting array.

append([array], [value])

Returns the data[index] if it is valid or else returns the default value.

index([data], [index], [default])

Inserts a value into the given array and returns the resulting array.

insert([array], [value], [index])

Concatenates the elements of an array together into one string and inserts a string separator between each element.

joinarray([array], [separator])

Drops a given number of values from the left side of an array and returns the resulting array.

ldrop([array], [number])

This function returns the number of elements in an array.

length([array])

Drops a given number of values from the right side of an array, and returns the resulting array.

rdrop([array], [number])

Removes the value at a given index from an array, and returns the resulting array.

remove([array], [index])

Returns an array in reverse order.

reverse([array])

Inserts new values or modifies existing values at the specified index of a given array, and returns the resulting array.

updatearray([array], [index], [value])

Returns the indices where the values in the input array are true.

where([booleanArray], [default])

Receives one or more values and returns an array of indices that indicate the position of the values within the array.

wherecontains([values], [array])

Converts a Binary number as text to a Decimal number.

bin2dec([value])

Converts a Binary number as text to a Hex number as text.

bin2hex([value], [place])

Converts a Binary number as text to an Octal number as text.

bin2oct([value], [place])

Converts a Decimal number to a Binary number as text.

dec2bin([value], [place])

Converts a Decimal number to a Binary number as text.

dec2hex([value], [place])

Converts a Decimal number to an Octal number as text.

dec2oct([value], [place])

Converts a Hex number as text to a Binary number as text.

hex2bin([value], [place])

Converts a Hex number as text to a Decimal number.

hex2dec([value])

Converts a Hex number as text to an Octal number as text.

hex2oct([value], [place])

Converts an Octal number as text to a Binary number as text.

oct2bin([value], [place])

Converts an Octal number as text to a Decimal number.

oct2dec([value])

Converts an Octal number as text to a Hex number as text.

oct2hex([value], [place])

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])

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])

Copies a document from the CMIS target system to an Appian folder, creating a new document.

a!cmiCopyDocumentToAppianFolder([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [appianFolder])

Creates a folder in the CMIS target system.

a!cmiCreateFolder([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [parentId], [properties])

Deletes an object in the CMIS target system.

a!cmiDelete([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [allVersions])

Retrieves the children of the folder given as the folderId parameter, obeying the given pagingInfo.

a!cmiGetFolderChildren([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [folderId], [pagingInfo])

Retrieves the object id of a CMIS object based on the value given as the path parameter.

a!cmiGetObjectIdByPath([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [path])

Retrieves the properties of the CMIS object given as the objectId parameter.

a!cmiGetProperties([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId])

Retrieves information about the target CMIS target system repository.

a!cmiGetRepoInfo([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId])

Creates an object that contains the information required to perform HTTP Basic authentication.

a!httpAuthenticationBasic([username], [password], [preemptive])

Creates an HTTP form part which can be passed in an integration’s multipart request body.

a!httpFormPart([name], [contentType], [value])

Creates an HTTP header object which can be passed to an HTTP function.

a!httpHeader([name], [value])

Creates an HTTP query parameter object which can be passed to an HTTP function.

a!httpQueryParameter([name], [value])

Creates an object which contains the information required to access data in the Secure Credentials Store.

a!scsField([externalSystemKey], [fieldKey], [usePerUser])

Retrieves the list of parameters required to call the given SAP BAPI.

a!sapBapiParameters([scsExternalSystemKey], [usePerUserCredentials], [hostname], [clientNumber], [systemNumber], [connectionProperties], [bapi])

Invokes the given BAPI, returning the result.

a!sapInvoke([scsExternalSystemKey], [usePerUserCredentials], [hostname], [clientNumber], [systemNumber], [connectionProperties], [bapi], [importParameters], [tableParameters])

Creates a new record in Siebel.

a!sblCreate([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [parameters], [fieldValues])

Deletes a record from Siebel.

a!sblDelete([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [parameters])

Invokes the method in Siebel, returning the result.

a!sblInvoke([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [businessService], [method], [parameters])

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])

Retrieves records from Siebel.

a!sblQuery([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [sort], [parameters])

Updates the values of the given record in Siebel.

a!sblUpdateFieldValue([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [fieldValues], [parameters])

Constructs the config parameter to the webservicequery() and webservicewrite() functions.

a!wsConfig([wsdlUrl], [service], [port], [operation], [wsdlCredentials], [endpointcredentials], [extensions])

Constructs a WsHttpCredentials object for use with a!wsConfig.

a!wsHttpCredentials([username], [password], [domain])

Constructs a WsHttpHeaderField object for use with a!wsConfig.

a!wsHttpHeaderField([name], [name])

Constructs a WsUsernameToken object for use with a!wsConfig.

a!wsUsernameToken([username], [password])

Constructs a WsUsernameTokenScs object for use with a!wsConfig.

a!wsUsernameTokenScs([systemKey], [usePerUser])

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])

Converts the given value to a string representation so that it can be saved externally.

externalize([value])

Converts the given externalized string representation of a value to the original value.

internalize([externalizedText], [default])

Converts a value to Boolean.

toboolean([value])

Converts a value to Community.

tocommunity([value])

Converts a value to Date with Timezone.

todate([value])

Converts a value to Date and Time.

todatetime([value])

Converts a value to Decimal (double precision floating point).

todecimal([value])

Converts a value to Document.

todocument([value])

Converts a value to email address.

toemailaddress([value])

Converts a value to email recipient.

toemailrecipient([value])

Converts a value to Folder.

tofolder([value])

Converts a value to Integer.

tointeger([value])

Converts a value to Interval (Day to Second).

tointervalds([value])

Converts a value to Knowledge Center.

toknowledgecenter([value])

Converts a value to Text.

tostring([value])

Converts a value to Time.

totime([value])

Converts a value to Text, preserving the original scalar or array structure.

touniformstring([value])

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])

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])

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])

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])

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])

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])

Converts text into data accepted by the date data type and functions that require date parameters.

date([year], [month], [day])

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])

Converts a value to a date.

datevalue([value])

Returns the day of the month from the day specified.

day([date])

Returns the day number within the year.

dayofyear([date])

Returns the number of days between two dates, based on a 360-day calendar.

days360([start_date], [end_date], [method])

Returns the number of days in the given month in the given year.

daysinmonth([month], [year])

Returns the date that is the number of months before or after the given starting date.

edate([starting\_date], [months])

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])

Subtracts a time zone offset from a given Date and Time.

gmt([datetime], [timezone])

Returns the hour from the time specified.

hour([time])

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])

Returns a Boolean value for whether the given year is a leap year.

isleapyear([year])

Returns a Boolean value for whether the given date is within the last given number of days.

lastndays([date], [n])

This is a Date and Time addition function, adding time zone offset to given Date and Time.

local([datetime], [timezone])

This function returns the millisecond portion of a timestamp or the decimal number that represents 1 millisecond in days.

milli([time])

Returns the minute from the time specified.

minute([time], [minute])

Returns the month from the specified date.

month([date])

Returns the number of working days between two specified dates.

networkdays([starting\_date], [ending\_date], [holidays])

Returns the current Date and Time as a serial number.

now([])

Returns the seconds from the specified time.

second([time])

Converts the given time into an equivalent time value.

time([hour], [minute], [second], [millisecond])

Converts the given time into an equivalent interval.

timevalue([time\_text])

Returns the default offset in minutes from GMT, which is generally the process initiator's time zone.

timezone([])

Returns the time zone ID for the current context.

timezoneid([])

Returns the current day in GMT.

today([])

Returns the day of the week of the specified date.

weekday([date], [return\_type])

Returns the week number within the year for the given date using a given methodology.

weeknum([date], [methodology])

Returns the date the given number of workdays before or after the given date.

workday([starting\_date], [days], [holidays])

Returns the year for the date specified.

year([date])

Determine the fraction of the year.

yearfrac([start_date], [end_date], [method])

Retrieves results from a doc extraction run started by the Start Doc Extraction Smart Service.

a!docExtractionResult([docExtractionId], [typeNumber], [confidenceThreshold], [isStructuredDoc])

Retrieves the status of a doc extraction run started by the Start Doc Extraction Smart Service.

a!docExtractionStatus([docExtractionId])

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])

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])

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])

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])

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 saveInto parameter. This function has no effect when called outside of a component's saveInto parameter.

a!save([target], [value])

Lets you define local variables within a function and evaluate the expression with the new variables.

with([localVar1], [localVarN], [expression])

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. Null, "", and {} are all considered null or empty values.

a!defaultValue([value], [default])

Returns the list type number for a given type number.

a!listType([typeNumber])

Converts a value from its existing type to the specified type.

cast([typeNumber], [value])

Raises an error with the given message, used for invalidating execution.This function never returns a value.

error([message])

Represents a constant number that stands for positive infinity or a negative infinity if you negate the value.

infinity([])

Tests given numbers against positive and negative infinity, returning true if the number is infinite, false if the number is not infinite.

isinfinite([number])

Tests given numbers against negative infinity, returning true if number is negative infinity, false if number is not negative infinity.

isnegativeinfinity([number])

Returns true if value is null, false otherwise.

isnull([value])

Tests given numbers against positive infinity, returning true if the numbers are positive infinity, false if the numbers are not positive infinity.

ispositiveinfinity([number])

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([])

Returns a null value.

null⠀([value])

Returns the numerical representation of an Appian system data type when used during process execution.

runtimetypeof([value])

Returns the type name of a given type number.

typename([typeNumber])

Returns the type number of a given value.

typeof([value])

Returns true if all inputs are true; returns false if at least one input is false.

and([value])

Evaluates the choice argument at the given index and returns the result.

choose([key], [choice1], [choiceN])

Returns the Boolean value false.

false([returns])

Returns valueIfTrue if condition returns true; returns valueIfFalse otherwise.

if([condition], [valueIfTrue], [valueIfFalse])

Converts true into false, and false into true.

not([value])

Returns true if any inputs are true; returns false if all inputs are false.

or([value])

Returns the Boolean value true.

true([returns])

Evaluates an expression for each item in a list and returns a new array of the results.

a!forEach([items], [expression])

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])

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])

Calls a rule or function for each item in a list, and provides any contexts specified.

apply([function], [list], [context])

Calls a predicate for each item in a list and returns any items for which the returned value is true.

filter([predicate], [list], [context])

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])

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])

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])

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])

Returns the absolute value(s) of the specified number(s).

abs([number])

Rounds the number up to the nearest multiple of the specified significance.

ceiling([number], [significance])

Calculates the number of unique ways to choose m elements from a pool of n elements.

combin([n], [m])

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])

Returns the value of e.

e([])

Returns a list of integer numbers from 0 through n-1.

enumerate([n])

Rounds positive numbers up to nearest even integer and negative numbers down to the nearest even integer.

even([number])

Returns e raised to the specified power.

exp([power])

The factorial of specified number.

fact([number])

The double factorial of specified number (mathematically n!!).

factdouble([number])

Rounds the number down to the nearest multiple of the specified significance.

floor([number], [significance])

Rounds the specified number down to the nearest integer.

int([number])

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])

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])

Returns the remainder of dividend when divided by the divisor.

mod([dividend], [divisor])

Rounds the number to the specified multiple.

mround([number], [multiple])

Adds the specified integers and divides the factorial of the sum by the factorial of the individual numbers.

multinomial([integer])

Rounds positive numbers up to nearest odd integer and negative numbers down to the nearest odd integer.

odd([number])

Returns the value of pi.

pi([])

Returns the base number raised to the specified exponent.

power([base], [exponent])

Returns the product of the specified numbers.

product([factor])

Returns the quotient when numerator is divided by the denominator, and drops the remainder.

quotient([numerator], [denominator])

Returns a random number between 0 and 1 based on an even probability distribution, which is seeded by the transaction time.

rand([count])

Rounds off the number to the specified number of digits.

round([number], [num_digits])

Rounds the number down to the specified digit.

rounddown([number], [num_digits])

Rounds the number up to the specified digit.

roundup([number], [num_digits])

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])

Returns the square root(s) of the specified number(s).

sqrt([number])

Multiplies the number by pi, then returns the square root of the product.

sqrtpi([number])

Returns the sum of the specified numbers.

sum([addend])

Squares each number and then returns the sum of the squares.

sumsq([number])

Truncates a decimal number to the specified number of places after the decimal point.

trunc([value], [numberOfDecimals])

Returns a DataSubset of group members of a given group.

a!groupMembers([group], [direct], [memberType], [pagingInfo])

Returns an array of groups with the given name, or an empty array if no group exists.

a!groupsByName([groupName])

Returns a DataSubset of the groups of a given group type.

a!groupsByType([groupType], [pagingInfo])

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])

Retrieves users from a set of users and groups.

getdistinctusers([peopleArray])

Retrieves the value of the specified group attribute for the given group.

getgroupattribute([group], [attribute])

Returns information for group.

group([groupId], [property])

Identifies whether or not a user belongs to a group.

isusermemberofgroup_21r2([username], [groupId])

Verifies whether a user account with the specified username is already present.

isusernametaken([username])

Returns the current user logged in to the application.

loggedInUser([])

Returns the supervisor of the user if they have one.

supervisor([userinfo])

Converts a value to Group.

togroup([value])

Converts a value to People.

topeople([value])

Converts a value to User.

touser([value])

Returns selected properties from a user's profile and preferences.

user([username], [property])

Used to define a query against record data that performs an aggregation in a!queryRecordType(). Uses a!grouping() and a!measure() to define aggregate fields.

a!aggregationFields([groupings], [measures])

Returns true if the interface is being viewed within the Appian for Mobile application. Returns false otherwise.

a!isNativeMobile([])

a!isPageWidth([pageWidths])

This function returns the URL of a process task given the task ID.

a!urlForTask([taskIds], [returnTaskPathOnly])

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])

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])

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])

Returns the properties of a given community.

community([communityId], [property])

Interprets the date or datetime specified in the user's preferred calendar and returns its string representation using given format.

datetext([value], [format])

Returns property information for a document.

document([documentId], [property])

Returns a property of the requested folder.

folder([folderId], [property])

isNativePhone()

isNativeTablet()

Returns whether the given date and timezone are in daylight saving time.

isInDaylightSavingTime([date], [timezone])

Returns the properties of a knowledge center.

knowledgecenter([knowledgeCenterId], [property])

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])

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])

Returns the number of active and completed processes for the specified process model, which are past the deadline.

numoverdueprocessesforprocessmodel([processModelId], [includeSubProcessData])

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])

Counts and returns the number of process instances with the specified status for the process model.

numprocessesforprocessmodelforstatus([processModelId], [status], [includeSubProcessData])

Returns the number of tasks with the specified status in process instances of the process model.

numtasksforprocessmodelforstatus([processModelId], [status], [includeSubProcessData])

Returns the offset (in minutes) from GMT of the given date and timezone.

offsetFromGMT([date], [timezone])

This function extracts a bean's property under a given key name (the nameOfProperty parameter).

property([bean], [nameOfProperty], [valueIfMissing])

queryrecord( recordType, query )

This function takes an input of Any Type and returns a list with the input repeated a specified number of times.

repeat([times], [input])

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])

Returns a PagingInfo value for use with the todatasubset() function.

topaginginfo([startIndex], [batchSize])

Converts XML to a value of the given data type.

torecord([xml], [type])

Converts a value to its equivalent XML form.

toxml([value], [format], [name], [namespace])

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])

This function allows you to build a URL from an expression, using arrays of process and constant data.

urlwithparameters([parameterNames], [parameterValues])

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])

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])

Interprets the given date in the user preferred calendar and converts it into an equivalent serial number.

userdatevalue([date_text])

Returns the day of the month from the date or datetime specified in the user preferred calendar.

userday([date])

Returns the number of day within in a specified date/datetime.

userdayofyear([date])

Interprets the year/month specified in the user preferred calendar and returns the number of days in a that month.

userdaysinmonth([month], [year])

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])

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])

This functions lets you know if a given year is a leap year in the user preferred calendar.

userisleapyear([year])

Returns the preferred locale of the given user or the site primary locale if the user doesn't have a preference set.

userlocale([user])

Returns the month from the specified date or datetime in the user preferred calendar.

usermonth([date])

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])

Returns the day of the week of the specified date or datetime in the user preferred calendar.

userweekday([date], [return_type])

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])

Returns the year from the date or datetime specified in the user preferred calendar.

useryear([date])

Invokes a web service configured by a WsConfig object with the supplied input data.

webservicequery([config], [data])

Returns a Writer that can be used as the setter of a variable created using the bind() function.

webservicewrite([config], [data])

This function finds information in an XML document stored in Appian's document management system.

xpathdocument([docId], [expression], [prefix])

This function finds information in an XML document provided as Text.

xpathsnippet([snippet], [expression], [prefix])

Checks whether an array contains the value.

contains([array], [value])

Returns the values in array1 and not in array2.

difference([array1], [array2])

Returns only those elements that appear in all of the given arrays.

intersection([array1], [array2])

Returns the values unique to two arrays but are not in the intersection of them.

symmetricdifference([array1], [array2])

Returns all unique elements from the given arrays.

union([array1], [array2])

Returns the average deviation of the specified number(s).

avedev([number])

Returns the average of the specified number(s).

average([number])

Returns the number items in all arrays passed to the function.

count([value])

Uses the bin array to create groups bounded by the elements of the array.

frequency([data\_array], [bins\_array])

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])

Returns the geometric mean of the specified number(s).

geomean([number])

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])

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])

Returns location of data within multiple values, or valueIfNotPresent.

lookup([multipleValues], [dataToLookup], [valueIfNotPresent])

Returns the maximum of the specified number(s).

max([number])

Returns the median of the specified number(s).

median([number])

Returns the minimum of the specified number(s).

min([number])

Returns the mode of the specified number(s), which is the most commonly repeated element.

mode([number])

Returns an integer representing the rank of the number in the specified array.

rank([number], [array], [order])

Returns the standard deviation of the specified number(s).

stdev([number])

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])

Returns the variance of the specified number(s).

var([number])

Returns the variance of the specified number(s), assuming that the numbers form the entire data set and not just a sample.

varp([number])

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])

Creates a value of type DataSubset for defining the source of expression-backed records and for use with a!pickerFieldCustom, leaving the data as provided. To apply sorting and paging, use todatasubset().

a!dataSubset([startIndex], [batchSize], [sort], [totalCount], [data], [identifiers])

Returns a specific property of a direct deployment.

a!deployment([deploymentUuid], [property])

Creates an Entity Data for use with a!writeToMultipleDataStoreEntities()

a!entityData([entity], [data])

Creates an EntityDataIdentifiers configuration for use with a!deleteFromDataStoreEntities().

a!entityDataIdentifiers([entity], [identifiers])

Converts a JSON string into an Appian value.

a!fromJson([jsonText])

Converts a JSON string into an Appian value.

a!fromJson_19r2([jsonText])

Returns an HTTP Response object for use in a Web API.

a!httpResponse([statusCode], [headers], [body])

Returns an HTTP Response object for use in a Web API.

a!httpResponse_17r4([statusCode], [headers], [body])

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])

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])

Creates an integration error value. Use when configuring custom error handling for integration objects.

a!integrationError([title], [message], [detail])

Finds information in a JSON string. JSONPath is used to navigate through elements and attributes in a JSON string.

a!jsonPath([value], [expression])

Returns the start time, run status, zip file, and report for the latest Health Check run.

a!latestHealthCheck([])

Creates a value of type ListViewItem for use with record type definitions.

a!listViewItem([title], [details], [image], [timestamp])

Creates a value of type PagingInfo for use with grids, queries, and todatasubset().

a!pagingInfo([startIndex], [batchSize], [sort])

Creates a Query object for use in the a!queryEntity() function.

a!query([selection], [aggregation], [logicalExpression], [filter], [pagingInfo])

Creates an Aggregation object for use inside a Query object.

a!queryAggregation([aggregationColumns])

Creates an AggregationColumn object for use inside an Aggregation object.

a!queryAggregationColumn([field], [alias], [visible], [isGrouping], [aggregationFunction], [groupingFunction])

Creates a Column object for use inside a Selection object.

a!queryColumn([field], [alias], [visible])

Executes a query on a given data store entity and returns the result.

a!queryEntity([entity], [query], [fetchTotalCount])

Executes a query on a given data store entity and returns the result.

a!queryEntity_18r3([entity], [query])

Creates a value of type QueryFilter for use with a!pickerFieldRecords when defining filter options for expression-backed records, filtering a a!queryRecordType() or a!queryEntity() function call before any grouping or aggregation is computed, or using the a!recordData() function to define additional filters when referencing a set of records from a record type.

a!queryFilter([field], [operator], [value], [applyWhen])