Fine .. recently one of my friend posted this question to me like how to update row in data table in pega? this question can be answered in many ways …. options are below
1. If its data table, u can directly inter values using data table editor which in turn reflect in to DB table
2. If you want to modify data table structure, i,e wanted to add a extra column in data table, simple visit respective data class and then go to edit list.
3. You can also go to your DB directly and then execute alter table, then back to your data table and use external table mapping to synch it.
Its always best practice to determine your data structure and tables before implementation in pega
What is Data Table?
Data Table in PEGA is nothing but a user interface to create Tables in to the back end DB. Data Table wizard, you can directly create the class, the properties, and associated other rules for a data table. Using the Data Table editor, you can then add rows (saved instances), update rows, or delete rows. You can also use Microsoft Excel to add rows, update rows, and delete rows, and then apply your changes to the data table with the Data Table editor.
For example inf I create “Country code” Data Table in PEGA in back end DB it will create new table with the colums you provide with the table name “”Country code”.
Here is how to create a simple Data Table in PEGA
Click PEGA button Go to Data Mode then Data Tables then click Data Tables,
- Data Tables
Now click the button Add new Data Table
- Data Tables button screen
In the new screen give class name under your Data- , ie YourCompany-Data-Your Data Table Name, select Data- in derived from
Data Tables final screen
As mentioned in above screen enter the data table column names, click Generate your table get create (it takes some time to complete the process).