Question
Infosys Ltd
IN
Last activity: 19 Dec 2017 5:18 EST
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.
Thanks in Advance
Pegasystems Inc.
IN
Hi Pranay,
You may try below steps.
1) Create an Activity
2) Identify the class name for which you want to modify the blob.
3) Open the rule in designer studio and check for the property that needs to be changed. You will find this in View XML
4)Do objBrowse in Activity steps to loop through all the records for concerned class
5) Inside loop change the required property that you have identified in step 3
6) Perform OBJ- Save and you are done.
Thanks,
Ujjwal
Infosys Ltd
IN
Hi Ujjwal,
Thanks for your answer.
We need to do it with sql function named "pr_write_from_stream" directly in DB instead of going to the activity.
Can you please let us know , how it can be done using a query in DB.
Thanks,
Pranay
Pegasystems Inc.
IN
Hi Pranay,
I am not sure if its a easy task to read blob as it is a compressed dump of an in memory sparse structure.
Even if possible it would be very tedious and time taking to achieve.
However using OBJ browse will require very less develop and easier to achieve.
Thanks,
Ujjwal
Infosys Ltd
IN
Hi Ujjwal ,
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
Thanks,
PK