How to filter out disabled users via designer

Hi, 

Currently line managers are able to see their direct reports on the home screen of identity manager, however this also shows staff who have now left the business. Is there a way to create a filter to exclude employees on the web portal that have left or their exit date is before the current date? 

Parents Reply
  • Hi Markus,

    I have tried to change the where clause by adding a new property but still it shows me all the users (active and inactive) on the direct reports tile on the dashboard.

    below is the condition I have used:

    format("uid_person in (select uid_person from QER_VEditEmployee where uid_personhead = '{0}' and UID_OrgRoot = 'Person' and IsInActive = 0)",GetUser())

Children