Filter only works by column ?

[karamustiParticipant]

Hello, i’m using jqwidgets V2.9.1 and there is a bug(seems like). For example;

I have data source as like
datafields : [ {name:'XStatus', type:'number'}, {name:'XName'}] // XStatus is 1 OR 0

And grid columns
columns:[{ text: 'Name Of X', datafield: 'XName' }]

Lastly, i made a custom panel, contains two radio buttons to filter by XStatus
js code

if(radiobuttonvalue == 0){
  var filtergroup = new $.jqx.filter();
  var filter_or_operator = 1;
  var filtervalue = 0;
  var filtercondition = 'equal';
  var filter1 = filtergroup.createfilter('numericfilter', filtervalue, filtercondition);
  filtergroup.addfilter(filter_or_operator, filter1);
  $("#mygrid").jqxGrid('addfilter', 'XStatus', filtergroup);
  $("#mygrid").jqxGrid('applyfilters');
}

if(radiobuttonvalue == 1){
  var filtergroup = new $.jqx.filter();
  var filter_or_operator = 1;
  var filtervalue = 1;
  var filtercondition = 'equal';
  var filter1 = filtergroup.createfilter('numericfilter', filtervalue, filtercondition);
  filtergroup.addfilter(filter_or_operator, filter1);
  $("#mygrid").jqxGrid('addfilter', 'XStatus', filtergroup);
  $("#mygrid").jqxGrid('applyfilters');
}

But it does not work. WHY ?
Why does not ‘filter’ work by datafields ? If i put XSTATUS into columns, works.

Thanks..

[Peter StoevKeymaster]

Hi karamusti,

1. The “type” member of your datafields is missing. It should be set to “string”, “number”, “bool” or “date” depending on your column’s type.
2. You can apply filter only to columns available in jqxGrid. ‘XStatus’ is not defined as far as I see.
3. We do not support so old versions.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[karamustiParticipant]

Hi Peter, thanks for response but it never satisfied me.
Even i forget put ‘type’ to datafields, it works sometimes but my point is not that..
And i accept situation of supporting for old versions as is..

But, what kind of solution do you suggest me ? my point is ordinary thing.
I want to filter by ‘X Column’, but dont want to show ‘X Column’

[jdhParticipant]

You can hide columns, just add hidden: true.

[Author]

Posts