gridTextColumn

I think the user is not valid, can you check if the user is valid or not ,using the function "isusernametaken"

eg.

=with(
if(

not(isusernametaken(ri!userName)),

"User Not Available",
user(ri!userName, "firstName") & " " & user(ri!userName, "lastName")
)
)

Hi Vinay, thank you for the suggestion.

I created a rule with the example code you provided, and now get the below error. I think there's some issue with using apply() in this scenario -any recommendations for a workaround will be appreciated:

RULE: TVP_getNamefromUsername

=with(

if(

not(isusernametaken(ri!userName)),

"User Not Available",

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

)

)

 

SAIL COMPONENT:

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

 

ERROR:

Interface Definition: Expression evaluation error in rule 'tvp_getnamefromusername' at function 'user' [line 7]: Error evaluating function 'user' : Null argument not allowed

Ok, The null check is missing, just check for null, it will work fine


=with(
if(
a!isNullOrEmpty(ri!username),
"",
if(
not(isusernametaken(ri!userName)),

"User Not Available",
if(
isuseractive(ri!Username),
user(ri!userName, "firstName") & " " & user(ri!userName, "lastName"),
"Invalid User"
)

)
)

)

Also I check for the Deactivated User, can you please let me know the UserName datatype,

Thank you Vinay,

It is now handling NULL correctly. But still not evaluating valid usernames correctly.

Here is SAIL Component Code:

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

Here is a sample of what is returned:

 

This is what the username 206504472 returns in the rule:

 

Can you suggest why valid username array is returning "User Not Available"?

Thank you

Oh, the ApprovalString is Invalid: that is why you get the Incorrect user :

there are multiple UserName in single datasubset as shown on your image,

you need to split the UserName and use the username

=with(
local!UserName : index(split(ri!UserName,","),1,ri!UserName),

if(
a!isNullOrEmpty( local!UserName),
"",
if(
not(isusernametaken( local!UserName)),

"User Not Available",
if(
isuseractive( local!UserName),
user( local!UserName, "firstName") & " " & user( local!UserName, "lastName"),
"Invalid User"
)

)
)

)

hope this work

Thank you Vinay, yes this is returning the correct user BUT only the FIRST user in the array. The apply() is not working. Can you suggest a way to return an array with all users?

Here is the result:

Here is the component: 

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

 

Many thanks for all your help.

Thank you Vinay, yes this is returning the correct user BUT only the FIRST user in the array. The apply() is not working. Can you suggest a way to return an array with all users?

Here is the result:

Here is the component: 

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

 

Many thanks for all your help.

Ok the apply is correct, but you need to call apply two time,

1) Expression:
GetUserNames
Input : UserName Text
Definition:
=with(

local!UserNameArray:
apply(
rule!TVP_getusersname(
UserName:_
),
{index(split(ri!UserName,","),1,ri!UserName)}
),

 if(

    a!isNullOrEmpty(local!UserNameArray),"",

     joinarray(

         local!UserNameArray,","

     )

)

)

2) Expression:
TVP_getusersname
Input : UserName Text
Definition:
=with(
if(
a!isNullOrEmpty(ri!UserName),
"",
if(
not(isusernametaken( ri!UserName)),

"User Not Available",
if(
isuseractive( ri!UserName),
user( ri!UserName, "firstName") & " " & user( ri!UserName, "lastName"),
"Invalid User"
)

)
)

)


3) On SAIL

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