How to search response_body of Subflow execution

[mballinger]

Hello,

We have a subflow setup that gets called from a script. I need to search for a specific transaction based on the response_body. There are over 1000 records and it is making this task very difficult because I have to click through every execution. Is there a way that I can search based off the response_body?

Thanks!

[Aravind2799]

Having full admin/security admin access should allow you to see the sys_flow_execution table. Here are a couple of possibilities to consider:

1. UI Filtering Issue: There might be a temporary issue with the UI filtering mechanism.

Here are some things to try:

• Refresh the page: Sometimes a simple refresh can clear up display issues.
• Clear your browser cache: Cached data might be causing problems. Try clearing your browser cache and reloading the page.
• Try a different browser: If the issue persists in your current browser, try accessing ServiceNow from a different browser to see if it displays the table correctly.

1. Table Security Misconfiguration (Less Likely): While less likely with full admin access, there's a slight chance the sys_flow_execution table itself might have some security settings unintentionally restricting your view.

Here's what you can do (use these steps with caution):

• Navigate to the "Security Definitions" section. This might be located under "System Definition" or a similar menu depending on your ServiceNow version.
• Search for the "sys_flow_execution" table.
• Review the ACLs (Access Control Lists) associated with the table. Ensure your user role has at least "read" access for all fields. If there are any restrictions, consider modifying them (only if you completely understand the security implications).