Identity Column in a Entity

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)

   

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:

https://www.outsystems.com/forums/discussion/69401/how-to-ensure-unique-values/

https://www.outsystems.com/training/lesson/2150/indexes

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Create_an_Entity_Index


Hope it helps.

Regards.

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