[CLOSED] Grid Column filter

[majestic]

Hi,

I have a requirement to filter the multiple records listed in the grid. Current filter option allow us to filter only one value. We would like to filter multiple values .

Say for instance if i enter AUD in the filter column it brings only AUD. As per my requiremnt if i enter AUD, INR it should return the grid rows satisfying these 2 criteria.


Youe help is greatly appreciated.

Thanks
Ram

[Vladimir]

Hi,

Which filter functionality do you use? GridFilters plugin or 'filter' method of the store?

[majestic]

Hi,

My current requirement is Grid filter plugin.

My requiremtn is to search multiple values


(We have actually used both the type of filters).

Hi,

Which filter functionality do you use? GridFilters plugin or 'filter' method of the store?

Thanks
Dharini

[Daniil]

Hi,

New GridFilters functionality was added to the toolkit recently (e.g. ValidateRecord). Seems it can help to achieve your requirement.

Here is an example.
http://forums.ext.net/showthread.php...ll=1#post43525

[majestic]

Hi,

As per your reply we downloaded the coolite kit version 1.0 from the link

http://svn.ext.net/premium/branches/

We wonder whether this is the right link as, when we tried running the sample given in the link
http://forums.ext.net/showthread.php...ll=1#post43525
(in the downloaded source) throws errror.


This is the error we have received

Type 'Ext.Net.StringFilter' does not have a public property named 'ValidateRecord'.

Could you please help on this?

Your quick reply is greatly appreciated

Thanks
Ram

[Daniil]

As per your reply we downloaded the coolite kit version 1.0 from the link

http://svn.ext.net/premium/branches/

The SVN location was moved. Please update from the following link
http://svn.ext.net/premium/trunk

We wonder whether this is the right link as, when we tried running the sample given in the link http://forums.ext.net/showthread.php...ll=1#post43525 (in the downloaded source) throws errror.

The link is broken. Could you edit?

[majestic]

Hi,

My requirement is different as i indicated earlier..

We would like to have the grid filter work as in the attached screen shot.

The filter should allow multiple values separated by the separator..

The SVN location was moved. Please update from the following link
http://svn.ext.net/premium/trunk




The link is broken. Could you edit?

[Daniil]

Sure, there is just an example how to use ValidateRecord.

Within ValidateRecord you have filter's value (you have to split(",") this value) and a current record.

Just return true if a record's data has a value from filter's value.

[majestic]

Hi,

I used the following script to implement multiple value search in the grid filter

<script type="text/javascript"> 
        var myValidateRecord = function (record) 
        {             
        debugger;
            var filterValue = this.getValue(); 
            if (filterValue.length == 0) { 
                return true; 
            } 
            if (!this.filteredRecords) { 
                this.filteredRecords = Store2.query('name', filterValue.split(","), true, false); 
            } 
            var code = record.get(this.dataIndex), 
                index = this.filteredRecords.findIndexBy( 
                function(record) { 
                    return record && (code == record.get('code')); 
                } 
            ); 
            return index != -1; 
        } 
    </script>

this.filteredRecords = Store2.query('name', filterValue.split(","), true, false);

It does not return the results after splitting..
Could you please tell me where i went wrong in the above code?

Thanks
Ram

Sure, there is just an example how to use ValidateRecord.

Within ValidateRecord you have filter's value (you have to split(",") this value) and a current record.

Just return true if a record's data has a value from filter's value.

[Daniil]

Please investigate the following example.

Example

<%@ Page Language="C#" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>

<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {
            Store store = this.GridPanel1.GetStore();
            store.DataSource = new object[]
            {
                new object[] {"test1"},
                new object[] {"test2"},
                new object[] {"test3"},
                new object[] {"test4"},
                new object[] {"test5"},
                new object[] {"test6"},
                new object[] {"test7"},
                new object[] {"test8"},
                new object[] {"test9"}
            };
            store.DataBind();
        }
    }
</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>Ext.Net Example</title>

    <script type="text/javascript">
        var myValidateRecord = function(filter, record) {
            var filterValue = filter.getValue();
            if (filterValue.length == 0) {
                return true;
            }
            var values = filterValue.split(",");
            for (var i = 0; i < values.length; i++) {
                if (record.get(filter.dataIndex) === values[i].trim()) {
                    return true;    
                }
            }
            return false;
        }
    </script>
</head>
<body>
    <form runat="server">
    <ext:ResourceManager runat="server" />
    <ext:GridPanel ID="GridPanel1" runat="server" AutoHeight="true">
        <Store>
            <ext:Store runat="server">
                <Reader>
                    <ext:ArrayReader>
                        <Fields>
                            <ext:RecordField Name="test" />
                        </Fields>
                    </ext:ArrayReader>
                </Reader>
            </ext:Store>
        </Store>
        <ColumnModel runat="server">
            <Columns>
                <ext:Column Header="Test" DataIndex="test" />
            </Columns>
        </ColumnModel>
        <Plugins>
            <ext:GridFilters runat="server">
                <Filters>
                    <ext:StringFilter DataIndex="test">
                        <ValidateRecord Handler="return myValidateRecord(this, record);" />
                    </ext:StringFilter>
                </Filters>
            </ext:GridFilters>
        </Plugins>
    </ext:GridPanel>
    </form>
</body>
</html>