Hello, 1. I created a constant of type Group that has the value of al

Use the user() function to get properties of a user including first Name and lastName

Hi, PFA sample code. Hope it helps!!

sampleCode.txt

Thanks, does that code work in a rule?

Yes, it will definitely work. Give it a try!!
The sample code that I've attached above helps you in finding out the first & last names of the deactivated users and you have to replace the function getdeactivatedusersby() with getdistinctusers() in order to get all the active users in your environment.

Thanks.. :)

That got it working. I had to tweak your code to add the username, add comas. And then package it in a join array to save it in a variable to then have it displayed in Excel. ;) Now I have to tackle the French accents in Excel.. lol

@mjmallet Just in case, added to the above, if you are going to use the same code snippet or with slight modifications, as per my knowledge I would like to suggest to add the context local! because adding the rule inputs with the same name as local variables will cause readability issues (as there isn't a differentiation such as local! and ri!) and also the code behaves in a different manner if there isn't a context in case of same names being used for local variables and rule inputs.

Thanks for the input.. where would you put the local! in the example provided above?

@mjmallet We need to put in the load(). Here goes your snippet after applying the context:
load(
local!users: getdeactivatedusersby(
"username",
"",
2
),
local!usersWithNames: apply(
rule!fetchUsersWithFirstAndLastName(_),
local!users
),
local!usersWithNames
)

If you are new to using load() or with(), I would like to suggest going through https://forum.appian.com/suite/help/7.9/Evaluation_Functions.html.

Confirming the above, documentation conveys the same - 'When you don't specify the local! domain, the system first matches your variables with rules or constants with the same name, then looks for local variables with the name. Appian recommends that you always use the local! domain when referring to local variables.'

ahhh that's nice to know. We're slowly migrating to Tempo. So this is all new. Thanks! :)

Great!! No problem :-)