Codeless UI Defect: Data Table edit allows you to set null value to mandatory column

Server Code Codeless
1

Steps

  1. Create a table Mandatory with one Non-Null, Unique, Indexed column
  2. Fill in some values in the backend
  3. On Frontend create a new page
  4. Add a data table to the page and link it with table Mandatory and permit editing
  5. Launch page
  6. Edit a row and clear the Non-Null, Unique, Indexed column
  7. Save
    Problem
    Save succeeds and database now has a null value for a non-null column

This is not possible in Backend UI - guessing backend validation is missed somewhere.

Thanks

2

Hello @Anonymous_Anonymous4.

We were able to reproduce this problem. Thanks for your feedback. Ticket BKNDLSS-23727 has been created.

Regards, Nikita.

3

Hi, @Anonymous_Anonymous4

We’ve updated cloud servers with a fix for the issue you described above. Could you kindly let us know whether fix works for you well?

Regards, Marina

4

Verified following steps to reproduce. Product now returns an error as expected:
{“code”:1048,“message”:“Column ‘mandatory’ cannot be null”,“errorData”:{}}

Thanks