gridTextColumn

You can use apply() to iterate each item in the list like apply(rule!converId,{111,222,333})

or

You can use new looping function a!forEach() which does everything apply() does with better null handling and it supports SAIL components.

a!forEach(
items: {111,222,333},
expression: rule!convertid(fv!item)
)

Thanks ammireddys,

I'm using V16.3 so can not use forEach function.

I updated my statement below, but I'm still getting evaluation error --> 

       a!gridTextColumn(

         label: "Approved By",

         field: "approvedString",

         data: apply(rule!AH_formatUserName, {local!datasubset.data, "approvedString"})

       )

Note:

The following text array is correctly returned by the below statement: {111,222,333}

       a!gridTextColumn(

         label: "Approved By",

         field: "approvedString",

         data: index(

           local!datasubset.data,

           "approvedString",

           null

         )

       )

 

Thank you.

Try this

a!gridTextColumn(
label: "Approved By",
field: "approvedString",
data: apply(
rule!AH_formatUserName,
index(
local!datasubset.data,
"approvedString",
null
)
)
)

if you are getting values beforehand, its good to parse the subset data before populating it in grid text column so that it would be easier for null handling.

Thank you, I'm getting evaluation error as follows: 

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'ah_formatusername' at function 'user' [line 3]: Error evaluating function 'user' : [InvalidUserException]

Note:

rule!AH_formatUserName contains the following expression to handle a single userName input:

=if(a!isNullOrEmpty(ri!username),

 tostring(null),

 user(ri!userName, "firstName") & " " & user(ri!userName, "lastName")

)

Any other suggestions will be much appreciated.

Thank you, I'm getting evaluation error as follows: 

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'ah_formatusername' at function 'user' [line 3]: Error evaluating function 'user' : [InvalidUserException]

Note:

rule!AH_formatUserName contains the following expression to handle a single userName input:

=if(a!isNullOrEmpty(ri!username),

 tostring(null),

 user(ri!userName, "firstName") & " " & user(ri!userName, "lastName")

)

Any other suggestions will be much appreciated.

Check what exactly "approvedString" holds, is it username array or full names?

Approved string holds a text array of userIDs. The user IDs are numeric (111111) and can convert to a full user name i.e. John Smith.

I copied this "approvedString" variable directly from one of the processes:

206504320, 206504472, 206504472, 206504472, 206504472, 206504472, 206504472, 206504472

Example:

rule!AH_formatUserName(206504472) RETURNS "John Smith"

Hi ammireddys,

"approvedString" holds a text array of numeric User IDs which are the usernames in Appian. 

From the username, the rule AH_formatUserName returns "Firstname Lastname"

I am trying to take the username, and return the "firstname lastname".

Example:

Username: 206504476

Firstname: John

Lastname: Doe

rule!formatUserName(206504476) RETURNS "John Doe" 

Note: 

the rule does not accept arrays, only single user names. 

Will your below code still work in this case?

a!gridTextColumn(
label: "Approved By",
field: "approvedString",
data: apply(
rule!AH_formatUserName,
index(
local!datasubset.data,
"approvedString",
null
)
)
)