Does anyone know where data pills are stored?

[peter_cawdron_p]

This is really obscure but... does anyone know where input (glide var) stores data pills?

In working with the Automated Test Framework, if I add a test step to set values using a data pill, it's stored in the inputs.field_values (no problem). As an example, the data pill appears in the record as...

While if I examine the gliderecord looking at the inputs.field_values in a background script, I see this as.. 

caller_id={{step['84d4d851db2d6700407f78eebf9619e6'].user}}^subcategory=antivirus^EQ

In other words, what's visible in the GUI is reflected in the record (which is all good)...

But add a data pill to Open an Existing Record and look at inputs.record_id and it's blank, even though it appears in the GUI.

 

Run the same script but looking at inputs.record_id and it comes back blank with no value.

If I look in the sys_variable_value table, I can see the value for the inputs.field_values but inputs.record_id is blank (not showing it's data pill setting, so somehow ServiceNow is storing this somewhere else.

Does anyone have any idea where ServiceNow is storing/managing this?

Cheers,

[Mark Stanger]

These are stored in dynamic 'variable' extension fields in the database because they are related to variables for a particular flow.  I don't think you can access these values via script.  Regular graphical workflow handles variables the same way.  You can actually see these 'fields' in the dictionary by their variable field names (which you can access by right-clicking the 'Record' field label and selecting the 'Show - 'record_id'' option.

[peter_cawdron_p · Accepted solution]

Thanks for the tip, Mark. It set me on the right path to figuring this out. 

It turns out this information is stored in sys_element_mapping table.

[The SN Nerd]

Have you worked out the API behind using these fields?

I've been having some difficulties, and finding some strange behaviour.