How to get filter column name and its value

[NeelamMember]

Hello,

I want to export the filtered rows came after applying filter on one of the data fields. thats why I need filterdatafield and filtervalue to so that I can export the rows manually.

Regards,
Neelam

[Peter StoevKeymaster]

Hi Neelam,

You can use the getfilterinformation method to get an array of all filters applied to jqxGrid.

var filterInfo = $(“#jqxgrid”).jqxGrid(‘getfilterinformation’);

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[NeelamMember]

Hi Peter,

Thanks for reply but I got below code to get column name on which filter was applied. But how to find the filter value applied on particular column?

var filterinfo = $(“#jqxgrid”).jqxGrid(‘getfilterinformation’);

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

var eventData = "Filter Column: " + filterinfo[i].filtercolumntext;

}

Please suggest something.

Thanks & Regards,
Neelam

[Peter StoevKeymaster]

Hi Neelam,

Here’s how to get the filter value and condition:

var filter = $("#jqxgrid").jqxGrid('getfilterinformation');
var filter0 = filter[0];
var value = filter0.filter.getfilters()[0].value;
var  condition = filter0.filter.getfilters()[0].condition;

Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[NeelamMember]

Hello,

Above solution return values and condition but didn’t returns datafield name. Also if I apply filter on second column, it returns me filter value but if dont click on clear button of filter and apply second filter on first column, it returns me filter value of second column instead of first column.

I tries using clearfilters, removefilter, and refresh methods.

$(“#jqxgrid”).bind(“filter”, function (event) {

//$(‘#jqxgrid’).jqxGrid(‘removefilter’, ‘datafield’);
//$(‘#jqxgrid’).jqxGrid(‘clearfilters’);

var filter = $(“#jqxgrid”).jqxGrid(‘getfilterinformation’);

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

var filter0 = filter[0];
var value = filter0.filter.getfilters()[0].value;
var condition = filter0.filter.getfilters()[0].condition;

}
});

Thanks,
Neelam

[Peter StoevKeymaster]

Hi Neelam,

It is possible to have multiple filters applied to jqxGrid.

The code below returns only the first one in the filter array. If you have multiple filters, then you will need to iterate through the ‘filter’ array and do your custom logic. The ‘filtercolumn’ property returns the datafield’s name.

var filter = $("#jqxgrid").jqxGrid('getfilterinformation');
var filter0 = filter[0];
var value = filter0.filter.getfilters()[0].value;
var  condition = filter0.filter.getfilters()[0].condition;
var datafield = filter0.filtercolumn;

Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[zorgozParticipant]

Hello,

Is there any simple way to get the exact same query string that is passed in virtualmode to the ajax backend containing filterscount, filtervalue, filtercondition, filterdatafield, filteroperator and all the other parameters?

Thank you

[dougcurlParticipant]

Just came across this post, and I think this is a solution for building a query string with the filter data (needed this to send to a map service which plots the same data in the table) – in case anyone needs this:

` $(“#jqxgrid”).on(“filter”, function(event){
var f = 0
var filterQstr = “”
var filterinfo = $(“#results_grid”).jqxGrid(‘getfilterinformation’);
$.each(filterinfo, function( i, val){
filterQstr += “&filterdatafield”+f+”=”+filterinfo[i].datafield
filterQstr += “&”+filterinfo[i].datafield+”operator=”+filterinfo[i].filter.operator
$.each(filterinfo[i].filter.getfilters(), function(x){
filterQstr += “&filtervalue”+f+”=”+filterinfo[i].filter.getfilters()[x].value
filterQstr += “&filtercondition”+f+”=”+filterinfo[i].filter.getfilters()[x].condition
filterQstr += “&filteroperator”+f+”=”+filterinfo[i].filter.getfilters()[x].operator
//add up filters:
f += 1
});
});
});

[echerniParticipant]

I also came across this post for passing the filter’s parameters to an ajax call. Dougcurl’s solution is fine but excludes the possibility of an extra filter value per datafield. If we enter a second filter value on the same datafield, the script only adds filterdatafield. So with trial and error I managed to come with a simpler solution. At least it works for me.

To the var source add the following:

processData: function(data)
                {
                    test = data;
                }

Then the following code anywhere you need it:

    var query = '';

     for (var i in test) {
         query += '&' + i + '=' +test[i];

     }

     console.log(query); //see output.

I use it for grid export purposes:

window.open('<?php echo $dirpath ?>/ajax-export.php?export=true'+query,'_blank');

On the php side you have to use almost the same code the server side grid filtering sample uses, expect for the pagination part and you are good to go. Worked for me!

Thanks.

[RanaParticipant]

if the column has both datafield and displayfield, getfilterinformation is giving displayfield.
Can we retrieve datafield in any way?

[Author]

Posts