Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1005
16.2 -> 19.1 igGrid date columns now include time formatted as such T00:00:00Z
posted

I tried moving from 16.2 to 19.1 and now the dates all show with time.  They used to show MM/dd/yyyy only.  I tried using the format property on the date column and it seems to ignore it.

It seems to be specific to updating the Infragistics.MVC.dll as I use the GridDataSourceAction applied to my MVC controller action.

    $('#grid').igGrid({
        autoGenerateColumns: false,
        autoGenerateLayouts: false,
        mergeUnboundColumns: false,
        height: gridheight(),
        width: "100%",
        virtualizationMode: "continuous",
        rowVirtualization: true,
        fixedHeaders: true,
        responseDataKey: "Records",
        generateCompactJSONResponse: false,
        localSchemaTransform: false,
        primaryKey: "Id",
        enableUTCDates: true,
        columns: [
            { headerText: "Number", key: "Number", dataType: "number", width: 80 },
            { headerText: "Group", key: "TicketGroup", dataType: "string", width: 100 },
            { headerText: "Type", key: "TicketType", dataType: "string", width: 120 },
            { headerText: "Creator", key: "Creator", dataType: "string", width: 160 },
            { headerText: "Date", key: "TicketDate", dataType: "date", width: 120},
            { headerText: "User", key: "ReferenceUser", dataType: "string", width: 160 },
            { headerText: "Description", key: "Description", dataType: "string"},
            { headerText: "Category", key: "TicketCategory", dataType: "string", width: 160 },
            { headerText: "SubCategory", key: "TicketSubCategory", dataType: "string", width: 160 },
            { headerText: "Assigned", key: "AssignedUser", dataType: "string", width: 160 },
            { headerText: "Priority", key: "TicketPriority", dataType: "string", width: 90 },
            { headerText: "Children", key: "Children", dataType: "number", width: 70 },
            { headerText: "Status", key: "Status", dataType: "string", width: 170 }
        ],
        autofitLastColumn: false,
        cellClick: function (evt, ui) {
            var grid = ui.owner;
            try
            {
                var gridRow = grid.rowAt(ui.rowIndex);
                var cellCount = gridRow.cells.length;
                // Group by rows have only 2 cells, so if it's greater than 2 it actually is a data row.
                if (cellCount === 2) {
                    processrowcolors(grid);
                }
            } catch(e) {}
        },
        rowsRendered: function (evt, ui) {
            var grid = ui.owner;
            processrowcolors(grid);
        },
        features: [
                    {
                        name: 'Filtering',
                        filterExprUrlKey: 'filter',
                        filterLogicUrlKey: 'filterLogic',
                        filterDialogWidth: 640,
                        filterDialogHeight: 480,
                        filterDialogFilterDropDownDefaultWidth: 120,
                        filterDropDownWith: 120,
                        filterSummaryAlwaysVisible: false,
                        mode: "advanced",
                        advancedModeEditorsVisible: true,
                        columnSettings: [
                          {
                              columnKey: "TicketDate",
                              defaultExpressions: [
                                  {
                                      expr: filterDate,
                                      cond: "after"
                                  }
                              ]
                          }
                        ],
                        type: 'remote'
                    },
                    {
                        name: 'GroupBy',
                        resultResponseKey: 'GroupBy',
                        groupByUrlKey: 'sort',
                        groupByUrlKeyAscValue: 'asc',
                        groupByUrlKeyDescValue: 'desc',
                        initialExpand: false,
                        columnSettings: [
                            { columnKey: "Number", allowGrouping: false },
                            { columnKey: "Description", allowGrouping: false },
                            { columnKey: "Children", allowGrouping: false }
                        ],
                        type: 'local',
                    },
                    {
                        name: 'Resizing',
                        deferredResizing: false,
                    },
                    {
                        name: 'Responsive',
                        enableVerticalRendering: false
                    },
                    {
                        name: 'Sorting',
                        applySortedColumnCss: false,
                        sortUrlKey: 'sort',
                        sortUrlKeyAscValue: 'asc',
                        sortUrlKeyDescValue: 'desc',
                        type: 'local',
                        columnSettings: [
                            {
                                columnKey: "Number",
                                allowSorting: true,
                                firstSortDirection: "asc",
                                currentSortDirection: "desc"
                            }
                        ]
                    }

        ],
        dataSourceUrl: $('#GetDataAction').data('request-url')
    });