Search on sys_user is listing out all relevant records

[ArpitaVK]

1. I have a reference field on UI page review_request, referencing to the sys_user table. I have written a query to filter out the members which are active=true and has role ITIL. When searched by clicking on magnifying glass on that field, the window displays correct records. But when I type in the name, it displays all the relevant records; even those which does not satisfy above condition. Is this behavior OOB? If not, any solution for this?

2. The dictionary attributes have been applied to the same field to refer to the columns User ID, first name and last name which searching a particular record. User ID in our case is mix of alphabets and numbers. When I type in name, it filters out the records by Name contains......or Name starts with..... Is this OOB? and if searched with exact user ID, it has no records to display because it is searching on Name field only. Is there any solution?

Thanks in advance!

[Anurag Tripathi]

Hi,

No this is not expected, it should work the same way as it does on any form.

Can you show the ui page script where you have the reference field.

[ArpitaVK]

Hello, below is that reference field:

<g:ui_reference name="manager" completer="AJAXTableCompleter" query="QUERY:active=true^roles=ITIL" id="manager" table="sys_user" columns="user_name;first_name;last_name" />

[Anurag Tripathi · Accepted solution]

Use this, you will get correct results

<g:ui_reference name="manager" completer="AJAXTableCompleter" query="active=true^roles=ITIL" id="manager" table="sys_user" columns="user_name;first_name;last_name" />

Guess his answers your question

[ArpitaVK]

@Anurag Tripathi Thank you! This saved me!

and how about my 2nd question?