Pull only matching record from the reference field

[Vinay26]

Hi, 

I'm trying to find a solution  to below scenario:

I'm using incident table with the custom reference field. Reference field table is having 1000 records and when i tried to pass the 500 number on the incident from and click on the search for record (magnifying glass), it displays all the 1000 records list in the dialog box. But my use case is  to show only 500 record number (One record) from the entire list. Please provide the solution.

[palanikumar]

Pass *500 and check whether it is working fine. If you pass just 500, system will check for all records greater than 500

[Vinay26]

Hi Kumar,

It's just a record number id (from 1 to 1000 records). When we click on the reference field search icon, a dialog box opens and display the entire list of records from the table. I'm trying to achieve a setup where, when I enter a record number in the reference field, it  checks the reference table data. if a match is found (eg: record number 20), only that one record should display. If there is no match (eg: record number 1001) the list should display as empty.

[Runjay Patel]

Hi @Vinay26 ,

Reference field does not work the way you are expecting. If you putting 500 in reference field then it will check name start with 500 and based on that it will give you result.

Like i am on incident table and passing 500 and see the result.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Vinay26]

Hi Runjay,

When i tried the same it doesn't even searching the number contains. The search criteria gives me a blank and ends up displaying all records. Do i need to any condition to perform the search contains with?

Thanks,