Identity Column in a Entity

Question

Out system says it can only have one column as Identity Column , no composite key is there.

but how can we design a entity where we needs to constantly insert/update records based on few columns which makes data in the table unique

Example, we have a entity for maintaining Payee/Role Relationship with date effectiveness. Columns are

PayeeID

RoleID

StartinRole

EndInRole

Now key attribute in this column can be "PayeeID+RoleID+StartInRole, based on we will insert/update data in this entity on daily basis

Can can we design this in Outsystem to achieve our needs for maintain data in this entity (table)

26 Apr

mvp_badge

MVP

Hello Naveen,

You can create compost keys with 2 or more fields, example:

In this way, the database will not allow records with the same fields to be created, as long as they are unique.

Documents about:

Hope it helps.

Regards.

26 Apr

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.