159
Views
3
Comments
[OutSystems Data Grid] Date fields are not de-serialized properly
outsystems-data-grid
Reactive icon
Forge asset by OutSystems
Application Type
Reactive

Hi,

We have a data grid that contains date columns. When we de-serialize the changed rows into the underlying structure, the date fields are emptied.

Attached is an example .oml that reproduces the error. Just change one of the quantity fields and press the button. Notice that the date fields in the bottom of the screen are empty. When I debug this, the JSON coming from GetChangedLines does contain the values for the dates. But after the deserialize dates are empty.

Can you please advice on a solution?

Regards,
Alfio Esposito

TestDateColumns.oml
2019-05-02 11-42-50
Alfio Esposito

Hi,

If I change the data type in the structure to Date Time it works again. I can probably use this to resolve our real use case.

I am still interested to know if this is considered to be "as per design" or that this is an error somewhere? Because if the data source contains a date field and the grid contains a date column, it somehow seems weird that the JSON containing the changed lines contains a date/time field or timestamp and that this leads to emptying the field when you de-serialize the JSON.

Any thoughts on this?

Regards,
Alfio

2022-04-29 09-08-10
Pramod Torase

getting same issue!!!! :(

2024-02-22 15-41-45
Trương A Xin

Getting same issue.

Even after 4 years since this post was created, no solution has been found. DataGrid Date Columne and Deserialize Outsystems do not work together. A bad design.

There are some solutions such as converting the Date column to DateTime, but this is only a temporary solution. If you use this method, it will sometimes crash the program because some previous logic needs the Date type rather than DateTime.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.