Clearing Filter and Filter Text in igGrid

Hello,

Within our grid, we are attempting to create a simple clear filter function.  We’ve gotten the ability to reset our filter with the following line of code:

$("#grid").igGridFiltering("filter',[]);

Passing in an empty array to reset the filter.  This creates most of the performance that we want, but what does occur is that the input from the user is still within the filter input cell in the grid.  Is it possible to basically call the “clear filter” option (one of the filter options in the grid ui itself)?

Thanks.

Dear Patrick,

Thank you for contacting Infragistics!

We received your support request concerning Clearing filter and filter text in igGrid, and this case has been assigned to me. Infragistics is dedicated to helping you solve this issue.

I am looking into this issue and will get back to you by the end of the day Thursday with more information or questions for you.

 

Hello Patrick,

It seems that the “updateUI” parameter is not taken into account when empty array is used in order to reset the filter

https://www.igniteui.com/help/api/2022.2/ui.iggridfiltering

An development issue will be submitted regarding this.

As a temporary workaround you can use the following code snippet

function clearFilter() {




        var $gridFiltering = $("#grid1").data("igGridFiltering");




        $gridFiltering.filter([],true);




        var editors = $gridFiltering._editors;




        for (var i = 0; i < editors.length; i++) {




            editors[i].value(null);




        }




//      $("#grid1").igGridFiltering("filter", ([{ fieldName: "ProductID", expr: '', cond: "equals"}]));




//      $("#grid1").igGridFiltering("filter", ([{ fieldName: "Color", expr: '', cond: "contains"}]));




}

 

Hope this helps.

Thanks, Tsvetelina!  That snippet worked exactly as expected.

Out of curiosity, is it possible to set the editor's values/text and programmatically invoking a filter event via filling in the igGridFiltering input?

For example, could I do something like:

editors[i].value("5"); //Assuming i is equal to a ProductID column

editors[i].text("5"); 

Would this execute a filter event?

Hello Patrick,

Using this approach you wil change only the value of the filtering editor but this won’t invoke the filtering event.

You need to use the filter method for the purpose.

function clearFilter() { 




    var colSettings = $("#grid1").igGridFiltering("option", "columnSettings");




    for (var i = 0; i < colSettings.length; i++) {




        $("#grid1").igGridFiltering("filter",




        ([{ fieldName: colSettings[i].columnKey, expr: '5', cond: colSettings[i].condition}]));




    }




}

 

Let me know if you have further questions.

Hi, is there a way to invoke the trigger to filter the grid? When I use .igGridFiltering, I keep getting the error saying "cannot call methods on igGridFiltering prior to initialization; attempted to call method 'option'"

Pete,

I recommend starting a new thread and including more details and including an example if possible.  At least include the relevant code that you are using.

Hello Patrick,

I have linked you case to the Development issue 124163. You will be notified once the service release is out include this fix.

Please let me know if I can provide any further assistance regarding this matter.

Hi thank's for your help, i tried your solution but it doesn't work propably because i have a posterior version of infragistics ! I have a Date column that could be filter by date of today, past year, actual year … When i reset filters the grid refresh correctly but the column date keep the last filter so if i filter again with another feild they take in consideration the two column condition, thus it filter the first time in the date and a second time for the other column.

Is there any recent solution to solve this problem or another way to refresh the filtered column ? 

Thank's for your time and your explanation.