I want to see only one active user record option when generating reports

[Srinivasu2]

Hi Community,

I don't want to see two user records one is active user option, another one is inactive user option with similar name

I want to see only one active user record option when generating reports in order to avoid confusion for selection, please check the screenshot and advise?

Thanks,

Srinivasu

[Justin Hatfield]

You could create a before query business rule on the table to filter inactive users, but that would break reference to that user (same as deleting the user). I don't recommend that approach.

A better option may be to create a display calculated field on the user table and have it return current.name + '(' + (current.active) ? 'Active' : 'Inactive' + ')';

[Leonydaz]

Maybe you can try changing the filter to indicate that the field "Active" must be actually active, and then specify wich user you want to see, like in the image below.

Hope this helps you!