Which table is Flow Executions stored in?

[Cory B]

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]

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]

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

[Mark Roethof]

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

[Mwatkins]

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