jQWidgets Forums

jQuery UI Widgets Forums Grid Filter only works by column ?

This topic contains 3 replies, has 3 voices, and was last updated by  jdh 7 years, 5 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • Filter only works by column ? #54696

    karamusti
    Participant

    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..

    Filter only works by column ? #54703

    Peter Stoev
    Keymaster

    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/

    Filter only works by column ? #54906

    karamusti
    Participant

    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’

    Filter only works by column ? #96305

    jdh
    Participant

    You can hide columns, just add hidden: true.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.