After Update sort is not working with date values
After Update sort is not working with date values
Before we make update all date colums was as string in Stimulsoft and date Sorting was working.
After Update date colum is also string but now it sorting like a realy string.
So we must edit all reports to change date colum from string to datetime.
Is it a easier way to do this ?
Thanks for help
Best regards Peter
After Update date colum is also string but now it sorting like a realy string.
So we must edit all reports to change date colum from string to datetime.
Is it a easier way to do this ?
Thanks for help
Best regards Peter
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: After Update sort is not working with date values
Hello Peter,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: After Update sort is not working with date values
Hi Lech
Its simple to reproduces the issue.
We have in Datatables a field named "date" (its realy a date field but in all reports its a string datatype)
When i have a datatable and make sorting by date (datatyp = string) sorting = wrong
When i habe a datatable and make sorting by date (datatyp = datetime) sorting = working
In older Versions it was working correct and also when datatyp = string sorting correct. I think it automaticly checked its a datetime datatype.
In new Version it use this as string and sorting is wrong.
The Solution is to change all Reports with field date from string to datetime. But we habe so many reports so it will be very difficult to change all reports.
Sorting date as datetime = correct:
2024-04-28
2024-04-29
2024-04-30
2024-05-01
2024-05-02
Sorting date as string = wrong
2024-05-01
2024-05-02
2024-04-28
2024-04-29
2024-04-30
Perhaps is a solution, so we don't change all Reports.
Thanks Peter
Its simple to reproduces the issue.
We have in Datatables a field named "date" (its realy a date field but in all reports its a string datatype)
When i have a datatable and make sorting by date (datatyp = string) sorting = wrong
When i habe a datatable and make sorting by date (datatyp = datetime) sorting = working
In older Versions it was working correct and also when datatyp = string sorting correct. I think it automaticly checked its a datetime datatype.
In new Version it use this as string and sorting is wrong.
The Solution is to change all Reports with field date from string to datetime. But we habe so many reports so it will be very difficult to change all reports.
Sorting date as datetime = correct:
2024-04-28
2024-04-29
2024-04-30
2024-05-01
2024-05-02
Sorting date as string = wrong
2024-05-01
2024-05-02
2024-04-28
2024-04-29
2024-04-30
Perhaps is a solution, so we don't change all Reports.
Thanks Peter
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: After Update sort is not working with date values
Hello Peter,
We couldn't reproduce the issue on our test data.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
We couldn't reproduce the issue on our test data.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: After Update sort is not working with date values
Hi Lech,
I was also able to reproduce the error.
Attached is an example report.
Date field (not working):
Sort not working:
Date field (working)
Sort working with correct date field:
Thanks in advance.
Florian
I was also able to reproduce the error.
Attached is an example report.
Date field (not working):
Sort not working:
Date field (working)
Sort working with correct date field:
Thanks in advance.
Florian
- Attachments
-
- pensionlist.txt
- (18.21 KiB) Downloaded 58 times
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: After Update sort is not working with date values
Hello,
Please send us test data for your report.
Thank you.
Please send us test data for your report.
Thank you.
Re: After Update sort is not working with date values
Hi Lech,
here I send you the report including the data.
Thanks in advance.
Florian
here I send you the report including the data.
Thanks in advance.
Florian
- Attachments
-
- Pensionslist String (not Working).mdc
- (99.48 KiB) Downloaded 52 times
-
- Pensionslist DateTime (working).mdc
- (99.48 KiB) Downloaded 29 times
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: After Update sort is not working with date values
Hello,
It is the rendered report.
Please send us a sample report with test data that we can check and run, and reproduce the issue.
Thank you.
It is the rendered report.
Please send us a sample report with test data that we can check and run, and reproduce the issue.
Thank you.
Re: After Update sort is not working with date values
Hi Lech,
here I send you the report and the data.
Thanks in advance.
Florian
here I send you the report and the data.
Thanks in advance.
Florian
- Attachments
-
- pensionlist.mrt
- (18.21 KiB) Downloaded 28 times
-
- pensionlistdata.json
- (9.68 KiB) Downloaded 32 times
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: After Update sort is not working with date values
Hello,
Thank you for the sample. We need some time to investigate the issue.
Thank you.
#14499
Thank you for the sample. We need some time to investigate the issue.
Thank you.
#14499