sergeys posted on June 5, 2012 at 2:44 am

The fix for this issue will be available in the next release.
As a workaround you can globally redefine the “d” pattern used by default by wijgrid and wijinputdate:

        Globalize.cultures['default'].calendar.patterns['d'] = ‘yyyy-MM-dd’;

Filter may work incorrectly due to non-zero time portion in the filter value as filter editor uses the current datetime if filterValue is not set. You can truncate time portion at run-time:

        $(‘#demo’).wijgrid({
                showFilter: true,
                data: [
                        [0, new Date('01/01/2011')],
                        [1, new Date('06/30/2012')],
                ],
                columns: [
                        { },
                        { dataType: 'datetime' }
                ],
                filtering: function (e, args) {
                        if ((args.column.dataType === ‘datetime’) && (args.value instanceof Date)) {
                                args.value = new Date(args.value.toDateString());
                        }
                }
        });

AlexPaterson posted on June 26, 2012 at 8:52 am

Hi everybody.
First of all, lots of thank you for the gorgeous work you’re doing: Wijmo is a really great collection of API.

I’m updating my experience with this wijmo grid issue after trying version 2.12.
Using dataType: “datetime” on my column ( yyyy-mm-dd ) works on internet explorer but stops on the “loading” screen if using Firefox and Safari.

Besides that, the “equals” filter does not work on dates, even using IE.
And the “BeginsWith” filter does not work on strings.

Just saying, so that you can check
Bye

Simone

AlexPaterson posted on June 27, 2012 at 2:15 pm

Sorry, I am using MM for month infact.

Anyway, my DOM table is :

And my Wijmo grid is defined by this code:

$(“#tabella”).wijgrid({

allowPaging: true,
pageSize: 20,
pagerSettings: { position: “bottom” },
allowSorting: true,
scrollMode: “horizontal”,
showFilter: true,
ensureColumnsPxWidth: true,
showFooter: true,
columns: [

{ dataType: "datetime",
dataFormatString: "dd/MM/yyyy",
width:140
},

{ dataType: "number",
allowSort: false,
dataFormatString: "n0",
width:120
},

{ dataType: "string",
allowSort: false,
width:300
},

{ dataType: "string",
allowSort: false,
width:300
},

{ footerText: " NEW ",
showFilter: false,
allowSort: false,
width:50
}

]});

I’m sorry I pasted lots of code, but I hope this will be of any help.
Thank you !

Simone

AlexPaterson posted on June 29, 2012 at 7:42 am

Thank you sergeys for your answer !
I’m checking with your sample but I still can’t make the “Equal” filter work on dates.
I am doing the following actions on your sample:
- Insert 03/12/2012 as search date
- Press “Greater than” and see 04 – 05 – 06 / 12 / 2012. ( Correct )
- Press “Equals” and see no line. ( Not Correct ).

I do not know if this is an issue with my localization, I am using an Italian version of Firefox 13 and IE 9.
I have tried adding the line

script src=”http://cdn.wijmo.com/external/cultures/globalize.culture.it-IT.js”
type=”text/javascript

To the imports. But with no result.

As per the issue about grid stuck in loading screen, your sample works and my table does not. I’ll check

Thank you again !
Simone

sergeys posted on July 2, 2012 at 6:46 am

The problem with TD formatting will be fixed in the next release of wijmo.

As for DateTime + Equals:
You need to truncate time part from the value obtained by wijgrid from wijinput as it may be there.

  filtering: function (e, args) {
        if (args.column.dataType === ‘datetime’ && args.value instanceof Date) {
                args.value = new Date(args.value.getFullYear(), args.value.getMonth(), args.value.getDate());
           }
  }

Please note that a ISO 8601 string parsed by js Date() object may have non-zero number of hours due to UTC offset which also may influence comparing dates with “Equals” operator.

To diagnose you can try to verify data using grid’s data() method and compare them to the filter value in the filtering event handler. wijgrid compares dates as numbers returned by date.getTime().