Querying the data of one flow from another flow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-16-2023 02:30 AM
I want to query the data of one flow from another flow. Say I have flow "flow#1" and there is a context record for the same with SysId X. I have another flow "flow#2" and from this flow I want to query the execution details of context record corresponding to "flow#1" with SysId X. The intent of querying is to get the list of already completed steps and the flow data/variables values for the context record with SysId X. How can this be achieved?
- Labels:
-
flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-16-2023 02:40 AM
you can query this table sys_flow_context with correct sysId and determine the details
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-16-2023 04:23 AM
Thanks @Ankur Bawiskar . The sys_flow_context has lot of columns and other table references. I tried to use a "log" action to view the output of one record but it is showing me the link to the context record wherein it has got the links to see it in operations view. I wanted to see the output of one record to get an understanding of columns by seeing it values so that I can select the columns of my interest. Could you please help me with the column names which will help me to get the list of all the steps(including subflows) with its state and the flow data/variables.
Thanks
Sneha