General functions in ÃÛ¶¹ÊÓƵ Workfront Fusion
Access requirements
You must have the following access to use the functionality in this article:
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.
get (object or array; path)
Returns the value path of an object or array. To access nested objects, use dot notation. The first item in an array is index 1.
get( array ; 1 + 1 )
get( array ; 5.raw_name )
get( object ; raw_name )
get( object ; raw_name.sub_raw_name )
if (expression; value1; value2)
Returns the value1
if the expression is evaluated to true; otherwise it returns the value2
.
To create an if statement that returns a value only if two or more expressions are evaluated to true, use the and
keyword.
To combine if
statements, use the and
and or
operators.
-
if( 1 = 1 ; A ; B )
Returns A
-
if( 1 = 2 ; A ; B )
Returns B
-
if( 1 = 2 and 1 = 2 ; A ; B )
Returns B
ifempty (value1; value2)
Returns the value1
if this value is not empty; otherwise it returns the value2
.
-
ifempty(
A
;
B
)Returns A
-
ifempty(
unknown
;
B
)Returns B
-
ifempty(
""
;
B
)Returns B
switch (expression; value1; result1; [value2; result2; …]; [else])
Evaluates one value (called the expression) against a list of values; returns the result corresponding to the first matching value. To include an else
value, add it after the final expression or value.
-
switch( B ; A ; 1 ; B ; 2 ; C ; 3 )
Returns 2
-
switch( C ; A ; 1 ; B ; 2 ; C ; 3 )
Returns 3
-
switch( X ; A ; 1 ; B ; 2 ; C ; 3 ; 4 )
Returns 4
In this function, 4 is the value to be returned if no expressions apply (the
else
value).
omit(object; key1; [key2; …])
Omits the given keys of the object and returns the rest.
omit(
User ;
password )
pick(object; key1; [key2; …])
Picks only the given keys from the object.
pick(
User ;
password ;
email )
mergeCollections(collection1 ; collection2)
Merges two collections by combining their key-value pairs. If both collections contain the same key, the value from the second collection overwrites that value from the first collection.