Product - Sigma Grid 2.2 - Sample

Combination filters

This sample demonstrates how to apply several filters to one grid.

• Input your criterias for employee name in the first line.
• Input your criterias for bill of 2005 in the second line.
• Press button titled filter to see what happened.
• Press button titled Unfilter to restore and show all the records.

Employee Name = != < > <= >= like startWith endWith
Bill 2005 Bill 2006 Bill 2007 Bill 2008 = != < > <= >= like startWith endWith

function doFilter() { var filterInfo=[ { fieldName : Sigma.Util.getValue("f_fieldName1"), logic : Sigma.Util.getValue("f_logic1"), value : Sigma.Util.getValue("f_value1") }, { fieldName : Sigma.Util.getValue("f_fieldName12"), logic : Sigma.Util.getValue("f_logic12"), value : Sigma.Util.getValue("f_value12") } ] var grid=Sigma.$grid("myGrid1"); var rowNOs=grid.filterGrid(filterInfo); } function doUnfilter(){ var grid=Sigma.$grid("myGrid1"); var rowNOs=grid.unfilterGrid(); }

Related Links

Demos List - Dynamic search