User Reference qualifier for Condition Builder

[-Mark-]

We have a number of employees in the user table with the same name and it makes it difficult to search for tasks when the condition builder just lists their name.  Is it possible to add a reference qualifier to the condition builder so that the names returned are only those that match the qualifying criteria.  Let me give an example...

We have 3 users called Joe Employee, 2 happen to have left the organisation and are Active=False; the other is Active=True.

I wish to search for all open RITMs where Opened By = Joe Employee.  The condition builder shows me all 3 Joe Employees, and obviously you don't get records returned if you pick the wrong one.  But how to tell which is the correct one?

What i'd like to do is add a qualifier so the condition builder only displays the active users, and/or displays the users email address alongside the name so it is clear who is who.

Is this possible?

[Raj_Esh]

Hi Mark,

Have you used the following conditional builder?

Hope it helps.

Thanks,

Raj

[-Mark-]

Hi Raj,

Thanks for your reply.  Yes, my workaround is to use Opened By.Active=True AND Opened By 'starts with' Joe Employee.  This works.

Using Opened By 'is' is the issue.  I'm just conscious that in the background the database is doing a less efficient LIKE query rather than an = query.  I just wondered if it was possible to put a qualifier on the condition builder and then do a 'is' query rather than dot walking to the user's Active property.

Regards,

Mark

[Raj_Esh]

Hi Mark,

I got your point. Not sure if that is available OOT, lets's see if anyone has some approach for your query. 

Thanks,

Raj

[MichaelZischeck]

actually in Condition Builder V1 you can use filters to filter down... 

In Condition Builder V2 (same as condition builder on workspace) I have no idea