Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Where are values for Flow Designer step instances stored?

Simeon1
Tera Expert
Hi there, I need some help working out where values for Flow Designer step instances are kept. When you use the REST step in an action, there is a 'Use MID' checkbox, but I can't find where that value is stored. This field relates to a data pill picker, and if you set something using the pill picker, then that value is stored in the 'sys_element_mapping' table. However, this table doesn't seem to capture a true/false value if you manually tick this checkbox. It doesn't look like the 'sys_variable_value' table is relevant for this data type either.
1 ACCEPTED SOLUTION

Simeon1
Tera Expert

I should have posted this earlier, but I worked out how to determine if the step is using a MID. It's captured in the sys_variable_value table via the following query:

var grVarValue1 = new GlideRecord('sys_variable_value');
grVarValue1.addQuery('document', 'sys_hub_step_instance');
grVarValue1.addQuery('document_key', [step instance sys_id]);
grVarValue1.addEncodedQuery('variable.element=use_mid');
grVarValue1.addQuery('value', '1');

View solution in original post

6 REPLIES 6

Thanks for the reply Cornelius. The info I was after is actually in a different table, as explained in my recent post below.

Simeon1
Tera Expert

I should have posted this earlier, but I worked out how to determine if the step is using a MID. It's captured in the sys_variable_value table via the following query:

var grVarValue1 = new GlideRecord('sys_variable_value');
grVarValue1.addQuery('document', 'sys_hub_step_instance');
grVarValue1.addQuery('document_key', [step instance sys_id]);
grVarValue1.addEncodedQuery('variable.element=use_mid');
grVarValue1.addQuery('value', '1');