What is the purpose of Key Name in the Extract rule in pega. Should that be a Unique ID for that table or else can we use any of the property present in that table . Can some one help me on this.
@SakethRajanG16833058 It is a key to link each record that is parent table to this table(pagelist in pega) . Pega will automatically give you a suitable key name having a proper naming convention. If you want to change also you can change to a name you wish to have. You can have any name for that key name but shouldn’t be of any of properties/columns you add to that particular table, because this key will also be a column of that table.
Hi @Anoop Krishna,
Thanks for your response.
Another question .
I have a page list 1 copied to table A , Inside the page list 1 if we have another page list 1.1 copied to table B.
If we declare a key on table A , should that table A key column should be present in the Table B?
@SakethRajanG16833058 No that is not required. Table A key- column in Table A. Table B - column in Table B.
HI @Anoop Krishna
Is that key name is mandatory for the extract rule?
If the A Key is not present as column in the table B then while executing the extract we are getting error like the A Key is not present in the Table B.
@SakethRajanG16833058 okay, sorry I misunderstood. Now I have revisited your comments. As Table2 is child of table1, that child pagelist 2, yes key of Table A-> that is immediate key parent is required in child parent.