Level 2

Solved

Create more than one primary key in schema?

5 replies
2059 views
Translate All

I am new one to adobe campaign classic it is possible to create more than one primary key in custom schema?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Manoj_KumarAccepted solution

Community Advisor

Hello @kumar_27

Yes, you can create a composite key in AC.

Here is an example:

  <key internal="true" name="id">

      <keyfield xpath="@field1"/>

      <keyfield xpath="@field2"/>

    </key>

Manoj | https://themartech.pro

Manoj_Kumar

Accepted solution

Community Advisor

Hello @kumar_27

Yes, you can create a composite key in AC.

Here is an example:

  <key internal="true" name="id">

      <keyfield xpath="@field1"/>

      <keyfield xpath="@field2"/>

    </key>

Translate

Manoj | https://themartech.pro

ParthaSarathy

Community Advisor

@kumar_27 , Yes you can create a composite primary key by using the above syntax provided.

In structure, you can see PK symbol as below

If field1 & field2 is your composite primary key, and when you insert values for field1 and field2 as a-a, then a-b, b-a, and b-b, it will accept. But when you try to add b-b again, it will throw error '1 record(s) already exist in the database'

Translate

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

K

Kumar_27Author

Level 2

@parthasarathy thanks a lot for your clear explanation.

Translate

LakshmiPravallika

Community Advisor

Hi @kumar_27 ,

If you want , you can create the Combination of Columns what you want as the Primary key which is called as Composite Key in Adobe Campaign.

Syntax:

Please find the documentation for reference:

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-reference/elements-attributes/key.html?lang=en

Regards,

Pravallika.

Translate

Craig_Thonis

Adobe Employee

Hi Preeth,

The short answer to your question is no. However, this is not a product limitation but a standard practice for databases in general.

You can use a combination primary key, combining two fields to create a unique key. You can also have foreign keys, which are primary keys from other tables linked to your table.

I recommend walking through the developer documentation section in the Campaign documentation before diving into any schema changes. Additionally, if you are new to database management/development, then I would recommend leveraging your database's website documentation as all databases have their own syntaxes and nuances that can greatly impact performance.

Translate

Sign up

Login with SSO

Login to the community

Login with SSO