How I can remove filter to particular grid column

[NarendraParticipant]

Hi,

I am using jqxgrid in my application. I set the property filterble ‘true’ to my jqxgrid. I have 5 columns namely as

A,B,C,D,E in my jqxgrid, I want filterble option to B,C,D columns and I don’t want filter option to A and E columns.

how can I achieve this.. Please give quick reply..

[DimitarParticipant]

Hello Narendra,

Each column has a filterable property, which you can set to false to disable filtering of the particular column, e.g.:

$("#jqxgrid").jqxGrid(
{
    width: 670,
    source: adapter,
    filterable: true,
    sortable: true,
    autoshowfiltericon: true,
    columns: [
        { text: 'First Name', datafield: 'firstname', width: 90, filterable: false },
        { text: 'Last Name', datafield: 'lastname', width: 90 },
        { text: 'Product', datafield: 'productname', width: 170 },
        { text: 'Order Date', datafield: 'date', width: 160, cellsformat: 'dd-MMMM-yyyy' },
        { text: 'Quantity', datafield: 'quantity', width: 80, cellsalign: 'right' },
        { text: 'Unit Price', datafield: 'price', cellsalign: 'right', cellsformat: 'c2' }
    ]
});

Best Regards,
Dimitar

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

[NarendraParticipant]

Hi,

I tried that it’s working. I set properties to those columns as sortable: false, filterable: false. but when I

clicked on the column one drop down is appearing with options “sort ascending”, “sort descending”, “remove sort” and those

are all in disabled mode. I don’t want to display those also..

Give me quick reply..

Thanks in advance..

[DimitarParticipant]

Hi Narendra,

Please set the column property menu to false, i.e.:

{ text: 'First Name', datafield: 'firstname', width: 90, filterable: false, sortable: false, menu: false },

Best Regards,
Dimitar

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

[NarendraParticipant]

Thank you.. It’s working fine..

[mpintozParticipant]

thank you very much

[Author]

Posts