If we expose another property of the same pagelist will pega create 2 different declare index rules?

General
,
1

If u expose 2 properties of the same pagelist , will it create 2 separate index tables and if not then how pega knows which property gets changed ,how it keeps track of that?

2

When you expose the 1st property, system will check whether already a rule declare index exists for this, if yes, then it will make use of the same configuration to add the 2nd property when you expose the 2nd one. If not, it will create a fresh one and make use of that for subsequent expose from the same page list property.

3

It will not create 2 separate index tables; it makes use of the same one and add the 2nd property.

4

In one index table, we can have multiple columns. Even if one column value changes, the system re-indexes the entire row. So, one declare index rule is enough for each page list for each corresponding class.

5

Hi @Karuppan so how will pega identify which properties value is getting updated as both of them will be in the same table say property 2 gets updated now how will pega know which property to update in the index table?

6

Hi @VVNagaSaiN Please see my below question as well.

7

Whenever any single property within the page list changes, Pega does not perform an inline update of just that specific column. Instead, the system deletes the entire existing row for that index entry from the table and inserts a brand-new row containing the updated snapshot of all mapped property values.

For example, suppose you have a Declare Index tracking Account Name and Account Number:

  1. Initial state: Account Name = “Savings”, Account Number = 123456. This is written as a row in the index table.

  2. If the user updates only the account number to 5554, Pega deletes the old entry completely and inserts a fresh row: Account Name = “Savings”, Account Number = 5554.

Because it rewrites the full row context during the database commit of the case, Pega doesn’t need to track which specific column changed—it just re-indexes the entire object.

8

Declare Index does not track individual property updates, Instead, Pega regenerates the index records based on the source page list whenever the source changes.

You already have examples and hope this helps.