Where are values for Flow Designer step instances stored?

Simeon1 · ‎08-22-2019

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.

Simeon1 · ‎12-09-2020

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

DirkRedeker · ‎08-23-2019

Hi

As the picture shows the connection details, I gues you are meaning the field on the table [sys_connection] whis NO specific FLOW DESIGNNE Table. You just USE an existing Connection Record.

So, for your case, can you have a look a that table, and let me know.

If that answers your question, please mark my answer as correct and helpful.

BR

Dirk

DirkRedeker · ‎08-23-2019

Hi

I just cross checked with the Dictionary (see screenshot below).

There are just a few entries of type "True/False", which relates to "*MID".

Maybe that value is stored in one of the variable entries (see screenshot):

Let me know, if that answers your question and mark my answer as correct and helpful, please.

BR

Dirk

Simeon1 · ‎08-25-2019

Thanks for the reply Dirk! I checked the sys_connection table but unfortunately it is completely empty...

Cornelius Back · ‎12-09-2020

Hi Simeon,

I know it is a bit late for the answer but I will write it anyway for future searches:

The information you are looking for is stored in the table: sys_hub_step_instance.

In order to find the right step, you have to sort it by creation date, because all different versions are stored in that table without version info. And also filter for step_type=REST.

And then don't click on the first column to open the action, but instead click on the little icon to preview the record. This will let you open the action step instead of the action.

BR

Cornelius