I am working on a validation business rule that allows only specific people to change a request from CLOSED status to OPEN
I figured the best way to do this would be using the REQUEST_EVENT table and CREATED_BY column. However, the event is only created AFTER insert so this wouldn't work. Is there another way to set this rule by the user actively doing it? or are business rules limited to tables & columns?
Is this something i would need to do via XML?