How to Create a Reference Choice List Based on JSON Field Values (name-value pairs field type)?

Kevin Gomez1
Tera Contributor

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

0 REPLIES 0