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');