Question
Mindtree
AU
Last activity: 1 Jul 2016 1:50 EDT
How to map work objects to new data table and how to access them?
Hello friends,
How can I map work objects to new data table instead of mapping work objects to default table(pc_work) and how to access work objects using obj-activity methods?
Pegasystems
US
Your work objects are in class X which is in some class group G. Look in the ruleform of X to find G.
Next, click "records" left margin of developer portal and then go to
Sysadmin > Data Table
In the list that comes up, put G in the "Class Name Contains" field and click "run", and then click the entry associated with G. This brings up the Data-Admin-DB-Table rule form associated with your class, and you can change the "table name" field to your preferred table name.
Then click "check connection" to make sure your preferred table actually exists. If it doesn't, could someone else please chime in or pipe up to explain this part? /Eric
Mindtree
AU
Hi Eric,
Thanks for your reply..
I am getting error in connectivity.Can u please look into the screenshots and let me know where I have done mistake.
Pega Systems
IN
Is the schema name corret ?
Mindtree
AU
Hi sarang,
Where to give schema name and can u please tell me the whole process of mapping work objects to new data table.
Pega Systems
IN
Based on the screenshot, it is clear that LoanInsurance table has not been created in schema "personaledition".
You can try replacing Database value to PegaDATA on Database table RuleForm.
High level step to map work objects to different table would be as below.
1) If Class is mapped to table "xy", create a new table "yz" based on definition of table "xy".
2) If table "yz" is created in different schema (apart from PegaRULES/PegaDATA), create Database Rule for it.
3) Then create/update a Database Table Rule for the class selecting proper values for Database and Database Table.
Pegasystems
US
Is it that your table hasn't been created yet? Or that it is created but in a different database? Hopefully some other person reading here can help us more. /Eric