Which table is Flow Executions stored in?

Cory B · ‎08-24-2021

I want to build a UI page that has a list of the flow executions in it but I can not find which table the executions is stored in. I want to have something similar to Flow Designer Executions tab on my UI page. See screen shot

Mwatkins · ‎08-25-2021

System tables are hidden from being selected in Table Choice List field types. You also won't find tables like sys_audit or sys_dictionary in those lists. This is done for performance reasons.

View solution in original post

Mwatkins · ‎08-24-2021

sys_flow_context has information about flows that are currently executing.

Please ✅ Correct if this solves your issue and/or 👍 if Helpful

"Simplicity does not precede complexity, but follows it"

Cory B · ‎08-25-2021

I thought thats what it was called but whenever I try to reference that table, its like it doesnt exist. See picture

Mark Roethof · ‎08-25-2021

Hi there,

(untested) Have you added that table to the "glide.ui.permitted_tables" system property?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

Kind regards,

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

Mwatkins · ‎08-25-2021

Yeah, Mark is probably, right. If so, you could override the blacklist on sys* tables by adding it to the "glide.ui.permitted_tables" property. But be warned, the sys_flow_context table is very large and potentially unwieldy. Make sure you have a good access strategy that will always leverage effective indexes and only show as much data as needed.

Performance Best Practice for Efficient Queries - Top 10 Practices