MYQL - "Date" Primary Key - No CreateUpdate Entiy Action

MYQL - "Date" Primary Key - No CreateUpdate Entiy Action

  

hi there,

i create an external table with primary key of type date:

CREATE TABLE `xxx` (
    `ApplicationDate` DATE NOT NULL,
    `Count` BIGINT(20) NULL DEFAULT NULL,
    PRIMARY KEY (`ApplicationDate`)
)

After manage dependency, only CreateXX entity action is shown. How to show another entity actions? Thank you.

regards,

Solution

Hi Gede,

From what I know of the Outsystems platform, the CreateOrUpdate action only appears for Primary Keys of type Integer, Long Integer, Text or Entity Identifier. You can't add DateTime primary keys in Outsystems.

As a workaround, you could set an Integer or LongInteger primary key with AutoNumber and add a Unique Index to your ApplicationDate attribute. 

This way, the CreateOrUpdate action (and other actions, Delete, etc...) would appear and you would still be able to guarantee that there are only unique dates.

Cheers,

João

Solution