I am searching users based on username or email-id in List collector.

[Taaha M]

I have a List Collector field referring to sys_user table, in this field I am trying to search a record either by it's username or by it's mail id.

How can I do this ?

[Shruti D]

Hello @Taaha M,

To enable searching by either username or email, you can set a dynamic reference qualifier or use a scripted reference qualifier. 

Using a Dynamic Reference Qualifier

• Navigate to the field's Dictionary record.

• Scroll down to the Reference Qualifier field.

• Set it to Dynamic.

• Use a condition or filter that includes both the username and email.
  active=true^OR(usernameLIKE%search_username^emailLIKE%search_emailID)
  
  

Please Mark Correct  ✔️ if this solves your query and also mark Helpful 👍 if you find my response worthy based on the impact.

Regards,
Shruti

[Dr Atul G- LNG]

Hi @Taaha M 

You need to add additional attribute in attribute like this: