Forums Ignite UI for jQuery
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
Close
Ming Zhang
1045
feature persist
posted

Hi experts,

I'm studying grid's feature persist . http://igniteui.com/grid/feature-persistence

I see we can persist all features on page. But how can we persist features between postbacks? Is there a way to save the feature to database, and restore it next time we open the same page? Thanks in advance.

Parents
  • 17590
    Offline posted

    Hello Ming,

    Thank you for posting in our community.

    What I can suggest for achieving your requirement is getting the state of the features that you would like to persist using every features columnSettings option. This could be done on the relevant event for each feature such as dataFiltered, columnSorted etc. In these events you could store the current columnSettings in a localStrage varable. With local storage web applications can store data locally within the users browser.  For example:

    

      $(document).ready(function () {
                if (localStorage) { loadUserSettings(); }
    

                function loadUserSettings() {
                    var tempSortCol = localStorage.getItem('igGridSortedColumns');
                    var tempFilterData = localStorage.getItem('igGridFilterData');
                    var tempCurrPage = localStorage.getItem('igGridCurrPage');
    

                    if (tempSortCol) {
                        igGridSortedColumns = JSON.parse(tempSortCol);
                    }
    

                    if (tempFilterData) {
                        igGridFilterData = JSON.parse(tempFilterData);
                    }
    

                    if (tempCurrPage) {
                        igGridCurrPage = tempCurrPage;
                    }
                }
    

                $('#grid1').igGrid({
                    height: '550px',
                    dataSource: employees,
                    features: [
                    {
                        name: 'Sorting',
                        type: 'local',
                        mode: 'single',
                        columnSorted: function (evt, ui) {
                            var columnSettings = $('#grid1').igGridSorting('option', 'columnSettings');
                            localStorage.setItem('igGridSortedColumns', JSON.stringify(columnSettings));
                        }
                    },
                    {
                        name: 'Filtering',
                        dataFiltered: function (evt, ui) {
                            var filteringSettings = $('#grid1').data('igGrid').dataSource.settings.filtering.expressions;
                            localStorage.setItem('igGridFilterData', JSON.stringify(filteringSettings));
                        }
                    },
                    {
                        name: 'Paging',
                        type: 'local',
                        pageSize: 10,
                        pageIndexChanged: function (evt, ui) {
                            localStorage.setItem('igGridCurrPage', ui.pageIndex);
                        }
                    }
                    ]
                });
                if (igGridSortedColumns.length > 0) {
                    for (var i = 0; i < igGridSortedColumns.length; i++) {
                        if (igGridSortedColumns[i].currentSortDirection) {
                            $('#grid1').igGridSorting('sortColumn', igGridSortedColumns[i].columnIndex, igGridSortedColumns[i].currentSortDirection);
                        }
                    }
                }
                if (igGridFilterData.length > 0) {
                    $('#grid1').igGridFiltering('filter', igGridFilterData, true);
                }
                else {
                    if (igGridCurrPage >= 0) {
                        $('#grid1').igGridPaging('pageIndex', parseInt(igGridCurrPage));
                    }
                }
            });

    Additionally, for Hiding,Resizing and ColumnMoving  you could take information from columns option of igGrid.

    I am also attaching a sample illustrating my suggestion for your reference.

    Please let me know if you need any further assistance with thi smatter.

    RestoreSettings-LocalStorage.zip
  • 17590
    Offline posted in reply to Ming Zhang

    Hello Ming,

    Thank you for getting back to me.

    Since you are setting the autoGenerate option to false this means that you will have to provide column descriptions when initializing the grid. Alternatively, you could set this option to true and grid will initially generate it`s columns automatically. Afterwards, when you make some changes to column`s order, size etc. these changes will be reflected in the columns collection. Corresponding events should be handled in order to modify columns collection in local storage as well.  If the variable storing columns in the grid exists in the localStorage(which means that some changes are made) you could set it to the columns option of the grid.

    Regarding your second question I believe the ColumnMoving feature of the grid is what you are looking for If (as I assumed) you would like to change columns positions. If this is not exactly what you are trying to achieve please provide me some more details and I will investigate further.

    I hope you find this information helpful.

    Please let me know if you need any further assistance with this matter.

Reply Children