Hi,
I'd developing an ASP.NET MVC application using Infragistics Grid. I'd like to let users save the filtering, sorting, and column hiding options they set on the grid, using a Save button on the UI. So, the setting are not to be saved automatically, but only when the button is pressed. This will extract the setting from the grid, and post them to the server, to store in DB. This part works nicely:
var gridSortingSettings = $("#CompaniesGrid").igGridSorting("option", "columnSettings"); var gridColumnSettings = $("#CompaniesGrid").igGrid("option", "columns"); var gridFilteringSettings = $("#CompaniesGrid").igGridFiltering("option", "columnSettings");
var url = '@Url.Action("SaveGridSettings")'; $.ajax({ type: "POST", url: url, data: JSON.stringify({ sortingSettings: gridSortingSettings, columnSettings: gridColumnSettings, filteringSettings: gridFilteringSettings }), contentType: "application/json; charset=utf-8", dataType: "json", });
What i'd like to do now, is to be able to restore these setting from the database, when loading the grid. I can retrieve these setting as JSON, however, I found no example of setting these options using the MVC View of the grid, as the grid is initialized this way. I have no idea how to set a JSON here. Do you have any suggestion, maybe better ideas for restoring these settings?
I tried setting it manually, this way, using a Restore button (would't be working this way, just for testing):var gridSortingSettings = <get JSON from server...> $('#CompaniesGrid').igGridSorting("option", "columnSettings", gridSortingSettings);Then, reading it again: var gridSortingSettingsReadBack = $("#CompaniesGrid").igGridSorting("option", "columnSettings");I found that however the JSON i read back changes as expected, the grid shows no difference. Maybe I need some way to refresh? Anyway, the perfect solutuon would be to make this load automatically from the MVC View when the grid is initializing grid, like setting @Html.Infragistics().Features().Sorting().Whatever()... in the View.
regards,
Peter
Mike,
Thanks again.
Now, i'm considering to change from MVC initialization to jQuery initialization, to be able to set these settings directly, as you suggested:
"If you use JavaScript/jQuery to initialize the grid instead of the MVC wrappers you can put the settings you got before directly into the column settings property of the different grid features."
Could you please show me an example, how to do this in this case?
Hello Peter,
Thank you for the update. I am attaching a sample that demonstrates creating the columns from an array. Then on button click gets the columns using the API method and then destroys the grid and re-creates it based on the columns it got.
Mike.
Thanks, this way I can save and restore grid settings. However, I noticed that the fitler expressions (like: Name contains "blah", etc. ) don't get saved this way. I managed to get them by saving the following JSON:
var filteringExpressions = $("#CompaniesGrid").data("igGrid").dataSource.settings.filtering.expressions;
And then, restoring it in the igGrid "rednered" event handler like this:
$("#CompaniesGrid").igGrid({ rendered: function (evt, ui) { $('#CompaniesGrid').igGridFiltering("filter", filteringExpressions); } });
This works properly for me, I posted this partly to let others know how this works, but party to ask you Mike, is this the proper way to restore these filter expressions? Or, is there a better way to do this?
Thank you for the update. Currently this is the way to achieve getting the filtered columns expressions as there isn’t a method in the API to get them.
Please let me know if you have any further questions concerning this matter.
Thanks, but my question was not about getting, it was about restoring, as I said:
"is this the proper way to restore these filter expressions?"
And by that, I meant, is it the best option to do this in the "rendered" event handler of the grid, or, maybe it's better to use some other event handlers?