After making changes to the table data, I click the Save Changes button. I have a trigger set up to save the changes. The first thing I see happen is that the table data resets to the original data. Then it appears the trigger runs, but I see the following message appear at the top of the screen:
{"status":422,"message":"An empty list of updates were applied.","statusCode":422,"error":"Unprocessable Entity","data":null,"queryExecutionMetadata":{"estimatedResponseSizeBytes":112,"resourceTimeTakenMs":2,"isPreview":false,"resourceType":"mssql...
I am suspecting that the table is reset before the trigger runs. If I just run the trigger manually, the changes are saved.
I have looked through the table setup, but I can't seem to find any place where I am requesting the table be reset.
Its very simple: the save trigger calls the SAVE_CHECKS query which is nothing more than the BULK UPDATE VIA A PRIMARY key and passing in {{table.recordUpdates}} that's all. When I press save the table shows (in a blink of an eye) the non-edited version and then refreshes to show the edit version again.
Hey @lauren.gus , Good to connect. Well, I'm stuck in an error and kinda similar to this topic. Hope I could use your help. Kindly let know how can we sort this please!! Thank you!
Hey @JayVeni! Stepping in here for Lauren to try getting you moving Do you have the exact same issue (table record updates is clearing before the query runs) or something else?