nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Inserting DCR field values into table which has auto-increment primary key using DD

Indranag

HI
I can insert the DCR values into Database using data deployment but i want to insert the values into table which consists an auto-increment Primary Key. We don't take Primary Key values from DCR we only take other values and PK values are incremented automatically . Pls help in this issue.

Find more posts tagged with

Comments

jagadesh

HI
I can insert the DCR values into Database using data deployment but i want to insert the values into table which consists an auto-increment Primary Key. We don't take Primary Key values from DCR we only take other values and PK values are incremented automatically . Pls help in this issue.

You can go by tuplepreprocessor implementation for this.
Already some posts are there in devnet for Tuplepreprocessor
Tuple Preprocessor

Rick Poulin

The tuple preprocessor would be one way, but if you don't have crazy foreign key relationships, just don't map the PK column. Tell DD to use some other column for uniqueness checking, and when redeploying a record, it'll delete the old one and insert a new one (with a new PK). This could work with real-updates too if your DD-aware PK is genuinely unique.

You'll need either a preprocessor or a TeamSite-side PK generator if you want to use foreign keys based on your real PK though.