An Event Action querying CUSTOMER_ORDER_LINE returns no data and the event doesn't behave as expected, even though the identical logic works fine when run from a custom RMB menu action on the same screen, and the relevant technical accounts already have SELECT granted on the underlying table.

All FAQ questions / Security and access

Answer

Since the code appears to run without error (you can see other side effects like an email being generated), this points toward a context/scoping issue rather than a missing grant — specifically, worth checking whether it's a site-access issue. Try running the same query without its WHERE clause to see whether data comes back at all when querying the full view unfiltered; if it does, the WHERE clause (or some implicit site-scoping the view applies) is likely filtering out rows in the Event Action's execution context that wouldn't be filtered out when the same query runs interactively from a custom RMB under your own logged-in session and site access.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions