What's new in Customer Journeys?

Connect and learn more! ×
Service Request Header SQL Predicate — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Service Request Header SQL Predicate

Received Response
52
Views
4
Comments
edited May 12, 2023 12:07PM in Help Desk 4 comments

Hi all, I have been trying to set up a custom condition for the 'Service Request Header' object, but it isn't working for me. I have even tried creating a very simple SQL predicate, that mirrors another condition, e.g. ( &TABLE_ALIAS.STRIPE_CD = 'ORA_SVC_HRHD' ), but it still doesn't work. More specifically - I have a role with the seeded "view all HRHD request" condition, which was working as intended and I could see all SRs in the UI. However, if I go into the Data Security Policy and replace it with my custom condition which has an exact copy of

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!