Search field on the UI page should be able to search on multiple fields

RiteshAlla · ‎11-23-2022

Hi Team,

Currently i have a search field on the UI page searching on sys_user table. This search filed currently only allows me to search by users name.

How do i make this field to be able to search by email, userid, company or any other fields on the user table?

Please help

Ps: Client script code as attached.

HTML Code:

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<html>
<body>
<h1> Select by a User or a Company </h1>
<table>
<th>Select a User:</th>
<th><g:ui_reference name="userRecords" id="userRecords" table="sys_user" completer="AJAXTableCompleter" onchange="generateTable()" /></th>
</table>
<br/>
<div id="dvTable2" style="overflow: hidden; height: 100%; width: 100%; position: absolute;" height="100%" width="100%">
</div>
<br/>
</body>
</html>
</j:jelly>

Kalyani Jangam1 · ‎11-23-2022

<th><g:ui_reference name="userRecords" id="userRecords" table="sys_user" completer="AJAXTableCompleter" columns="user_name;email;department" onchange="generateTable()" /></th>//here it will show user_name, email,department values, you can add multiple column like that.

Please mark helpful and correct if it will help you.

RiteshAlla · ‎11-23-2022

Sorry that did not work.

Kalyani Jangam1 · ‎11-23-2022

Hi @RiteshAlla ,

I also tried on my end and for me it worked. Can you please confirm your field name once?

Kalyani Jangam1 · ‎11-23-2022

Refer below docs also for more information

https://www.oreilly.com/library/view/servicenow-application-development/9781787128712/9911cb81-b904-...