#61 Definition of format for date in dataset and in filter

[agnes camarasa]

We defined the format "d-m-Y H:i:s.u" in fields setup of the dataset.
When we serch an object on the date, the calendar retrun the date with the right format
If we choose a filter (button "filer") on the date, the calendar return the date with a wrong format (Y-m-d H:i:s.u), and the filter action end on error "Problem accessing /imgsatoptpub/records. Reason: An exception occured writing the response entity"

How/Where can I define the format for filter ?

[Mathieu Gond]

Hello,

Thank you for pointing that out, there was actually 2 problems :

• A bug on the server when filtering on a date column, which is causing the exception
• The date format wasn't used in the calendar so you can't change it. But that's not what caused the server bug.

You can get the bug fix by getting the last version on GiThub (branch dev, bug fix will be pushed tonight or Monday morning) or you can directly modify the files I added to the response. Note that the server needs to be compiled with the modified sources in order to fix the bug.

Best regards

Mathieu

[agnes camarasa]

Hello,

Thank for your response, but I only have the runtime SiTools 2.2.1 and no developpemnt environment to compiled sitools.
Can you give me the 2 .class (GridFilter.class and GridFilter$1.class). Can I just replace these 2 files in the fr.cnes.sitools.core.jar to fix the bug ?
I work for CNES (DataQTIS-NG application).

[Mathieu Gond]

Hello,

I attached the 2 .classes, but I am not sure at all It will work if you change it in the jar.
If it doesn't you will have to build the jar from the sources, it is pretty simple and everything is explained in the github page : https://github.com/SITools2/core-v2

If you wish to build the same version you already use, you need to checkout the v2.2.1 tag after you clone the sources.
git clone https://github.com/SITools2/core-v2.git sitools2-v2
and then
git checkout v2.2.1
Then you modify the GridFilter.java file with the one I gave you earlier and you follow the next steps.

Don't hesitate to ask if you have any other questions

Regards

Mathieu

[agnes camarasa]

hello,

I replace the 2 .class in the jar, the 2 js in workspace and the bug is fixed. Thanks a lot.

I have another problem whith fields date. When I enter the date manualy in the format 'dd-mm-aaa' without hour, when I valid the field, the value of the date change : day and month are inverted (for example 05-01-2014 change in 01-05-2014 00:00:00.0).

[SITools2]

Ticket moved from /p/sitools2/feature-requests/51/