Support Topics Documentation Slack YouTube Blog

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

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

Hello @Anonymous_Anonymous4.

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

Regards, Nikita.

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

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

Thanks