- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 01:57 AM
How to enhance the search so that if a last name is entered, the user name will come up.
Currently it' is working with first name.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 02:47 AM
Hio @VanishreeG
You can add an attribute in the variable definition to search by the last name as well. Give last_name as the value for the attribute ref_ac_columns. [Change the fields after ref_ac_columns to whatever fields you want on the User table.]
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 03:03 AM
Hi @VanishreeG,
as per your screenshot to @Dr Atul G- LNG. You are referring to a “catalog item”
please go to your catalog item, open the variable where you want to add more fields to the search.
adjust the attributes as follow for your variable:
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=first_name;last_name,ref_ac_columns_search=true
this is where the “variable attributes” is located:
If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 02:41 AM
For the particular field we need to enhance the search so that if a last name is entered, the user will come up in service portal
Please refer below screenshot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 02:47 AM
Hio @VanishreeG
You can add an attribute in the variable definition to search by the last name as well. Give last_name as the value for the attribute ref_ac_columns. [Change the fields after ref_ac_columns to whatever fields you want on the User table.]
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 03:03 AM
Hi @VanishreeG,
as per your screenshot to @Dr Atul G- LNG. You are referring to a “catalog item”
please go to your catalog item, open the variable where you want to add more fields to the search.
adjust the attributes as follow for your variable:
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=first_name;last_name,ref_ac_columns_search=true
this is where the “variable attributes” is located:
If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.