1
Bug Report / Issue with Date Filters in ParamQuery Grid with Custom Date Formats
« on: August 21, 2024, 08:41:38 pm »
Hello Support Team,
We are encountering an issue with date filters in ParamQuery Grid when the date column is formatted using a custom format function. Here are the steps to reproduce the problem:
1. Go to the ParamQuery demo: https://paramquery.com/pro/demos/filter_date#
2. Modify the singleFilter option to false in the configuration and rerun the demo:
menuUI: {
singleFilter: false
}
3. Try to filter the "Order Date" column using both "Greater Than" and "Less Than" options (see attachment):
Select the first date from the date picker.
Select the second date from the date picker.
4. Observed Behavior:
The filter does not apply correctly.
The second date textbox is left empty.
An error appears in the console:
jquery-ui.min.js:9 Uncaught TypeError: t.charAt is not a function
at s.formatDate (jquery-ui.min.js:9:8028)
at s._formatDate (jquery-ui.min.js:9:20968)
at s._selectDay (jquery-ui.min.js:9:4109)
at HTMLTableCellElement.selectDay (jquery-ui.min.js:9:11648)
at HTMLTableCellElement.dispatch (jquery-2.2.4.min.js:3:7537)
at r.handle (jquery-2.2.4.min.js:3:5620)
We would appreciate your assistance in resolving this issue.
Thank you in advance for your support.
Best regards.
We are encountering an issue with date filters in ParamQuery Grid when the date column is formatted using a custom format function. Here are the steps to reproduce the problem:
1. Go to the ParamQuery demo: https://paramquery.com/pro/demos/filter_date#
2. Modify the singleFilter option to false in the configuration and rerun the demo:
menuUI: {
singleFilter: false
}
3. Try to filter the "Order Date" column using both "Greater Than" and "Less Than" options (see attachment):
Select the first date from the date picker.
Select the second date from the date picker.
4. Observed Behavior:
The filter does not apply correctly.
The second date textbox is left empty.
An error appears in the console:
jquery-ui.min.js:9 Uncaught TypeError: t.charAt is not a function
at s.formatDate (jquery-ui.min.js:9:8028)
at s._formatDate (jquery-ui.min.js:9:20968)
at s._selectDay (jquery-ui.min.js:9:4109)
at HTMLTableCellElement.selectDay (jquery-ui.min.js:9:11648)
at HTMLTableCellElement.dispatch (jquery-2.2.4.min.js:3:7537)
at r.handle (jquery-2.2.4.min.js:3:5620)
We would appreciate your assistance in resolving this issue.
Thank you in advance for your support.
Best regards.