How do i change the field of primary key in a record ?

10 replies
23 views

I gave an field as an primary key by mistake and now i want to give the primary key field to another field. Can anyone help me with that, iam new to appian.

tejak2639Answer

Inspiring

Hi [mention:e6afcf0941054cb6b3855cfc2340cdab:e9ed411860ed4f2ba0265705b8793d05]
If you have created a new field JOB_POSTING_ID after there are some entries inserted in the table, then while creating the field keep the default value as NULL(If not null then 0's will be stored to all the fields and above error will be shown) and apply the auto increment (Click on check box).

adityag9712

Inspiring

If your record was created from a database table, you need to update the primary key in the database table. After that, perform a remapping of the record source in Appian. Once the remapping is complete, the changes will be reflected in the record type

- Aditya

Z

zaheds9374Author

Known Participant

This is the error iam getting when iam trying to give the primary key as a new field.

tejak2639Answer

Inspiring

Hi [mention:e6afcf0941054cb6b3855cfc2340cdab:e9ed411860ed4f2ba0265705b8793d05]
If you have created a new field JOB_POSTING_ID after there are some entries inserted in the table, then while creating the field keep the default value as NULL(If not null then 0's will be stored to all the fields and above error will be shown) and apply the auto increment (Click on check box).

harshas2775

Brainy

FIrst you need to make the changes in your database table by dropping the primary key there and applying it to to the intended column. Once done in database you can update the mappings in the record.

Happy to help. Even happier to optimize.

konduruc733182

Inspiring

Hello [mention:e6afcf0941054cb6b3855cfc2340cdab:e9ed411860ed4f2ba0265705b8793d05]

Please refer this basics of SQL which would help you achieve. www.w3schools.com/.../sql_primarykey.ASP

Sign up

Login with SSO

Login to the community

Login with SSO