Process model and script task

Hi Eric,
In your second Write to Datastore node, navigate to the Outputs tab. Are you saving the value of "Stored Values" back into your CDT?

Hi Eric171,

This is default behavior of appian. if your cdt does not have auto-generated ID automatically a-id is generated in database side. it starts with 1,2,3....so on. it means it is not seqenece value.

Hope it is understand.


Regards,
Bhanu

Hi Eric,

The default behavior of Appian is that if there is no primary key defined in a CDT, while publishing the data store and creating a table, an extra column with the name a_id would be created in the DB. In order to avoid this, please make a column as primary key.
Also to auto-generate, use @GeneratedValue annotation in the xsd of CDT.

Thanks,
Hema

Hi Eric,

To get the auto generated id in the process, you need to save the result. For that go to Data, output tab and save the store values to your same CDT. Thanks

Hi erics,

As all practitioners said it is completely appian default behaviour. You need to make one of the columns in CDT as a primary key in order to avoid a-id.

Thanks,
ravalik

By default, Appian assigns a_id as the primary key if there are no primary key in the CDT. You need to assign the ID as a primary key. And in your database scheme you can add an 'auto increment' property for the ID.