Updating rule-file text directly using some query/function in DB
We are working on one automation POC and we will be needing your expert advice on the below query.
In PEGA, we have (Soap Service) simulations using activity and rule-file text in designer studio UI. These simulations (rule-file text ) are getting stored in Schema DB under pr4_rule_file table.
Now if we can update the simulation directly into the DB using some query/function, it will reduce the manual steps to go to PEGA designer studio and checking out and checking in activities. This in turn will save the efforts and will be faster. PEGA inbuilt functions like pr_read_from_stream, pega_write_to_stream which can be used to read write from blob.
The OBJ browse is already developed and its in place , but we have an environment in which we need to update using a JAVA / Groovy script at run time . As opening the OBJ Browser activity and updating is not possible on an continuos automated script.
Is there any way to update using a SQL function in PEGA