Consult query in campaign

[NID27]

Hello,

I want the consult option should display just one particular person irrespective of who logged in.

For eg: If anyone selects a consult option it should option it should always display my name "nsharma".

Please help me with the query.

[rushikeshvartak · Accepted solution]

Select u from Users u where 1=1 and u.id in (select distinct id from Users where username='nsharma')

[Raghu]

@NID27  try below

select u from Users u where 1=1 and u.id =:loggedInUser

[NID27]

Thaks Rushi and Raghu for the replies. The query provided by Rushi Worked.