Solved

RDM: The capability to create a new record with a unique Primary Key column through the UI, accompanied by the restriction of disallowing any subsequent edits to the Primary Key ID.

  • 21 July 2023
  • 2 replies
  • 37 views
O
Userlevel 2
Badge +5

Dear Community,

I require your assistance with a specific scenario in RDM (Record Data Management).

We have a table in RDM that allows users to create, edit, and delete records, which are synchronized back to the database. This table contains a primary key ID column. During the creation of a new record, the user provides the Primary key value. However, the challenge we face is that this primary key column should not be editable afterward to maintain its uniqueness as a key.

We attempted to restrict column-level permissions, but this resulted in the Primary key column not being visible even during the creation of a new record.

I would appreciate your guidance on this matter.

Thanks very much.

Ojaswini

icon

Best answer by AKislyakov 21 July 2023, 05:31

View original

2 replies

A
Rank
Userlevel 4
Badge +4

Hi @Ojaswini,

 

In RDM Model there is an option to set column as “Generated”. With following tooltip:

Determines whether the values for the column are automatically generated on the side of the database. If checked, column value will be possible to enter only when creating a record; the column will be inactive when editing the record. In addition, if this column if entered in the ID generators tab, it will be inactive even when creating a record.


There is an example of using this checkbox in the RDM Banking Example project, specifically on the product_group table.

 

O
Userlevel 2
Badge +5

Thank you @AKislyakov .

Solution worked. Earlier we thought it is mandatory to add column in ID generation if generated check box is ticked. Really appreciate your quick reply we implemented that.

Best regards,

Ojaswini

Reply


Community Terms of Use & ConditionsCookie settings