Not answered Filter Expression Applied But Does Not Display

Feed from this thread

Larry

Posted on Jul 7, 2009 (permalink)

Hey,

We are programatically creating and saving grids. We have a button that allows the user to save the current state of the grid. The problem we are having is that when we retrieve the grid the filter expression is applied to the grid data which is correct but you don't see the filter value in the filter box over the column nor do you see where the "Equal To" or "Contains" has been set when you click on the down arrow next to the filter value. I've attached the savesettings and loadsetting methods we are using. Is there something else we need to set?

Thanks,
Larry

    
                    public void SaveSettings(int reportid, string reportname)  
        
                    {  
        
                        object[] gridSettings = new object[4];  
        
                        //Save groupBy  
        
                        GridGroupByExpressionCollection groupByExpressions = this.MasterTableView.GroupByExpressions;  
        
                        object[] groupExpressions = new object[groupByExpressions.Count];  
        
                        int count = 0;  
        
                        foreach (GridGroupByExpression expression in groupByExpressions)  
        
                        {  
        
                            groupExpressions[count] = ((IStateManager)expression).SaveViewState();  
        
                            count++;  
        
                        }  
        
                        gridSettings[0] = groupExpressions;  
        
                        //Save sort expressions  
        
                        gridSettings[1] = ((IStateManager)this.MasterTableView.SortExpressions).SaveViewState();  
        
                        //Save columns order and visibility  
        
                        int columnsLength = this.MasterTableView.Columns.Count +  
        
                         this.MasterTableView.AutoGeneratedColumns.Length;  
        
                        string[] columnOrder = new string[columnsLength];  
        
                        bool[] columnVisible = new bool[columnsLength];  
        
                        ArrayList allColumns = new ArrayList(columnsLength);  
        
                        allColumns.AddRange(this.MasterTableView.Columns);  
        
                        allColumns.AddRange(this.MasterTableView.AutoGeneratedColumns);  
        
                        int i = 0;  
        
                        foreach (Telerik.Web.UI.GridColumn column in allColumns)  
        
                        {  
        
                            columnOrder[i] = column.UniqueName;  
        
                            columnVisible[i] = column.Visible;  
        
                            i++;  
        
                        }  
        
                        gridSettings[2] = columnOrder;  
        
                        //Save filter expression  
        
                        gridSettings[3] = (object)this.MasterTableView.FilterExpression;  
        
                        RemoteUser _user = ((RemoteUser)Context.User);  
        
                        SqlHelper.Execute("user_custom_report_create_p" , _user.UserId , reportid , reportname, _user.CurrentCustomerID ,  _user.CurrentPeriod , GridHelper.Serialize(columnOrder, GridHelper.SeralizeType.LOS) ,GridHelper.Serialize(gridSettings[1], GridHelper.SeralizeType.LOS), GridHelper.Serialize(gridSettings[3], GridHelper.SeralizeType.LOS), GridHelper.Serialize(gridSettings[0], GridHelper.SeralizeType.LOS) , GridHelper.Serialize(columnVisible, GridHelper.SeralizeType.LOS));  
        
                    }  
        
                    //this method should be called on PageInit  
        
                    public void LoadSettings(int reportid)  
        
                    {  
        
                        object[] _columns = new object[5];  
        
                        RemoteUser _user = ((RemoteUser)Context.User);  
        
                        // go get the report settings  
        
                        // if we cant find the reportid for this userid, throw an exception  
        
                        DataTable _tbl = SqlHelper.ExecuteDataset("user_custom_report_get_p" , _user.UserId , reportid).Tables[0];  
        
                        if (_tbl.Rows.Count == 0)  
        
                            throw new Exception("The user custom report is not valid + userid: " + _user.UserId.ToString() + " reportid: " + reportid.ToString());  
        
                        //TODO: check security to make sure the user has access to the customerid  
        
                        //if ( _user.Customers.  _tbl.Rows[0]["CustomerID"].ToString()   
        
                        HttpContext.Current.Session["CustomerID"] = _user.CurrentCustomerID = _tbl.Rows[0]["CustomerID"].ToString();  
        
                        HttpContext.Current.Session["BillYYYYMM"] = _user.CurrentPeriod = _tbl.Rows[0]["billyyyymm"].ToString();  
        
                        // Now get the string array of columns and use this.AddColumns  
        
                        this.AddColumns((string[])GridHelper.DeSerialize(_tbl.Rows[0]["columns"].ToString() , GridHelper.SeralizeType.LOS));  
        
                        //Load groupBy  
        
                        this.MasterTableView.GroupByExpressions.Clear();  
        
                        int count = 0;  
        
                        foreach (object obj in ((object[])GridHelper.DeSerialize(_tbl.Rows[0]["groupby"].ToString() , GridHelper.SeralizeType.LOS)))  
        
                        {  
        
                            GridGroupByExpression expression = new GridGroupByExpression();  
        
                            ((IStateManager)expression).LoadViewState(obj);  
        
                            this.MasterTableView.GroupByExpressions.Add(expression);  
        
                            count++;  
        
                        }  
        
                        //Load sort expressions  
        
                        this.MasterTableView.SortExpressions.Clear();  
        
                        ((IStateManager)this.MasterTableView.SortExpressions).LoadViewState((GridHelper.DeSerialize(_tbl.Rows[0]["sort"].ToString(), GridHelper.SeralizeType.LOS)));  
        
                        this.MasterTableView.FilterExpression = (GridHelper.DeSerialize(_tbl.Rows[0]["filter"].ToString() , GridHelper.SeralizeType.LOS)).ToString();  
        
                    }

Telerik Admin

Posted on Jul 10, 2009 (permalink)

Hi Larry,

Indeed, in such a scenario the filter expression will not be displayed. One possible option in this case would be to get a reference to the filter textox and set the value:
http://www.telerik.com/help/aspnet-ajax/grdsettingfiltertextboxdimensions.html

Alternatively, you can use the CurrentFilterFunction/CurrentFilterValue properties for the respective columns, to set these values directly.
I hope these suggestions help.

Regards,
Yavor
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

Reply

Related resourses for "Filter Expression Applied But Does Not Display"

Not answered Filter Expression Applied But Does Not Display

Products

Consulting

Purchase

Support

Community

Company