how does the BIX and Target database handle the pagelist properties and their values?
how does the extraction of pagelist to database is handled? does it directly create new columns for additional properties in the pagelist?
Posted: 4 years ago
Posted: 4 years ago
Please refer to the BIX user guide for further details - https://pdn.pega.com/documents/bix-72-user-guide
When scalar properties in an embedded value list, page list, value group, or page group have been
selected for extraction to a CSV file or to a database, BIX generates a separate CSV extract file or
a separate database table for the embedded properties. BIX promotes scalar properties of
embedded pages (not page lists or page groups) to the parent node.
When you run the extract to generate the schema that you need to apply it will have the "create table" statements for the top level table and any tables needed for value list/group and page list/group properties.