Gridpanel - Hide store records

  1. #1

    Gridpanel - Hide store records

    Hi guys,

    I would like to request for a little help here.
    How can I hide multiple rows based on an simple array?
    I tried several methods, none of them worked well, I know I have to apply multiple filter for a column... but don't know how.
    It would be nice if I press the button (btnFilterItems), then my Store1 get's filtered for the array items.
    Please check out the example and help me if you have a working solution/tip/info!

    Thanks in advance,

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="multihide.aspx.cs" Inherits="WTTsite3.multihide" %>
    
    <%@ Register Assembly="Coolite.Ext.Web" Namespace="Coolite.Ext.Web" TagPrefix="ext" %>
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Ext.IsAjaxRequest)
            {
                this.Store1.DataSource = this.Data;
                this.Store1.DataBind();
            }
        }
    
        private object[] Data
        {
            get
            {
                return new object[]
                {
                    new object[] { 1,"3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
                    new object[] { 2,"Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
                    new object[] { 3,"Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
                    new object[] { 4,"American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
                    new object[] { 5,"American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
                    new object[] { 6,"AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
                    new object[] { 7,"Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
                    new object[] { 8,"Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
                    new object[] { 9,"Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
                    new object[] { 10,"E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
                    new object[] { 11,"Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
                    new object[] { 12,"General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
                    new object[] { 13,"General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
                    new object[] { 14,"Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
                    new object[] { 15,"Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
                    new object[] { 16,"Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
                    new object[] { 17,"International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
                    new object[] { 18,"Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
                    new object[] { 19,"JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
                    new object[] { 20,"McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
                    new object[] { 21,"Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
                    new object[] { 22,"Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
                    new object[] { 23,"Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
                    new object[] { 24,"The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
                    new object[] { 25,"The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
                    new object[] { 26,"The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
                    new object[] { 27,"United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
                    new object[] { 28,"Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
                    new object[] { 29,"Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
                };
            }
        }
    </script>
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>multihide test</title>
    
        <script type="text/javascript">
            var template = '<span style="color:{0};">{1}</span>';
            // Array of record IDs to hide
            var filterarray = new Array(10, 12, 15, 18, 21, 26);
            
            var change = function(value) {
                return String.format(template, (value > 0) ? "green" : "red", value);
            };
    
            var pctChange = function(value) {
                return String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
    
            //Function to hide the array element rows
            var runFilter = function() {
                var storeLength = Store1.data.length;
                
                //Go through the store items
                for (j = 0; j < storeLength; j++) {
                    
                    //Go through the array items
                    for (i = 0; i < filterarray.length; i++) {
    
                        if (Store1.data.items[j].data.ID == filterarray[i]) {
                                //hide row how?
        
                        }
    
                    }
                }
    
            }
            
        </script>
    
    </head>
    <body>
        <form id="form1" runat="server">
        <ext:ScriptManager ID="scpManagerMain" runat="server">
            <Listeners>
                <DocumentReady Handler="Coolite.AjaxEvent.timeout = 60000;Coolite.AjaxEvent.showFailure = Ext.emptyFn;" />
                <AjaxRequestException Handler="return AjaxRequestExceptionHandler(response, result, el, eventType, action, extraParams, o);" />
            </Listeners>
        </ext:ScriptManager>
        <ext:Store ID="Store1" runat="server">
            <Reader>
                <ext:ArrayReader>
                    <Fields>
                        <ext:RecordField Name="ID" />
                        <ext:RecordField Name="company" />
                        <ext:RecordField Name="price" Type="Float" />
                        <ext:RecordField Name="change" Type="Float" />
                        <ext:RecordField Name="pctChange" Type="Float" />
                        <ext:RecordField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
                    </Fields>
                </ext:ArrayReader>
            </Reader>
        </ext:Store>
        <ext:GridPanel ID="GridPanel1" runat="server" StripeRows="true" Title="Array Grid"
            StoreID="Store1" TrackMouseOver="true" Width="700" Height="400" AutoExpandColumn="company">
            <TopBar>
                <ext:Toolbar ID="tbTest" runat="server">
                    <Items>
                        <ext:Button ID="btnFilterItems" runat="server" Text="FilterItems - Array(10, 12, 15, 18, 21, 26)" Icon="Find">
                            <Listeners>
                                <Click Handler="runFilter();" />
                            </Listeners>
                        </ext:Button>
                        <ext:Button ID="btnResetFilter" runat="server" Text="Reset" Icon="Reload">
                        <Listeners>
                        <Click Handler="#{Store1}.clearFilter();" />
                        </Listeners>
                        </ext:Button>
                    </Items>
                </ext:Toolbar>
            </TopBar>
            <ColumnModel ID="ColumnModel1" runat="server">
                <Columns>
                    <ext:Column ColumnID="Company" Header="Company" DataIndex="company" />
                    <ext:Column Header="Price" DataIndex="price">
                        <Renderer Format="UsMoney" />
                    </ext:Column>
                    <ext:Column ColumnID="Change" Header="Change" DataIndex="change">
                        <Renderer Fn="change" />
                    </ext:Column>
                    <ext:Column Header="Change" DataIndex="pctChange">
                        <Renderer Fn="pctChange" />
                    </ext:Column>
                    <ext:Column Header="Last Updated" DataIndex="lastChange" />
                </Columns>
            </ColumnModel>
            <SelectionModel>
                <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true" />
            </SelectionModel>
        </ext:GridPanel>
        </form>
    </body>
    </html>
  2. #2
    Hi,

    You have to use filterBy javascript method of Store
    filterBy( Function fn, [Object scope] ) : void
    Filter by a function. The specified function will be called for each Record in this Store. If the function returns true the Record is included, otherwise it is filtered out.
    Parameters:
    fn : Function
    The function to be called. It will be passed the following parameters:
    record : Ext.data.Record
    The record to test for filtering. Access field values using Ext.data.Record.get.
    id : Object
    The ID of the Record passed.
    scope : Object
    (optional) The scope (this reference) in which the function is executed. Defaults to this Store.
    Returns:
    void
  3. #3
    Hi Vladsch!

    Thanks very much for your reply, I modified the my sample code, but it filters out only one (ther first) item from my filterarray.
    Would you so kind to help me get this thing going - please.... :)

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="multihide.aspx.cs" Inherits="WTTsite3.multihide" %>
    
    <%@ Register Assembly="Coolite.Ext.Web" Namespace="Coolite.Ext.Web" TagPrefix="ext" %>
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Ext.IsAjaxRequest)
            {
                this.Store1.DataSource = this.Data;
                this.Store1.DataBind();
            }
        }
    
        private object[] Data
        {
            get
            {
                return new object[]
                {
                    new object[] { 1,"3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
                    new object[] { 2,"Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
                    new object[] { 3,"Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
                    new object[] { 4,"American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
                    new object[] { 5,"American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
                    new object[] { 6,"AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
                    new object[] { 7,"Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
                    new object[] { 8,"Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
                    new object[] { 9,"Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
                    new object[] { 10,"E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
                    new object[] { 11,"Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
                    new object[] { 12,"General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
                    new object[] { 13,"General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
                    new object[] { 14,"Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
                    new object[] { 15,"Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
                    new object[] { 16,"Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
                    new object[] { 17,"International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
                    new object[] { 18,"Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
                    new object[] { 19,"JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
                    new object[] { 20,"McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
                    new object[] { 21,"Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
                    new object[] { 22,"Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
                    new object[] { 23,"Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
                    new object[] { 24,"The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
                    new object[] { 25,"The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
                    new object[] { 26,"The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
                    new object[] { 27,"United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
                    new object[] { 28,"Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
                    new object[] { 29,"Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
                };
            }
        }
    </script>
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>multihide test</title>
    
        <script type="text/javascript">
            var template = '<span style="color:{0};">{1}</span>';
            // Array of record IDs to hide
            var filterarray = new Array(10, 12, 15, 18, 21, 26);
    
            var change = function(value) {
                return String.format(template, (value > 0) ? "green" : "red", value);
            };
    
            var pctChange = function(value) {
                return String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
           
            
            //Function to hide the array element rows
            var runFilter = function() {
                var storeLength = Store1.data.length;
                
                // This is where I filter for each records - only the first filterarray pulled out
                Store1.filterBy(function(record) {
    
                    for (i=0; i < filterarray.length; i++ ) {
    
                        if (filterarray[i] != record.data.ID) {
    
                            return true;
                        } else {
    
                            return false;
                        }
    
                    }
                });
    
                lblCount.setText(Store1.data.length);
    
            }
    
            
        </script>
    
    </head>
    <body>
        <form id="form1" runat="server">
        <ext:ScriptManager ID="scpManagerMain" runat="server">
            <Listeners>
                <DocumentReady Handler="Coolite.AjaxEvent.timeout = 60000;Coolite.AjaxEvent.showFailure = Ext.emptyFn;" />
                <AjaxRequestException Handler="return AjaxRequestExceptionHandler(response, result, el, eventType, action, extraParams, o);" />
            </Listeners>
        </ext:ScriptManager>
        <ext:Store ID="Store1" runat="server">
            <Reader>
                <ext:ArrayReader>
                    <Fields>
                        <ext:RecordField Name="ID" />
                        <ext:RecordField Name="company" />
                        <ext:RecordField Name="price" Type="Float" />
                        <ext:RecordField Name="change" Type="Float" />
                        <ext:RecordField Name="pctChange" Type="Float" />
                        <ext:RecordField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
                    </Fields>
                </ext:ArrayReader>
            </Reader>
            <Listeners>
            <Load Handler="#{lblCount}.setText(#{Store1}.data.length);" />
            </Listeners>
        </ext:Store>
        <ext:GridPanel ID="GridPanel1" runat="server" StripeRows="true" Title="Array Grid"
            StoreID="Store1" TrackMouseOver="true" Width="700" Height="400" AutoExpandColumn="company">
            <TopBar>
                <ext:Toolbar ID="tbTest" runat="server">
                    <Items>
                        <ext:Button ID="btnFilterItems" runat="server" Text="FilterItems - Array(10, 12, 15, 18, 21, 26)"
                            Icon="Find">
                            <Listeners>
                                <Click Handler="runFilter();" />
                            </Listeners>
                        </ext:Button>
                        <ext:Button ID="btnResetFilter" runat="server" Text="Reset" Icon="Reload">
                            <Listeners>
                                <Click Handler="#{lblCount}.setText(#{Store1}.data.length);#{Store1}.clearFilter();" />
                            </Listeners>
                        </ext:Button>
                        <ext:Label ID="lblCount" runat="server" Text="Records" Value=""></ext:Label>
                    </Items>
                </ext:Toolbar>
            </TopBar>
            <ColumnModel ID="ColumnModel1" runat="server">
                <Columns>
                    <ext:Column ColumnID="Company" Header="Company" DataIndex="company" />
                    <ext:Column Header="Price" DataIndex="price">
                        <Renderer Format="UsMoney" />
                    </ext:Column>
                    <ext:Column ColumnID="Change" Header="Change" DataIndex="change">
                        <Renderer Fn="change" />
                    </ext:Column>
                    <ext:Column Header="Change" DataIndex="pctChange">
                        <Renderer Fn="pctChange" />
                    </ext:Column>
                    <ext:Column Header="Last Updated" DataIndex="lastChange" />
                </Columns>
            </ColumnModel>
            <SelectionModel>
                <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true" />
            </SelectionModel>
        </ext:GridPanel>
        </form>
    </body>
    </html>
    Last edited by quasimidi; Oct 11, 2010 at 3:00 PM.
  4. #4
    Hi,

    Store1.filterBy(function(record) { 
        for (i=0; i < filterarray.length; i++ ) {
              if (filterarray[i] == record.data.ID) {
                      return false;
              } 
        }
        return true;
    });
  5. #5
    Quote Originally Posted by vladimir View Post
    Hi,

    Store1.filterBy(function(record) { 
        for (i=0; i < filterarray.length; i++ ) {
              if (filterarray[i] == record.data.ID) {
                      return false;
              } 
        }
        return true;
    });
    Hi Vladsch,

    Thanks so much for your help and for the support for us!

Similar Threads

  1. Replies: 0
    Last Post: Mar 11, 2012, 9:20 AM
  2. Replies: 5
    Last Post: Jun 14, 2011, 11:47 AM
  3. Replies: 1
    Last Post: Nov 01, 2010, 9:00 PM
  4. [CLOSED] Store + GridPanel with over 500 records
    By Zarzand in forum 1.x Legacy Premium Help
    Replies: 2
    Last Post: Mar 25, 2009, 10:26 AM
  5. GridPanel Store and Deleting Records
    By Timothy in forum 1.x Legacy Premium Help
    Replies: 8
    Last Post: Sep 07, 2008, 12:18 PM

Tags for this Thread

Posting Permissions