Hello Folks,,.. Can somebody let me know how can i fetch the list of active and inactive users of appian in expression rule ?

hi Klaus34  Each Appian environment has a directory of users available as a record type. Each user in Appian has a User record, which by default includes a Summary, News, and Related Actions view. you can go through this link for more info https://docs.appian.com/suite/help/24.4/Configure_Tempo_Users.html

You can write query to User record type to get list of users in environment but i don't think it holds time of deactivation. If you really want it you need create your own logic for that,

1. You need to stop using Appian provided Deactivate user action
2. You need to build your own record action by using (Deactivate user Smart service) and you need to Save time of Deactivation somewhere

YOu can get that information  with a query to user record

1
2
3
4
5
6
7
8
9
10
11
12
13

a!queryRecordType(
  recordType: recordType!User,
  fields: {
    recordType!User.fields.firstAndLastName,
    recordType!User.fields.title
  },
  filters: a!queryFilter(
    field: recordType!User.fields.username,
    operator: "=",
    value: ri!username
  ),
  pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100)
).data

Fields:

You cannot edit or remove any Appian-configured record fields, but you can edit the firstAndLastName custom record field and create new custom record fields.

Edit existing custom record fields

docs.appian.com/.../Configure_Tempo_Users.html