- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 06:22 AM - edited 07-03-2024 06:26 AM
Hi Eeveryone, I'm creating a catalog Item but I have a variable of type 'Reference' which table referenced does not have a display value, all the columns are set as 'false' on the display field, So when I make the reference in a variable of a catalog item it is being shown like this:
it shows just the 'created date/time' field. I can't configure the table in oder to display a value for obvious reasons, so I wanted to know if there is a way of showing just the parents of the table with some script include or other option without having to change the displays values of the table. Thank you in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 06:26 AM
Well the most obvious solution here is to add a display value to the table. That is what you should look to do.
Alternatively you can use ref_ac_columns to show meaningful colums to search and select records, please see the link below
Auto-complete for reference fields (servicenow.com)
It should be something like
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department,ref_ac_order_by=department
This will still not solve the issue when you select a record, what do you see on the field,. you still will see the created date. Maybe add a Text field (read only) that you populate when a record is selected on this table and populate it with the meaning ful value of the record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 06:31 AM
Hello @mariavic1998 ,
Please refer the below article and make changes as per your req:
https://www.servicenow.com/community/developer-articles/display-multiple-column-values-in-reference-...
Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!
Thank you!!
Dnyaneshwaree Satpute
Tera Guru
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 06:26 AM
Well the most obvious solution here is to add a display value to the table. That is what you should look to do.
Alternatively you can use ref_ac_columns to show meaningful colums to search and select records, please see the link below
Auto-complete for reference fields (servicenow.com)
It should be something like
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department,ref_ac_order_by=department
This will still not solve the issue when you select a record, what do you see on the field,. you still will see the created date. Maybe add a Text field (read only) that you populate when a record is selected on this table and populate it with the meaning ful value of the record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 06:31 AM
Hello @mariavic1998 ,
Please refer the below article and make changes as per your req:
https://www.servicenow.com/community/developer-articles/display-multiple-column-values-in-reference-...
Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!
Thank you!!
Dnyaneshwaree Satpute
Tera Guru