Pega BIX Extract Key Name
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.
Accepted Solution
Updated: 24 Nov 2023 11:34 EST
Bits in Glass
IN
@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.
Bits in Glass
IN
@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.
Carelon Global Solutions
IN
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?
Bits in Glass
IN
@SakethRajanG16833058 No that is not required. Table A key- column in Table A. Table B - column in Table B.
Carelon Global Solutions
IN
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.
Accepted Solution
Updated: 24 Nov 2023 11:34 EST
Bits in Glass
IN
@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.