After Update sort is not working with date values

Stimulsoft Reports.JS discussion
Flo
Posts: 23
Joined: Fri Jul 16, 2021 7:18 am

Re: After Update sort is not working with date values

Post by Flo »

Hi Lech,

I just checked the last version 2024.2.6 and it doesn't work either.
The error always occurs with culture = "de-DE";

Please check my information.

Thanks in advance.
Florian
Lech Kulikowski
Posts: 7287
Joined: Tue Mar 20, 2018 5:34 am

Re: After Update sort is not working with date values

Post by Lech Kulikowski »

Hello,

We couldn't reproduce the issue. Could you send us a sample project for analysis?

Thank you.
Attachments
pensionlist.mrt
(21.17 KiB) Downloaded 449 times
Screenshot 2024-05-30 083347.png
Screenshot 2024-05-30 083347.png (186.53 KiB) Viewed 4685 times
Flo
Posts: 23
Joined: Fri Jul 16, 2021 7:18 am

Re: After Update sort is not working with date values

Post by Flo »

Hi Lech,

Attached I'll send you two projects, one how it works and one where it doesn't work.

Working: (date = datetime)

Image

Not working: (date = string)

Image

Thanks in advance.
Florian
Attachments
working.zip
(29.26 MiB) Downloaded 459 times
not-working.zip
(29.26 MiB) Downloaded 293 times
Lech Kulikowski
Posts: 7287
Joined: Tue Mar 20, 2018 5:34 am

Re: After Update sort is not working with date values

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
Lech Kulikowski
Posts: 7287
Joined: Tue Mar 20, 2018 5:34 am

Re: After Update sort is not working with date values

Post by Lech Kulikowski »

Hello,

We have check your project on the 2023.2.8 version. The same result - string is sorted as strings. Please use the DateTime type.

Thank you.
Attachments
Screenshot 2024-06-04 170518.png
Screenshot 2024-06-04 170518.png (140.67 KiB) Viewed 4607 times
Screenshot 2024-06-04 170502.png
Screenshot 2024-06-04 170502.png (267.12 KiB) Viewed 4607 times
Flo
Posts: 23
Joined: Fri Jul 16, 2021 7:18 am

Re: After Update sort is not working with date values

Post by Flo »

Hi Lech,

I checked 2023.2.8 locally and the date is actually formatted incorrectly correctly as a string, but online under a Debian 11 environment it works perfectly, see screenshot.

Image

With other data (same format) but working.

Image

Image

I will now solve the problem using my own PHP parser.

Thank you anyway.
Florian
Lech Kulikowski
Posts: 7287
Joined: Tue Mar 20, 2018 5:34 am

Re: After Update sort is not working with date values

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply