How to Create a Reference Choice List Based on JSON Field Values (name-value pairs field type)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2023 02:15 PM
Hello,
I'm working with a catalog item that has a field targeting the u_test_table. Within this table, there's a column named u_json_items of the type "name-value pairs". The values in this column are stored in a JSON-like format, e.g., {category: 'alpha' , department: 'beta', code:'XYZ123'}.
For my catalog item, I'd like to create a reference field, that shows up AS a choice (https://docs.servicenow.com/en-US/bundle/vancouver-platform-administration/page/administer/field-adm...) list.
I would like this reference/choice list to return all the 'categories' values within the name-value pair field and only the values
I am not sure if this is possible, I'm currently not seeing a way to implement this.