Bug: Grid initial filter doesn't work date and cellformat

[fewrParticipant]

Hallo,

there is the possibility to create *initial filter*.
Generally this works fine.

But there two bugs.
1) I create for a column with datatype = date and an initial filter with date value (dd.MM.yyyy), this works.
Also the filter items (filtertype ‘checkedlist’) are correct selected.
But if the column use cellformat (like yyyy MM) the initial filter works still again but the filter items are not selected.

2) In the same constellation (column datatyp = date and cellformat in use) it’s doens’t matter with filter item is seleced, the result is the nothing could find an non rows are fisible.

I believe both weaknesses happen because the filter search for the strings in cellformat but not the original datatype (dd.MM.yyyy).

[Peter StoevKeymaster]

Hi fewr,

The Grid works with Javascript Date Objects and the cellsformat is only a Display Format. You should pass still Javascript date objects if you want to apply filters. That is valid for the 2 points you mentioned about our Grid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[fewrParticipant]

Hallo Peter

thanks for your response.

I already set up the default filter as Date Objects. This even works and the Grid shows only records which are matching to the date.

The Problem is that the filter-checklist in the filterrow contains a bug.
Because it not use the Date Objects but the visible string from the cellformat.

Therefore none items from the default date-filter are marked as chosen in the filter-checklist.

[Peter StoevKeymaster]

Hi fewr,

Well for Date column, use a Date filter. The checked list filter is for String Data.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[fewrParticipant]

Good Morning Peter,

in my case contains the date column only the first day of each month (1.MM.yyyy).
It would be much more convenience to be able use a checked list filter instead of the the calender/range.

The thing is that generally dates and checklist are compatible.
So filter and checked list works fine, even with cellsformat.

But it’s doesn’t work together with a initial filter.
Neither with a stringfilter (matching to the cellformat), nor with a datefilter (date object).

Until a bugfix, my workaround is to convert the dates already in the source as a strings.
But this is without the possibility easy to use the cellformat for the dates.

[Author]

Posts