ui.igGridFiltering

ui.igGridFiltering_image

Both the igGrid and igHierarchicalGrid controls feature row filtering which allows users to restrict grid rows to only the data that meets a given criteria. Filtering options include numeric, string and date filters. Further information regarding the classes, options, events, methods and themes of this API are available under the associated tabs above.

The following code snippet demonstrates how to initialize the igGrid control.

Click here for more information on how to get started using this API. For details on how to reference the required scripts and themes for the igGrid control read, Using JavaScript Resources in Ignite UI and Styling and Theming Ignite UI.

Code Sample

  
        <!doctype html>
        <html>
        <head>
            <!-- Infragistics Combined CSS -->
            <link href="css/themes/infragistics/infragistics.theme.css" rel="stylesheet" type="text/css" />
            <link href="css/structure/infragistics.css" rel="stylesheet" type="text/css" />
            <!-- jQuery Core -->
            <script src="js/jquery.js" type="text/javascript"></script>
            <!-- jQuery UI -->
            <script src="js/jquery-ui.js" type="text/javascript"></script>
            <!-- Infragistics Combined Scripts -->
            <script src="js/infragistics.core.js" type="text/javascript"></script>
                  <script src="js/infragistics.lob.js" type="text/javascript"></script>
            <script type="text/javascript">
                var products = [
                    { "ProductID": 1, "Name": "Adjustable Race", "ProductNumber": "AR-5381" },
                    { "ProductID": 2, "Name": "Bearing Ball", "ProductNumber": "BA-8327" },
                    { "ProductID": 3, "Name": "BB Ball Bearing", "ProductNumber": "BE-2349" },
                    { "ProductID": 4, "Name": "Headset Ball Bearings", "ProductNumber": "BE-2908" },
                    { "ProductID": 316, "Name": "Blade", "ProductNumber": "BL-2036" },
                    { "ProductID": 317, "Name": "LL Crankarm", "ProductNumber": "CA-5965" },
                    { "ProductID": 318, "Name": "ML Crankarm", "ProductNumber": "CA-6738" },
                    { "ProductID": 319, "Name": "HL Crankarm", "ProductNumber": "CA-7457" },
                    { "ProductID": 320, "Name": "Chainring Bolts", "ProductNumber": "CB-2903" }
                ];

                $(function () {
                    $("#gridFiltering").igGrid({
                        columns: [
                            { headerText: "Product ID", key: "ProductID", dataType: "number" },
                            { headerText: "Product Name", key: "Name", dataType: "string" },
                            { headerText: "Product Number", key: "ProductNumber", dataType: "string" }
                        ],
                        features:[
                            {
                                name: "Filtering"
                            }
                        ],
                        width: "500px",
                        dataSource: products
                    });
                });
            </script>
        </head>
        <body>
            <div id="gridFiltering"></div>
        </body>
        </html>  
    

Related Samples

Related Topics

Dependencies

jquery-1.9.1.js
jquery.ui.core.js
jquery.ui.widget.js
jquery.ui.mouse.js
jquery.ui.draggable.js
jquery.ui.resizable.js
infragistics.ui.grid.framework.js
infragistics.ui.grid.shared.js
infragistics.ui.grid.featurechooser.js
infragistics.ui.editors.js
infragistics.ui.shared.js
infragistics.datasource.js
infragistics.templating.js
infragistics.util.js

Inherits

  • advancedModeEditorsVisible

    Type:
    bool
    Default:
    false

    Defines whether to show/hide editors in advanced mode. If false, no editors will be rendered in the advanced mode.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        advancedModeEditorsVisible : true
                    }
                ]
            });
    
            //Get
            var editorsVisible = $(".selector").igGridFiltering("option", "advancedModeEditorsVisible");
    
            //Set
            $(".selector").igGridFiltering("option", "advancedModeEditorsVisible", true);
            
  • advancedModeHeaderButtonLocation

    Type:
    enumeration
    Default:
    left

    location of the advanced filtering button when advancedModeEditorsVisible is false (i.e. when the button is rendered in the header).

    Members

    • left
    • Type:string
    • right
    • Type:string

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        advancedModeHeaderButtonLocation : "right"
                    }
                ]
            });
    
            //Get
            var location = $(".selector").igGridFiltering("option", "advancedModeHeaderButtonLocation");
    
            //Set
            $(".selector").igGridFiltering("option", "advancedModeHeaderButtonLocation", "right");
            
  • caseSensitive

    Type:
    bool
    Default:
    false

    Enables or disables the filtering case sensitivity. Works only for local filtering.If true, it enables filtering case sensitivity. If false, it disables filtering case sensitivity.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        caseSensitive : true
                    }
                ]
            });
            
            //Get
            var caseSensitive = $(".selector").igGridFiltering("option", "caseSensitive");
    
            //Set
            $(".selector").igGridFiltering("option", "caseSensitive", true);
          
  • columnSettings

    Type:
    array
    Default:
    []
    Elements Type:
    object

    A list of column settings that specifies custom filtering options on a per column basis.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        columnSettings : [
                            {
                                columnKey: "ProductDescription", 
                                condition: "endsWith" 
                            }
                        ]
                    }
                ]
            });
    
            //Get
            var colSettings = $(".selector").igGridFiltering("option", "columnSettings");
            
    • allowFiltering

      Type:
      bool
      Default:
      true

      Enables/disables filtering for the column.

      Code Sample

        
                  //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [
                                  {
                                      columnKey: "ProductDescription", 
                                      allowFiltering: false
                                  }
                              ]
                          }
                      ]
                  });
       
                  //Get
                  var colSettings = $(".selector").igGridFiltering("option", "columnSettings");
                
    • columnIndex

      Type:
      number
      Default:
      null

      Specifies column index. Either key or index must be set in every column setting.

      Code Sample

        
                  //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [
                                  {
                                      columnIndex: 0, 
                                      allowFiltering: false
                                  }
                              ]
                          }
                      ]
                  });
       
                  //Get
                  var colSettings = $(".selector").igGridFiltering("option", "columnSettings");
                
    • columnKey

      Type:
      string
      Default:
      null

      Specifies column key. Either key or index must be set in every column setting.

      Code Sample

        
                  //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [
                                  {
                                      columnKey: "ProductDescription", 
                                      allowFiltering: false
                                  }
                              ]
                          }
                      ]
                  });
       
                  //Get
                  var colSettings = $(".selector").igGridFiltering("option", "columnSettings"); 
                
    • condition

      Type:
      enumeration
      Default:
      null

      default filtering condition for the column.

      Members

      • empty
      • Type:string
      • notEmpty
      • Type:string
      • null
      • Type:string
      • notNull
      • Type:string
      • equals
      • Type:string
      • doesNotEqual
      • Type:string
      • startsWith
      • Type:string
      • contains
      • Type:string
      • doesNotContain
      • Type:string
      • endsWith
      • Type:string
      • greaterThan
      • Type:string
      • lessThan
      • Type:string
      • greaterThanOrEqualTo
      • Type:string
      • lessThanOrEqualTo
      • Type:string
      • true
      • Type:bool
      • false
      • Type:bool
      • on
      • Type:string
      • notOn
      • Type:string
      • before
      • Type:string
      • after
      • Type:string
      • today
      • Type:string
      • yesterday
      • Type:string
      • thisMonth
      • Type:string
      • lastMonth
      • Type:string
      • nextMonth
      • Type:string
      • thisYear
      • Type:string
      • nextYear
      • Type:string
      • lastYear
      • Type:string

      Code Sample

        
                  //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [
                                  {
                                      columnKey: "ProductDescription", 
                                      condition: "startsWith"
                                  }
                              ]
                          }
                      ]
                  });
       
                  //Get
                  var colSettings = $(".selector").igGridFiltering("option", "columnSettings");
                
    • conditionList

      Type:
      array
      Default:
      []
      Elements Type:
      object

      An array of strings that determine which conditions to display for this column.

      Code Sample

       
                //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [{
                                columnKey: "ProductNumber",
                                conditionList: ["startsWith", "contains"]
                              }]
                          }
                      ]
                  });
                  
                  //Get
                  var conditionList = $(".selector").igGridFiltering("option", "columnSettings")[2].conditionList;
                
    • customConditions

      Type:
      object
      Default:
      null

      An object used to specify custom filtering conditions as objects for this column
      labelText The label as it will appear in the column's condition dropdown
      expressionText The text to display in the editor when requireExpr is false
      requireExpr If this condition requires the user to input a filtering expression
      filterImgIcon Class applied to the dropdown item when in simple mode
      filterFunc The custom comparing filter function. Signature: function (value, expression, dataType, ignoreCase, preciseDateFormat).

      Code Sample

       
                //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [{
                                columnKey: "ProductNumber",
                                customConditions: [
                                      BE:{
                                          labelText: "BE",
                                          expressionText: "BE-####",
                                          requireExpr: false,
                                          filterFunc: filterProductNumber
                                      },
                                      CA:{
                                          labelText: "CA",
                                          expressionText: "CA-####",
                                          requireExpr: false,
                                          filterFunc: filterProductNumber1
                                      }
                                  ]
                               }]
                          }
                      ]
                  });
                  
                  function filterProductNumber(value, expression, dataType, ignoreCase, preciseDateFormat) {
                  return value.startsWith("BE");
                  }
              
                      function filterProductNumber1(value, expression, dataType, ignoreCase, preciseDateFormat) {
                      return value.startsWith("CA");
                  }
                  //Get
                  var customConditions = $(".selector").igGridFiltering("option", "columnSettings")[2].customConditions;
                  
                
    • defaultExpressions

      Type:
      object
      Default:
      []

      Initial filtering expressions - if set they will be applied on initialization.

      Code Sample

       
                  //Initialize
                  $(".selector").igGrid({
                      features: [
                          {
                              name : "Filtering",
                              columnSettings : [
                                  {
                                      columnKey: "Name", 
                                      defaultExpressions: [
                                          { expr: "B", cond: "startsWith" }
                                      ]
                                  }
                              ]
                          }
                      ]
                  });
       
                  //Get
                  var defaultExpressions = $(".selector").igGridFiltering("option", "columnSettings")[0].defaultExpressions;
                          
  • featureChooserText

    Type:
    string
    Default:
    ""

    Feature chooser text when filter is shown and filter mode is simple.

    Code Sample

             
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        featureChooserText : "Hide Filter"
                    }
                ]
            });
    
            //Get
            var text = $(".selector").igGridFiltering("option", "featureChooserText");
    
            //Set
            $(".selector").igGridFiltering("option", "featureChooserText", "Hide Filter"); 
        
  • featureChooserTextAdvancedFilter

    Type:
    string
    Default:
    ""

    Feature chooser text when filter mode is advanced.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        featureChooserTextAdvancedFilter : "Advanced Filter"
                    }
                ]
            });
    
            //Get
            var text = $(".selector").igGridFiltering("option", "featureChooserTextAdvancedFilter");
    
            //Set
            $(".selector").igGridFiltering("option", "featureChooserTextAdvancedFilter", "Advanced Filter");
            
  • featureChooserTextHide

    Type:
    string
    Default:
    ""

    Feature chooser text when filter is hidden and filter mode is simple.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        featureChooserTextHide : "Show Filter"
                    }
                ]
            });
    
            //Get
            var text = $(".selector").igGridFiltering("option", "featureChooserTextHide");
    
            //Set
            $(".selector").igGridFiltering("option", "featureChooserTextHide", "Show Filter");
          
  • filterButtonLocation

    Type:
    enumeration
    Default:
    left

    the filtering button for filter dropdowns can be rendered either on the left of the filter editor or on the right.

    Members

    • left
    • Type:string
    • right
    • Type:string

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterButtonLocation : "right"
                    }
                ]
            });
    
            //Get
            var location = $(".selector").igGridFiltering("option", "filterButtonLocation");
    
            //Set
            $(".selector").igGridFiltering("option", "filterButtonLocation", "right");
            
  • filterDelay

    Type:
    number
    Default:
    500

    Time in milliseconds for which widget will wait for keystrokes before sending filtering request.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDelay : 1000
                    }
                ]
            });
    
            //Get
            var delay = $(".selector").igGridFiltering("option", "filterDelay");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDelay", 1000);
            
  • filterDialogAddButtonWidth

    Type:
    enumeration
    Default:
    100

    add button width - in the advanced filter dialog.

    Members

      • string
      • The dialog Add button width in pixels (100px).
      • number
      • The dialog Add button width as a number (100).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogAddButtonWidth : 75
                    }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDialogAddButtonWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogAddButtonWidth", 75);
            
  • filterDialogAddConditionDropDownTemplate

    Type:
    string
    Default:
    null

    Custom template for options in dropdown in add condition area in the filter dialog.
    The default template is "<option value='${value}'>${text}</option>".

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogAddConditionDropDownTemplate: "<option value='${text}'>${text}</option>"
                    }
                ]
            });
     
            //Get
            var dropDownTemplate = $(".selector").igGridFiltering("option", "filterDialogAddConditionDropDownTemplate");
     
            //Set
            $(".selector").igGridFiltering("option", "filterDialogAddConditionDropDownTemplate", "<option value='${text}'>${text}</option>");
          
  • filterDialogAddConditionTemplate

    Type:
    string
    Default:
    null

    Custom template for add condition area in the filter dialog.
    The default template is "<div><span>${label1}</span><div><select></select></div><span>${label2}</span></div>".

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogAddConditionTemplate: "<div><div><select></select></div><span>${label1}</span><span>${label2}</span></div>"
                    }
                ]
            });
     
            //Get
            var addConditionTemplate = $(".selector").igGridFiltering("option", "filterDialogAddConditionTemplate");
     
            //Set
            $(".selector").igGridFiltering("option", "filterDialogAddConditionTemplate", "<div><div><select></select></div><span>${label1}</span><span>${label2}</span></div>");
          
  • filterDialogColumnDropDownDefaultWidth

    Type:
    enumeration
    Default:
    null

    Width of the column chooser dropdowns in the advanced filter dialog.

    Members

      • string
      • The column chooser dropdowns width in pixels (80px).
      • number
      • The column chooser dropdowns width as a number (80).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogColumnDropDownDefaultWidth : 100
                  }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDialogColumnDropDownDefaultWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogColumnDropDownDefaultWidth", 100);
            
  • filterDialogContainment

    Type:
    string
    Default:
    "owner"

    Controls containment behavior.
    owner The filter dialog will be draggable only in the grid area
    window The filter dialog will be draggable in the whole window area.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogContainment : "window"
                  }
                ]
            });
    
            //Get
            var filterDialogContainment = $(".selector").igGridFiltering("option", "filterDialogContainment");
                
  • filterDialogExprInputDefaultWidth

    Type:
    enumeration
    Default:
    130

    width of the filtering expression input boxes in the advanced filter dialog.

    Members

      • string
      • The filtering expression input boxes width in pixels (80px).
      • number
      • The filtering expression input boxes width as a number (80).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogExprInputDefaultWidth : 100
                  }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDialogExprInputDefaultWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogExprInputDefaultWidth", 100);
            
  • filterDialogFilterConditionTemplate

    Type:
    string
    Default:
    null

    Custom template for options in condition list in filter dialog
    The default template is "<option value='${condition}'>${text}</option>".

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogFilterConditionTemplate: "<option value='${conditionName}'>${conditionLabel}</option>"
                    }
                ]
            });
     
            //Get
            var filterConditionTemplate = $(".selector").igGridFiltering("option", "filterDialogFilterConditionTemplate");
     
            //Set
            $(".selector").igGridFiltering("option", "filterDialogFilterConditionTemplate", "<option value='${conditionName}'>${conditionLabel}</option>");
          
  • filterDialogFilterDropDownDefaultWidth

    Type:
    enumeration
    Default:
    80

    Width of the filtering condition dropdowns in the advanced filter dialog.

    Members

      • string
      • The filtering condition dropdowns width in pixels (80px).
      • number
      • The filtering condition dropdowns width as a number (80).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogFilterDropDownDefaultWidth : 100
                    }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDialogFilterDropDownDefaultWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogFilterDropDownDefaultWidth", 100);
            
  • filterDialogFilterTemplate

    Type:
    string
    Default:
    null

    Custom template for filter dialog.
    Each DOM element which is used for selecting filter conditions/columns/filter expressions has "data-*" attribute.
    E.g.: DOM element used for selecting column has attribute "data-af-col", for selecting filter condition - "data-af-cond", for filter expression- "data-af-expr".
    NOTE: The template is supported only with <tr />.
    The default template is "<tr data-af-row><td><input data-af-col/></td><td><select data-af-cond></select></td><td><input data-af-expr /> </td><td><span data-af-rmv></span></td></tr>".

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogFilterTemplate: "<tr><td>Choose column<input/></td><td>Condition<select></select></td><td>Search value<input /> </td><td><span></span></td></tr>"
                    }
                ]
            });
     
            //Get
            var dialogFilterTemplate = $(".selector").igGridFiltering("option", "filterDialogFilterTemplate");
     
            //Set
            $(".selector").igGridFiltering("option", "filterDialogFilterTemplate", "<tr><td>Choose column<input/></td><td>Condition<select></select></td><td>Search value<input /> </td><td><span></span></td></tr>");
          
  • filterDialogHeight

    Type:
    enumeration
    Default:
    ""

    default filter dialog height (used for Advanced filtering).

    Members

      • string
      • The dialog window height in pixels (350px).
      • number
      • The dialog window height as a number (350).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogHeight : 30
                    }
                ]
            });
    
            //Get
            var height = $(".selector").igGridFiltering("option", "filterDialogHeight");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogHeight", 30);
            
  • filterDialogMaxFilterCount

    Type:
    number
    Default:
    5

    Maximum number of filter rows in the advanced filtering dialog. if this number is exceeded, an error message will be rendered.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogMaxFilterCount : 3
                    }
                ]
            });
    
            //Get
            var count = $(".selector").igGridFiltering("option", "filterDialogMaxFilterCount");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogMaxFilterCount", 3);
            
  • filterDialogOkCancelButtonWidth

    Type:
    enumeration
    Default:
    120

    Width of the Ok and Cancel buttons in the advanced filtering dialogs.

    Members

      • string
      • The advanced filter dialog Ok and Cancel buttons width in pixels (120px).
      • number
      • The advanced filter dialog Ok and Cancel buttons width as a number (120).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogOkCancelButtonWidth : 120
                    }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDialogOkCancelButtonWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogOkCancelButtonWidth", 120);
            
  • filterDialogWidth

    Type:
    enumeration
    Default:
    430

    default filter dialog width (used for Advanced filtering).

    Members

      • string
      • The dialog window width in pixels (370px).
      • number
      • The dialog window width as a number (370).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogWidth : 500
                    }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDialogWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDialogWidth", 500);
            
  • filterDropDownAnimationDuration

    Type:
    number
    Default:
    500

    Animation duration in milliseconds for the filter dropdown animations.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDropDownAnimationDuration : 300
                    }
                ]
            });
    
            //Get
            var duration = $(".selector").igGridFiltering("option", "filterDropDownAnimationDuration");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDropDownAnimationDuration", 300);      
            
  • filterDropDownAnimations

    Type:
    enumeration
    Default:
    linear

    type of animations for the column filter dropdowns.

    Members

    • linear
    • Type:string
    • none
    • Type:string

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDropDownAnimations : "none"
                    }
                ]
            });
    
            //Get
            var animation = $(".selector").igGridFiltering("option", "filterDropDownAnimations");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDropDownAnimations", "none");
            
  • filterDropDownHeight

    Type:
    object
    Default:
    0

    Height of the column filter dropdowns
    string The height of the column filter dropdowns in pixels (0px).
    number The height of the column filter dropdowns as a number (0).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDropDownHeight : 30
                    }
                ]
            });
    
            //Get
            var height = $(".selector").igGridFiltering("option", "filterDropDownHeight");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDropDownHeight", 30);
            
  • filterDropDownItemIcons

    Type:
    enumeration
    Default:
    true

    Enable/disable filter icons visibility.

    Members

    • true
    • Type:bool
    • all predefined filters in the filter dropdowns will have icons rendered in front of the text.
    • false
    • Type:bool

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDropDownItemIcons : false
                    }
                ]
            });
            
            //Get
            var showIcons = $(".selector").igGridFiltering("option", "filterDropDownItemIcons");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDropDownItemIcons", false);
            
  • filterDropDownWidth

    Type:
    enumeration
    Default:
    0

    width of the column filter dropdowns.

    Members

      • string
      • The width in pixels (0px).
      • number
      • The width as a number (0).

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDropDownWidth : 100
                    }
                ]
            });
    
            //Get
            var width = $(".selector").igGridFiltering("option", "filterDropDownWidth");
    
            //Set
            $(".selector").igGridFiltering("option", "filterDropDownWidth", 100);
            
  • filterExprUrlKey

    Type:
    string
    Default:
    null

    URL key name that specifies how the filtering expressions will be encoded for remote requests, e.g. &filter('col') = startsWith. Default is OData.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterExprUrlKey : "filter"
                    }
                ]
            });
    
            //Get
            var key = $(".selector").igGridFiltering("option", "filterExprUrlKey");
    
            //Set
            $(".selector").igGridFiltering("option", "filterExprUrlKey", "filter");
            
  • filterSummaryAlwaysVisible

    Type:
    bool
    Default:
    true

    Enable/disable footer visibility with summary info about the filter.
    When false, the filter summary row (in the footer) will only be visible when paging is enabled (or some other feature that renders a footer).
    When true, the filter summary row will only be visible when a filter is applied i.e. it's not visible by default.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterSummaryAlwaysVisible : false
                    }
                ]
            });
            
            //Get
            var showSummary = $(".selector").igGridFiltering("option", "filterSummaryAlwaysVisible");
    
            //Set
            $(".selector").igGridFiltering("option", "filterSummaryAlwaysVisible", false);
            
  • filterSummaryTemplate

    Type:
    string
    Default:
    ""

    Summary template that will appear in the bottom left corner of the footer. Has the format '${matches} matching records'.

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterSummaryTemplate: "${matches} products found"
                    }
                ]
            });
     
            //Get
            var summaryTemplate = $(".selector").igGridFiltering("option", "filterSummaryTemplate");
     
            //Set
            $(".selector").igGridFiltering("option", "filterSummaryTemplate", "${matches} products found");
          
  • inherit

    Type:
    bool
    Default:
    false

    Enables/disables feature inheritance for the child layouts. NOTE: It only applies for igHierarchicalGrid.

  • labels

    Type:
    object
    Default:
    {}

    A list of configurable and localized labels that are used for the predefined filtering conditions in the filter dropdowns.

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        labels: {
                            advancedButtonLabel: "Advanced",
                            after: "After",
                            before: "Before",
                            clear: "Clear Filter",
                            contains: "Contains"
                            //...
                        }
                    }
                ]
            });
     
            //Get
            var filteringLabels = $(".selector").igGridFiltering("option", "labels");
     
          
    • advancedButtonLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              advancedButtonLabel: "Advanced"
                          }
                      }
                  ]
              });
    • after

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              after: "after"
                          }
                      }
                  ]
              });
    • before

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              before: "before"
                          }
                      }
                  ]
              });
    • clear

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              clear: "clear filter"
                          }
                      }
                  ]
              });
    • contains

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              contains: "contains"
                          }
                      }
                  ]
              });
    • doesNotContain

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              doesNotContain: "does Not contain"
                          }
                      }
                  ]
              });
    • doesNotEqual

      Type:
      string
      Default:
      ""

      Code Sample

       
                   //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              doesNotEqual: "does Not equal"
                          }
                      }
                  ]
              });
    • empty

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              empty: "empty"
                          }
                      }
                  ]
              });
                
    • endsWith

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              endsWith: "ends with"
                          }
                      }
                  ]
              });
    • equals

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              equals: "equals"
                          }
                      }
                  ]
              });
    • false

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              false: "false"
                          }
                      }
                  ]
              });
    • falseLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              falseLabel: "false"
                          }
                      }
                  ]
              });
    • filterDialogAddLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogAddLabel: "add"
                          }
                      }
                  ]
              });
    • filterDialogAllLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogAllLabel: "all"
                          }
                      }
                  ]
              });
    • filterDialogAnyLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogAnyLabel: "any"
                          }
                      }
                  ]
              });
    • filterDialogCancelLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogCancelLabel: "cancel"
                          }
                      }
                  ]
              });
    • filterDialogCaptionLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogCaptionLabel: "Advanced Filtering"
                          }
                      }
                  ]
              });
    • filterDialogClearAllLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogClearAllLabel: "clear all"
                          }
                      }
                  ]
              });
    • filterDialogConditionLabel1

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogConditionLabel1: "Show"
                          }
                      }
                  ]
              });
    • filterDialogConditionLabel2

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogConditionLabel2: "records matching the following criteria"
                          }
                      }
                  ]
              });
    • filterDialogErrorLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogErrorLabel: "error"
                          }
                      }
                  ]
              });
    • filterDialogOkLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterDialogOkLabel: "ok"
                          }
                      }
                  ]
              });
    • filterSummaryTitleLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              filterSummaryTitleLabel: "filtering summary"
                          }
                      }
                  ]
              });
    • greaterThan

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              greaterThan: "greater than"
                          }
                      }
                  ]
              });
    • greaterThanOrEqualTo

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              greaterThanOrEqualTo: "greater than or equal to"
                          }
                      }
                  ]
              });
    • lastMonth

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              lastMonth: "last month"
                          }
                      }
                  ]
              });
    • lastYear

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              lastYear: "last year"
                          }
                      }
                  ]
              });
    • lessThan

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              lessThan: "less than"
                          }
                      }
                  ]
              });
    • lessThanOrEqualTo

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              lessThanOrEqualTo: "less than or equal to"
                          }
                      }
                  ]
              });
    • nextMonth

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              nextMonth: "next month"
                          }
                      }
                  ]
              });
    • nextYear

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              nextYear: "next year"
                          }
                      }
                  ]
              });
    • noFilter

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              noFilter: "no filter"
                          }
                      }
                  ]
              });
    • notEmpty

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              notEmpty: "not empty"
                          }
                      }
                  ]
              });
    • notNull

      Type:
      string
      Default:
      ""

      Code Sample

       //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              notNull: "not null"
                          }
                      }
                  ]
              }); 
    • notOn

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              notOn: "not on"
                          }
                      }
                  ]
              });
    • nullLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              nullLabel: "null label"
                          }
                      }
                  ]
              });
    • on

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              on: "on"
                          }
                      }
                  ]
              });
    • startsWith

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              startsWith: "starts with"
                          }
                      }
                  ]
              });
    • thisMonth

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              thisMonth: "this month"
                          }
                      }
                  ]
              });
    • thisYear

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              thisYear: "this year"
                          }
                      }
                  ]
              });
    • today

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              today: "today"
                          }
                      }
                  ]
              });
    • true

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              true: "True"
                          }
                      }
                  ]
              });
    • trueLabel

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              trueLabel: "true"
                          }
                      }
                  ]
              });
    • yesterday

      Type:
      string
      Default:
      ""

      Code Sample

       
                //Initialize
              $(".selector").igGrid({
                  features: [
                      {
                          name : "Filtering",
                          labels: {
                              yesterday: "yesterday"
                          }
                      }
                  ]
              });
  • mode

    Type:
    enumeration
    Default:
    null

    Default is 'simple' for non-virtualized grids, and 'advanced' when virtualization is enabled.

    Members

    • simple
    • Type:string
    • renders just a filter row.
    • advanced
    • Type:string
    • allows to configure multiple filters from a dialog - Excel style.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        mode : "advanced"
                    }
                ]
            });
            
            //Get
            var filterMode = $(".selector").igGridFiltering("option", "mode");
    
            //Set
            $(".selector").igGridFiltering("option", "mode", "advanced");
            
  • nullTexts

    Type:
    object
    Default:
    {}

    List of configurable and localized null texts that will be used for the filter editors.

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        nullTexts: {
                            contains: "Contains...",
                            doesNotContain: "Does not contain...",
                            doesNotEqual: "Does not equal...",
                            empty: "Empty",
                            endsWith: "Ends with..."
                            //...
                        }
                    }
                ]
            });
     
            //Get
            var filteringNullTexts = $(".selector").igGridFiltering("option", "nullTexts");
     
            //Set
            $(".selector").igGridFiltering("option", "nullTexts", {
                            contains: "Contains...",
                            doesNotContain: "Does not contain...",
                            doesNotEqual: "Does not equal...",
                            empty: "Empty",
                            endsWith: "Ends with..."
                            //...
                        });
          
    • after

      Type:
      string
      Default:
      ""

    • before

      Type:
      string
      Default:
      ""

    • contains

      Type:
      string
      Default:
      ""

    • doesNotContain

      Type:
      string
      Default:
      ""

    • doesNotEqual

      Type:
      string
      Default:
      ""

    • empty

      Type:
      string
      Default:
      ""

    • endsWith

      Type:
      string
      Default:
      ""

    • equals

      Type:
      string
      Default:
      ""

    • greaterThan

      Type:
      string
      Default:
      ""

    • greaterThanOrEqualTo

      Type:
      string
      Default:
      ""

    • lastMonth

      Type:
      string
      Default:
      ""

    • lastYear

      Type:
      string
      Default:
      ""

    • lessThan

      Type:
      string
      Default:
      ""

    • lessThanOrEqualTo

      Type:
      string
      Default:
      ""

    • nextMonth

      Type:
      string
      Default:
      ""

    • nextYear

      Type:
      string
      Default:
      ""

    • notEmpty

      Type:
      string
      Default:
      ""

    • notNull

      Type:
      string
      Default:
      ""

    • notOn

      Type:
      string
      Default:
      ""

    • null

      Type:
      string
      Default:
      ""

    • on

      Type:
      string
      Default:
      ""

    • startsWith

      Type:
      string
      Default:
      ""

    • thisMonth

      Type:
      string
      Default:
      ""

    • thisYear

      Type:
      string
      Default:
      ""

  • persist

    Type:
    bool
    Default:
    true

    Enables / disables filtering persistence between states.

    Code Sample

            //Initialize
            $(".selector").igGrid({
                features : [
                    {
                        name : "Filtering",
                        persist : false
                    }
                ]
            });
    
            //Get
            var persist = $(".selector").igGridFiltering("option", "persist");
    
            //Set
            $(".selector").igGridFiltering("option", "persist", false);
          
  • renderFC

    Type:
    bool
    Default:
    true

    Render in feature chooser. Feature chooser is dialog which lists all the enabled features (like Sorting, Filtering, Hiding etc.) of igGrid.

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        renderFC: false
                    }
                ]
            });
     
            //Get
            var filteringRenderFC = $(".selector").igGridFiltering("option", "renderFC");
     
            //Set
            $(".selector").igGridFiltering("option", "renderFC", false);
          
  • renderFilterButton

    Type:
    bool
    Default:
    true

    Enable/disable filter button visibility. If false,no filter dropdown buttons will be rendered and predefined list of filters will not be rendered for the columns.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        renderFilterButton : false
                    }
                ]
            });
            
            //Get
            var showButton = $(".selector").igGridFiltering("option", "renderFilterButton");
    
            //Set
            $(".selector").igGridFiltering("option", "renderFilterButton", false);
          
  • showEmptyConditions

    Type:
    bool
    Default:
    false

    Enable/disable empty condition visibility in the filter. If true, shows empty and not empty filtering conditions in the dropdowns.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        showEmptyConditions : true
                    }
                ]
            });
            
            //Get
            var showConditions = $(".selector").igGridFiltering("option", "showEmptyConditions");
    
            //Set
            $(".selector").igGridFiltering("option", "showEmptyConditions", true);
            
  • showNullConditions

    Type:
    bool
    Default:
    false

    Enable/disable visibility of null and not null filtering conditions in the dropdowns. If true, shows null and not null filtering conditions in the dropdowns.

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        showNullConditions : true
                    }
                ]
            });
            
            //Get
            var showConditions = $(".selector").igGridFiltering("option", "showNullConditions");
    
            //Set
            $(".selector").igGridFiltering("option", "showNullConditions", true);
            
  • tooltipTemplate

    Type:
    string
    Default:
    ""

    Custom tooltip template for the filter button, when a filter is applied.

    Code Sample

      
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        tooltipTemplate: "${condition} filter applied"
                    }
                ]
            });
     
            //Get
            var template = $(".selector").igGridFiltering("option", "tooltipTemplate");
     
            //Set
            $(".selector").igGridFiltering("option", "tooltipTemplate", "${condition} filter applied");
          
  • type

    Type:
    enumeration
    Default:
    null

    Type of filtering. Delegates all filtering functionality to the $.ig.DataSource.

    Members

    • remote
    • Type:string
    • local
    • Type:string

    Code Sample

     
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        type : "local"
                    }
                ]
            });
            
            //Get
            var filterType = $(".selector").igGridFiltering("option", "type");
            

For more information on how to interact with the Ignite UI controls' events, refer to
Using Events in Ignite UI.

Note: Calling API methods programmatically does not raise events related to their operation unless specifically stated otherwise by the corresponding API documentation; those events are only raised by their respective user interaction.

Show Details
  • dataFiltered

    Cancellable:
    false

    Event fired after the filtering has been executed and results are rendered.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.columnIndex to get column index. Applicable only when filtering mode is "simple".
    Use ui.columnKey to get column key.Applicable only when filtering mode is "simple".
    Use ui.expressions to get filtered expressions.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringdatafiltered", function (evt, ui) {
                //return column key
                ui.columnKey;
                //return column index
                ui.columnIndex;
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return filtering expressions from the data source
                ui.expressions;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        dataFiltered: function (evt, ui) {...}
                    }
                ]
            });
          
  • dataFiltering

    Cancellable:
    true

    Event fired before a filtering operation is executed (remote request or local).
    Return false in order to cancel filtering operation.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.columnIndex to get column index. Applicable only when filtering mode is "simple".
    Use ui.columnKey to get column key. Applicable only when filtering mode is "simple".
    Use ui.newExpressions to get filtering expressions. Filtering expressions could be changed in this event handler and after that data binding is applied. In this way the user could control filtering more easily before applying data-binding.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringdatafiltering", function (evt, ui) {
                //return column key
                ui.columnKey;
                //return column index
                ui.columnIndex;
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return the new filtering expressions that are going to be applied to the data source
                ui.newExpressions;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        dataFiltering: function (evt, ui) {...}
                    }
                ]
            });
          
  • dropDownClosed

    Cancellable:
    false

    Event fired after a filter column dropdown is completely closed.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dropDown to get reference to dropdown DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringdropdownclosed", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dropdown html element in the DOM
                ui.dropDown;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        dropDownClosed: function (evt, ui) {...}
                    }
                ]
            });
          
  • dropDownClosing

    Cancellable:
    true

    Event fired before the filter dropdown starts closing.
    Return false in order to cancel dropdown closing.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dropDown to get reference to dropdown DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringdropdownclosing", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dropdown html element in the DOM
                ui.dropDown;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        dropDownClosing: function (evt, ui) {...}
                    }
                ]
            });
          
  • dropDownOpened

    Cancellable:
    false

    Event fired after the filter dropdown is opened for a specific column.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dropDown to get reference to dropdown DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringdropdownopened", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dropdown html element in the DOM
                ui.dropDown;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        dropDownOpened: function (evt, ui) {...}
                    }
                ]
            });
          
  • dropDownOpening

    Cancellable:
    true

    Event fired before the filter dropdown is opened for a specific column.
    Return false in order to cancel dropdown opening.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dropDown to get reference to dropdown DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringdropdownopening", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dropdown html element in the DOM
                ui.dropDown;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        dropDownOpening: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogClosed

    Cancellable:
    false

    Event fired after the advanced filter dialog has been closed.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogclosed", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogClosed: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogClosing

    Cancellable:
    true

    Event fired before the advanced filter dialog is closed.
    Return false in order to cancel filtering dialog closing.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogclosing", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogClosing: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogContentsRendered

    Cancellable:
    false

    Event fired after the contents of the advanced filter dialog are rendered.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dialogElement to get reference to filtering dialog DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogcontentsrendered", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dialog html element in the DOM
                ui.dialogElement;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogContentsRendered: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogContentsRendering

    Cancellable:
    true

    Event fired before the contents of the advanced filter dialog are rendered.
    Return false in order to cancel filtering dialog rendering.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dialogElement to get reference to filtering dialog DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogcontentsrendering", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dialog html element in the DOM
                ui.dialogElement;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogContentsRendering: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogFilterAdded

    Cancellable:
    false

    Event fired after a filter row is added to the advanced filter dialog.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.filter to get reference to filters table row DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogfilteradded", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return filters table row element in the DOM
                ui.filter;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogFilterAdded: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogFilterAdding

    Cancellable:
    true

    Event fired before a filter row is added to the advanced filter dialog.
    Return false in order to cancel filter adding to the advanced filtering dialog.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.filtersTableBody to get reference to filters table body DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogfilteradding", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return filters table body element in the DOM
                ui.filtersTableBody;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogFilterAdding: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogFiltering

    Cancellable:
    true

    Event fired when the OK button in the advanced filter dialog is pressed.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dialog to get reference to filtering dialog DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogfiltering", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dialog html element in the DOM
                ui.dialog;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogFiltering: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogMoving

    Cancellable:
    true

    Event fired every time the advanced filter dialog changes its position.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dialog to get reference to filtering dialog DOM element.
    Use ui.originalPosition to get the original position of the groupby dialog div as { top, left } object, relative to the page.
    Use ui.position to get the current position of the groupby dialog div as { top, left } object, relative to the page.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogmoving", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dialog html element in the DOM
                ui.dialog;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogMoving: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogOpened

    Cancellable:
    false

    Event fired after the advanced filter dialog is already opened.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dialog to get reference to filtering dialog DOM element.

    Code Sample

      
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogopened", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dialog html element in the DOM
                ui.dialog;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogOpened: function (evt, ui) {...}
                    }
                ]
            });
          
  • filterDialogOpening

    Cancellable:
    true

    Event fired before the advanced filtering dialog is opened.
    Return false in order to cancel filter dialog opening.
    Function takes arguments evt and ui.
    Use ui.owner to get reference to igGridFiltering.
    Use ui.owner.grid to get reference to igGrid.
    Use ui.dialog to get reference to filtering dialog DOM element.

    Code Sample

     
            //Delegate
            $(document).delegate(".selector", "iggridfilteringfilterdialogopening", function (evt, ui) {
                //return reference to igGridFiltering
                ui.owner;
                //return reference to igGrid
                ui.owner.grid;
                //return dialog html element in the DOM
                ui.dialog;
            });
            
            //Initialize
            $(".selector").igGrid({
                features: [
                    {
                        name : "Filtering",
                        filterDialogOpening: function (evt, ui) {...}
                    }
                ]
            });
          
  • destroy

    .igGridFiltering( "destroy" );

    Destroys the filtering widget - remove fitler row, unbinds events, returns the grid to its previous state.

    Code Sample

     
            $(".selector").igGridFiltering("destroy");
          
  • filter

    .igGridFiltering( "filter", expressions:array, [updateUI:bool] );

    Applies filtering programmatically and updates the UI by default.

    • expressions
    • Type:array
    • An array of filtering expressions, each one having the format {fieldName: , expr: , cond: , logic: } where fieldName is the key of the column, expr is the actual expression string with which we would like to filter, logic is 'AND' or 'OR', and cond is one of the following strings: "equals", "doesNotEqual", "contains", "doesNotContain", "greaterThan", "lessThan", "greaterThanOrEqualTo", "lessThanOrEqualTo", "true", "false", "null", "notNull", "empty", "notEmpty", "startsWith", "endsWith", "today", "yesterday", "on", "notOn", "thisMonth", "lastMonth", "nextMonth", "before", "after", "thisYear", "lastYear", "nextYear". The difference between the empty and null filtering conditions is that empty includes null, NaN, and undefined, as well as the empty string.
    • updateUI
    • Type:bool
    • Optional
    • specifies whether the filter row should be also updated once the grid is filtered.

    Code Sample

     
                    /*
                    Expressions is an array of individual filtering expressions that the grid uses when filtering.
                    If you only want to execute one filter criteria, then you add a single filtering expression to the array, 
                    otherwise you can add additional constraints to the filter by adding more expressions into the array.
    
                    For example: 
                          [{ fieldname: "title", expr: "introduction", cond: "contains", logic: "OR" },
                          { fieldname: "description", expr: "introduction", cond: "contains", logic: "OR" }]
    
                    Using the expressions above the applied filter returns records in the grid where either
                    the "title" or "description" fields have values that contain the string "introduction".
                    Note: The following conditions (grouped by data type) are available to perform filtering on the grid:
                    - String
                      -   startsWith
                      -   endsWith
                      -   contains
                      -   doesNotContain
                      -   equals
                      -   doesNotEqual
                      -   null
                      -   notNull
                      -   empty
                      -   notEmpty
                    - Number
                      -   equals
                      -   doesNotEqual
                      -   greaterThan
                      -   lessThan
                      -   greaterThanOrEqualTo
                      -   lessThanOrEqualTo
                      -   null
                      -   notNull
                      -   empty
                      -   notEmpty
                    - Boolean
                      -   true
                      -   false
                      -   null
                      -   notNull
                      -   empty
                      -   notEmpty
                    - Date
                      -   on
                      -   notOn
                      -   after
                      -   before
                      -   today
                      -   yesterday
                      -   thisMonth
                      -   lastMonth
                      -   nextMonth
                      -   thisYear
                      -   lastYear
                      -   nextYear
                      -   null
                      -   notNull
                      -   empty
                      -   notEmpty
                    - Object
                      -   null
                      -   notNull
                      -   empty
                      -   notEmpty
    
                    The difference between the "empty" and "null" filtering conditions is that "empty" includes 
                    "null", "NaN", "undefined" and empty strings.
                    
                    Note: Available values for "logic" are "OR" and "AND". The default logic is "AND".
                    */
                    $(".selector").igGridFiltering("filter", ([{fieldName: "Name", expr: "Adjustable Race", cond: "equals", logic: "OR"}]));
          
  • getFilteringMatchesCount

    .igGridFiltering( "getFilteringMatchesCount" );
    Return Type:
    number
    Return Type Description:
    count of filtered records.

    Returns the count of data records that match filtering conditions.

    Code Sample

     
            $(".selector").igGridFiltering("getFilteringMatchesCount");
          
  • requiresFilteringExpression

    .igGridFiltering( "requiresFilteringExpression", filterCondition:string );
    Return Type:
    bool
    Return Type Description:
    if false then filterCondition does not require filtering expression.

    Check whether filterCondition requires or not filtering expression - e.g. if filterCondition is "lastMonth", "thisMonth", "null", "notNull", "true", "false", etc. then filtering expression is NOT required.

    • filterCondition
    • Type:string
    • filtering condition - e.g. "true", "false", "yesterday", "empty", "null", etc.

    Code Sample

     
          $(".selector").igGridFiltering("requiresFilteringExpression", "yesterday");
          
  • toggleFilterRowByFeatureChooser

    .igGridFiltering( "toggleFilterRowByFeatureChooser", event:string );

    Toggle filter row when mode is simple or advancedModeEditorsVisible is TRUE. Otherwise show/hide advanced dialog.

    • event
    • Type:string
    • Column key.

    Code Sample

      
            $(".buttonSelector").igButton({ labelText: $(".buttonSelector").val(), click: function (event) {
                    $(".gridSelector").igGridFiltering("toggleFilterRowByFeatureChooser", event);
                } 
            });
          
  • ui-widget-overlay ui-iggrid-blockarea

    Classes applied to the filtering block area, when the advanced filter dialog is opened and the area behind it is grayed out (that's the block area).
  • ui-icon ui-iggrid-icon-advanced-filter

    Classes applied to the feature chooser icon when filter shows advanced dialog.
  • ui-iggrid-filterbutton ui-corner-all ui-icon ui-icon-triangle-1-s

    Classes applied to every filtering dropdown button.
  • ui-iggrid-filterbuttonactive ui-state-active

    Classes applied to the filter button when it is selected.
  • ui-iggrid-filterbutton ui-iggrid-filterbuttonadvanced ui-icon ui-icon-search

    Classes applied to the button when mode = advanced. This also applies to the button when it's rendered in the header (which is the default behavior).
  • ui-iggrid-filterbuttonadvancedactive ui-state-active

    Classes applied on the advanced button when it is selected.
  • ui-iggrid-filterbuttonadvanceddisabled ui-state-disabled

    Classes applied on the advanced button when it is disabled.
  • ui-iggrid-filterbuttonadvancedfocus ui-state-focus

    Classes applied on the advanced button when it has focus.
  • ui-iggrid-filterbuttonadvancedhover ui-state-hover

    Classes applied on the advanced button when it is hovered.
  • ui-iggrid-filterbuttonright ui-iggrid-filterbuttonadvanced ui-icon ui-icon-search

    Classes applied to the advanced filtering button when it is rendered on the right.
  • ui-iggrid-filterbuttonbool

    Classes applied to the filter button when a boolean filter is applied for the column (default).
  • ui-iggrid-filterbuttondate

    Classes applied to the filter button when a date filter is defined for the column.
  • ui-iggrid-filterbuttondisabled ui-state-disabled

    Classes applied to the filtering button when it is disabled.
  • ui-iggrid-filterbuttonfocus ui-state-focus

    Classes applied to the filter button when it has focus but is not selected.
  • ui-iggrid-filterbuttonhover ui-state-hover

    Classes applied to the filter button when it is hovered.
  • ui-iggrid-filterbuttonnumber

    Classes applied to the filter button when a number filter is applied for the column (default).
  • ui-iggrid-filterbuttonstring

    Classes applied to the filter button when a string filter is applied for the column (default).
  • ui-iggrid-filtercell

    Classes applied to every filter cell TH.
  • ui-iggrid-filtereditor

    Classes applied to every filter editor element (igEditor).
  • ui-dialog ui-draggable ui-resizable ui-iggrid-dialog ui-widget ui-widget-content ui-corner-all

    Classes applied to the filter dialog element.
  • ui-iggrid-filterdialogaddbuttoncontainer ui-helper-reset

    Classes applied to the filter dialog add button.
  • ui-iggrid-filterdialogaddcondition

    Classes applied to the filter dialog add condition area.
  • ui-iggrid-filterdialogaddconditionlist

    Classes applied to the filter dialog add condition SELECT dropdown.
  • ui-iggrid-filterdialogclearall

    Classes applied to the filter dialog "Clear All" button.
  • ui-icon ui-icon-closethick

    Classes applied to the "X" button used to remove filters from the filters table.
  • ui-iggrid-filtertable ui-helper-reset

    Classes applied to the filter dialog filters table.
  • ui-dialog-titlebar ui-iggrid-filterdialogcaption ui-widget-header ui-corner-all ui-helper-reset ui-helper-clearfix

    Classes applied to the filter dialog header caption area.
  • ui-dialog-title

    Class applied to the filter dialog header caption title.
  • ui-dialog-buttonpane ui-widget-content ui-helper-clearfix ui-iggrid-filterdialogokcancelbuttoncontainer

    Classes applied to the filter dialog OK and Cancel buttons.
  • ui-iggrid-filterdd

    Classes applied to the DIV which wraps the dropdown UL.
  • ui-menu ui-widget ui-widget-content ui-iggrid-filterddlist ui-corner-all

    Classes applied to the UL filter dropdown list.
  • ui-iggrid-filterddlistitem

    Classes applied to each filter dropdown list item (LI).
  • ui-iggrid-filterddlistitemactive ui-state-active

    Classes applied to the list item when it is selected.
  • ui-iggrid-filterddlistitemadvanced

    Class applied to the list item that holds the Advanced button, if options are configured such that editors are shown when mode = "advanced".
  • ui-iggrid-filterddlistitemclear

    Classes applied to the "clear" filter list item.
  • ui-iggrid-filterddlistitemhover ui-state-hover

    Classes applied to the list item when it is hovered.
  • ui-iggrid-filterddlistitemcontainer

    Classes applied to the element that holds the text in every filter list item (LI).
  • ui-iggrid-filterddlistitemicons ui-state-default

    Classes applied to the list item when filtering icons are visible for it.
  • ui-iggrid-filtericon

    Classes applied to every filter dropdown list item's image icon area.
  • ui-iggrid-filtericonafter

    Classes applied to the item icon's span when the item holds an after condition.
  • ui-iggrid-filtericonbefore

    Classes applied to the item icon's span when the item holds a before condition.
  • ui-iggrid-filtericonclear

    Classes applied to the item icon's span when the item holds a clear condition.
  • ui-iggrid-filtericoncontainer

    Classes applied to the item icon's container element.
  • ui-iggrid-filtericoncontains

    Classes applied to the item icon's span when the item holds a contains condition.
  • ui-iggrid-filtericondoesnotcontain

    Classes applied to the item icon's span when the item holds a doesNotContain condition.
  • ui-iggrid-filtericondoesnotequal

    Classes applied to the item icon's span when the item holds a doesNotEqual condition.
  • ui-iggrid-filtericonendswith

    Classes applied to the item icon's span when the item holds an endsWith condition.
  • ui-iggrid-filtericonequals

    Classes applied to the item icon's span when the item holds a contains condition.
  • ui-iggrid-filtericonfalse

    Classes applied to the item icon's span when the item holds a false condition.
  • ui-iggrid-filtericongreaterthan

    Classes applied to the item icon's span when the item holds a greaterThan condition.
  • ui-iggrid-filtericongreaterthanorequalto

    Classes applied to the item icon's span when the item holds a greaterThanOrEqualTo condition.
  • ui-iggrid-filtericonlastmonth

    Classes applied to the item icon's span when the item holds a lastMonth condition.
  • ui-iggrid-filtericonlastyear

    Classes applied to the item icon's span when the item holds a lastYear condition.
  • ui-iggrid-filtericonlessthan

    Classes applied to the item icon's span when the item holds a lessThan condition.
  • ui-iggrid-filtericonlessthanorequalto

    Classes applied to the item icon's span when the item holds a lessThanOrEqualTo condition.
  • ui-iggrid-filtericonnextmonth

    Classes applied to the item icon's span when the item holds a nextMonth condition.
  • ui-iggrid-filtericonnextyear

    Classes applied to the item icon's span when the item holds a nextYear condition.
  • ui-iggrid-filtericonnoton

    Classes applied to the item icon's span when the item holds a notOn condition.
  • ui-iggrid-filtericonon

    Classes applied to the item icon's span when the item holds an on condition.
  • ui-iggrid-filtericonstartswith

    Classes applied to the item icon's span when the item holds a startsWith condition.
  • ui-iggrid-filtericonthismonth

    Classes applied to the item icon's span when the item holds a thisMonth condition.
  • ui-iggrid-filtericonthisyear

    Classes applied to the item icon's span when the item holds a thisYear condition.
  • ui-iggrid-filtericontoday

    Classes applied to the item icon's span when the item holds a today condition.
  • ui-iggrid-filtericontrue

    Classes applied to the item icon's span when the item holds a true condition.
  • ui-iggrid-filtericonyesterday

    Classes applied to the item icon's span when the item holds a yesterday condition.
  • ui-iggrid-filterrow ui-widget

    Classes applied to the filter row TR in the headers table.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.

#