jqxGrid – filtertype: 'date' not displayed after applied (IIS only)

[BNKParticipant]

Hi!
I use jqxGrid in my MVC 4 project.

            $("#jqxgrid").jqxGrid(
            {
                width: '100%',                
                source: dataAdapter,
                theme: 'energyblue',
                filterable: true,
                groupable: true,
                pageable: true,
                sortable: true,
                autorowheight: true,
                autoshowfiltericon: true,
                pagesize: '10',
                pagesizeoptions: ['10', '20', '30'],                
                columns: [
                  { text: 'ID', datafield: 'ID', renderer: columnrenderer, cellsalign: 'right', width: '10%' },
                  { text: 'Person', datafield: 'FullName', filtertype: 'checkedlist', renderer: columnrenderer, width: '20%' },
                  { text: 'Date', datafield: 'SysCreated', filtertype: 'date', renderer: columnrenderer, cellsalign: 'center', cellsformat: 'dd/MM/yyyy HH:mm', width: '15%' }
                ],
                groups: ['FullName']
            });

Filter is working OK! However, after filter applied with Date column (for example, less than 13/1/2016 00:00), when open filter panel/window again:

– With IIS Express Visual Studio (http://localhost:24780/personlist): the value 13/1/2016 00:00 still displayed in input control;
– With IIS 7.5 (http://localhost/myapp/personlist): the value 13/1/2016 00:00 NOT displayed in input control.

Please tell me how to fix this issue. Many thanks

[DimitarParticipant]

Hi BNK,

Are there any errors thrown in your browser’s console when running the page on the IIS 7.5 server? Please make sure you are using the latest version of jQWidgets (3.9.1).

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[BNKParticipant]

Hi Dimitar,

From Firefox console, I have found the following:

ReferenceError: Globalize is not defined
.setDate()
 jqwidgets:1
.val()
 jqwidgets:1
n.fn.val()
 jqwidgets:1
._updatefilterpanel()
 jqwidgets:1
._handlecolumnsmenu/h()
 jqwidgets:1
._handlecolumnsmenu/<()
 jqwidgets:1
i.event.dispatch()
 jquery:1
i.event.add/v.handle()
 jquery:1
 jqwidgets:1:956312

Of course, I use ver 3.9.1. Thanks

[BNKParticipant]

Hi Dimitar!

I have just deployed globalize.js files to IIS, it’s working now. Thankyou 🙂

[DimitarParticipant]

Hi BNK,

Please include a reference to the file globalize.js, too. It is necessary for the jqxDateTimeInput widget and can be found under jqwidgets\globalization in the jQWidgets download package.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[BNKParticipant]

Hi Dimitar,

Yes, thanks. I have included it as the following:

bundles.Add(new ScriptBundle("~/bundles/jqwidgets").Include(
                "~/Scripts/jqxcore.js",
                "~/Scripts/jqxdata.js",
                "~/Scripts/jqxgrid.js",
                "~/Scripts/jqxgrid.selection.js",
                "~/Scripts/jqxgrid.pager.js",
                "~/Scripts/jqxlistbox.js",
                "~/Scripts/jqxbuttons.js",
                "~/Scripts/jqxscrollbar.js",
                "~/Scripts/jqxdatatable.js",
                "~/Scripts/jqxtreegrid.js",
                "~/Scripts/jqxmenu.js",
                "~/Scripts/jqxcalendar.js",
                "~/Scripts/jqxgrid.sort.js",
                "~/Scripts/jqxgrid.filter.js",
                "~/Scripts/jqxdatetimeinput.js",
                "~/Scripts/jqxdropdownlist.js",
                "~/Scripts/jqxslider.js",
                "~/Scripts/jqxeditor.js",
                "~/Scripts/jqxinput.js",
                "~/Scripts/jqxdraw.js",
                "~/Scripts/jqxchart.core.js",
                "~/Scripts/jqxchart.rangeselector.js",
                "~/Scripts/jqxtree.js",
                "~/Scripts/globalize.js",
                "~/Scripts/jqxbulletchart.js",
                "~/Scripts/jqxcheckbox.js",
                "~/Scripts/jqxradiobutton.js",
                "~/Scripts/jqxvalidator.js",
                "~/Scripts/jqxpanel.js",
                "~/Scripts/jqxpasswordinput.js",
                "~/Scripts/jqxnumberinput.js",
                "~/Scripts/jqxcombobox.js",
                "~/Scripts/jqxgrid.grouping.js",
                "~/Scripts/jqxgrid.selection.js",
                "~/Scripts/jqxtabs.js"                
                ));

[Author]

Posts