Interactive Filter where users are no longer active

[Roshni1]

I have a dashboard that are using interactive filters for the Assignment Group but some members in the groups are no longer with the company.  How to I remove them from the dropdown list.

I have updated the user record to remove them from the assignment groups but they are still showing up on the see image below

[Community Alums]

Hi @Roshni1 ,

To remove users who are no longer with the company from the interactive filter dropdown in your dashboard, you need to ensure the filters are properly updated to exclude these users. Here's how you can do it:

• Update User Records:

  • Confirm that the users are removed from the assignment groups in the sys_user_grmember table.
  • Ensure their Active field is set to false on the user record (sys_user table).

• Update Interactive Filter Data Source:

  • Go to the interactive filter's data source (likely linked to the sys_user_grmember or sys_user table).
  • Add a condition to exclude inactive users:
    csharp

    Copy code

    Active is true
  • Save the filter.

[Roshni1]

Thanks for the tips I have tried doing what you suggested but the users are still showing in the dropdown list. Did I need to refresh the list? 

I logged out and logged in again and still the same

[Anand Kumar P]

Hi @Roshni1 ,

Check inactive users have been completely removed from their respective assignment groups. Simply deactivating a user may not automatically remove them from groups. Remove user from group go to sys_user_grmember.LIST check user record exists delete it. Logout and login again see the users still available .

you can create business rule or flow to delete inactive members in group member table.

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand