Hello Deon,

I am not quite sure what your exact use case is, however, if the column definition the grid is initialized with differs from the one you are pushing in the iggridrendering event handler by more than just order (e.g. the new column definition has columns not defined on initialization), then the new column definition will not adhere to the initial schema which prevents the grid from data binding. One possible solution to this is setting localSchemaTransform to false. This can cause some side effects, such as date columns represented by strings in the data source not getting auto-parsed, but it's worth a try.

I hope this helps!

Best regards,

Stamen Stoychev

Hello Stamen,

I am saving away the column setting to local storage in an MVC project. When the grid loads, i am reloading the settings in the "iggridrendering" event. This works fine, except if the source columns change - e.g. when removing a column from the datasource. This now causes an error when the grid loads, as the removed column is loaded but then not found.

What is the best way to handle changes to the column definitions when saving away the column settings?

Regards

Deon

Hello Stephen,

Could you please share how you are able to save the grid filtering setting (FILTERING_SETTING)? The igGrid filtering api does not provide for any events that fire after a column is filtered upon. Your help is much appreciated!

Hi again,

I have a few more questions relating to the saving and restoring of grid settings.

Firstly, the settings I'm saving/restoring are -

* Column Order

* Column Widths

* Hidden Columns

* Column Filters

* Page Size

* Column Sorts

* Grouped Columns

Using some of the previous suggestions, I'm doing the restoring of settings by handling both the iggridrendering event and the iggridrendered event.

In the iggridrendering handler, I set the grid's columns array from my cookie data using the following code -

// Sets the grid columns based on the cookie data.
var columns = getGridSettingFromCookie(COLUMN_SETTING);
if (columns != null) {
    $("gridSelector").igGrid("option", "columns", columns);
}

This restores the column order, column widths and hidden columns.

In the iggridrendered hander, I set the column filters, page size, column sorts and grouped columns using the following code -

// Sets the grid column sorting based on the cookie data.
var sortingExpressions = getGridSettingFromCookie(SORTING_SETTING);
if (sortingExpressions != null) {
    $.each(sortingExpressions, function (index, expression) {
        $("gridSelector").igGridSorting("sortColumn", expression.fieldName, expression.dir);
    });
}

// Filters the grid based on the cookie data.
var filteringExpressions = getGridSettingFromCookie(FILTERING_SETTING);
if (filteringExpressions != null) {
    $("gridSelector").igGridFiltering("filter", filteringExpressions, true);
}

// Sets the grid page size based on the cookie data.
var pageSize = getGridSettingFromCookie(PAGE_SIZE_SETTING);
if (pageSize != null) {
    $("gridSelector").igGridPaging("pageSize", pageSize);
}

// HACK: Limitation that it doesn't restore ascending/descending column sorting.
// Sets the grouping based on the cookie data.
var groupedColumns = getGridSettingFromCookie(GROUPING_SETTING);
if (groupedColumns != null) {
    $.each(groupedColumns, function (index, columnKey) {
        $("gridSelector").igGridGroupBy("groupByColumn", columnKey);
    });
}

Note that I'm saving the settings by handling various events when different grid settings change, and then saving the relevant data to cookies.

This works fairly well overall, but it's not working perfectly. My questions are -

1. I can't find a way to save the grouped column sorting. Can you tell me how I can do this?

2. Does my logic for restoring the grid settings seem reasonable to you, or can you think of a better way to do this?

3. When the grid loads up, the last column always expands out to fill the space. I've set the width of the grid to "100%", but I'd like the last column to only take up the width it's set to. I'm developing an ASP.NET MVC application and setting up a GridModel instance to pass to the view from the server. I've noticed there's an AutofitLastColumn property on the GridModel, but for some reason this is a string rather than a bool, and if I set it to something like "false", nothing changes. Even when I set this option in JavaScript using the code $("gridSelector").igGrid("option", "autofitLastColumn", false); nothing changes. Please let me know how I can achieve this.

Thanks for all your help once again