21-Topaz I

Question

How to filter out a user from a report when the user is in a specific group

Forum|Forum|6 years ago
October 15, 2019
1 reply
2341 views

I created a report to find out when a user last logged in by using the "Audit Record" table. Now I want to filter out any user that is in a specific group. This group is called "Deactivated" and it would be the only group they are in if they are in fact deactivated. How can I create this filter in my report?

I tried putting a link the Audit Record table to the "User" table but it won't let me create one.

Reporting

21-Topaz I

Hi Steve,

I have a report that I use to count the number of monthly access of every user.

The report search on three tables: WTUser, AuditRecord and EventInfo.

There is no join between User and Audit tables and, despite this, it gives me exactly what I want.

If you want to filter disconnected user, I think you can simply use Disabled attribute on User table.

Marco

16-Pearl

Marco,

What are the defined criteria for your report? When there are no joins between the tables, the connections are defined thru the criteria.

Thanks,

Matt

21-Topaz I

Yes Matt, connection through criteria is a sophisticated way to bypass issue joining table. In my case these are the criteria

Marco