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

RiteshAlla
Mega Sage

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>

10 REPLIES 10

Kalyani Jangam1
Mega Sage
Mega Sage

<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.

Sorry that did not work.

Kalyani Jangam1
Mega Sage
Mega Sage

Hi @RiteshAlla ,

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

Kalyani Jangam1
Mega Sage
Mega Sage