Get Started with Redwood for Oracle Cloud HCM Begin Now
Too much SQL!
Summary
Prompt not limiting by another field - Support have advised too much SQLContent
Hi
I'm getting an "unexpected token" error message when trying to limit one field in a dashboard prompt based on results from another (within the hierarchy)
Support have advised its because in admin we have lots of security roles and this is generating too much SQL causing the prompt to error. The exact message is:
When a user has a lot of roles it will generate a lot of SQL Where clauses in the back-end and then the values returned to the prompt will fail.
Tagged:
0