R – Filter columns in flex datagrid using CheckBox

apache-flexcomboboxdatagridfilter

I have a flex datagrid with 4 columns.I have a comboBox with 4 checkboxes,containing the column names of datagrid as its label.I want the datagrid to display only those columns which are selected in combobox.Can anyone tell me how this filtering of columns in datagrid can be done?

Thanks in advance.

Best Answer

You can manipulate the columns attached to the data grid using the .columns property. Bear in mind that this method is a getter and returns you a copy of the list of columns on the datagrid, so if you manipulate its contents you have to apply those changes back to the data grid using the equivalent setter, e.g.

<mx:DataGrid id="dg" />

in ActionScript code

var columns:Array = dg.column;
columns.push(new DataGridColumn("hello"));
dg.columns = columns;

In your case you could hold your master list of columns in a separate array and push them onto the data grid as the user checks and un-checks them from the list in your comboBox.

Alternatively you can iterate through the column list looking for the ones which are checked in your comboBox and set their .visible property accordingly.

HTH

Related Solutions

Regex – Flex : Filter a datagrid using a combobox value that is contained in a datafield

Something like this should work:

 public function filter(item:Object):Boolean{
        var result:Boolean=false;
        if (item.name.toUpperCase().indexOf(cbo.selectedLabel.toUpperCase()) >= 0)
             result=true;
        return result;
 }

This filter function will search the name attribute(or whatever you want to filter on) of the object passed in with the combobox's currently selected label and if it finds that value it will return true. So if it finds the word "New" anywhere in the string it will show up in the datagrid. IE: "New Person", "New User" will both show up once filtered.

Hope this is what you are looking for.

R – Filter a dataGrid with a comboBox in flex

You appear to be searching on the revType column, rather than the Priority column.

It may be worth finding a way to reduce the amount of duplicated code in your app to help avoid bugs like this. For example, your list of fields could look like this:

[Bindable]
var criteriaDP1:ArrayCollection = new ArrayCollection([{label:"Review ID", value:"RevID"},
                                                       {label:"Defect Id", value:"DefID"}]);

Setting it up like that would let you use the value field as an index on your dataProvider, like this:

public function search_clickHandler():void
{
    defectList.filterFunction = function(item:Object):Boolean
    {
        var gridValue:String = item[searchCriteria.selectedItem.value].toString().toLowerCase();
        var searchValue:String = search.text.toLowerCase(); 
        if(gridValue.search(searchValue) != -1)
        {
            return true;                        
        }
        return false;
    };
    defectList.refresh();
}

Best Answer

Related Solutions

Regex – Flex : Filter a datagrid using a combobox value that is contained in a datafield

R – Filter a dataGrid with a comboBox in flex

Related Topic