Is that possible to create multiple CDT from a single database table ?
Discussion posts and replies are publicly visible
Generally yes, though I don't do it that often since it can quickly grow very confusing. Can you tell us a bit more about your use case, and/or what you're trying to accomplish?
I would like to include a default attribute to CDT after adding default values in tables.
What exactly do you mean? CDTs will not help with default values. I typically try to keep the DB dumb and put logic into Appian.
I would like to make a field value as default in application whenever a record is entered in the database. I have updated the table and set the dafault value in the database for that particular column. But when I tried to enter values in a row in the table the default values do not populate in the table.
shubhamy0001 If you want to have default values in the table upon insert, you can add the default values to the required attribute(s) in the following ways:
In both ways, you can also define any logic that determines the default value.
dastagirid756 the interface fields are populated from the database table fields. So the default must be implemneted at database level.
shubhamy0001
Database Level Default Setting and CDT for writing and reading:
To insert the database table field's default value using write to datastore entity follow the below steps:
To populate the database table field's default value on the screen
Alternatives with intermediate modification:
If you want to have default values in the table upon insert, you can add the default values to the required attribute(s) in the following ways:
You can assign the default values to the CDT attributes, before populating on the screen.