2 Replies Latest reply on May 3, 2016 5:22 AM by MohammedImran

    How to add sql to Attachment Functions to restrict access based on record status

    OliveS

      I need to restrict the ability to insert/update/delete attachments based on the status of a record. This is easily done on the Attachment Functions form if you only need to check for one value. However, in my case I need to check multiple status values. I'm trying to use sql to do this but it is not working. The sql I am using does not error and returns the correct rows in sql*plus, however it does not prevent updates on the attachments form. Please advise how to create the sql statement to make this work. I've attached screenshots of my setup.