grid filter option

[akanshaMember]

can i remove filter for some columns?
And in 1 column i have data like R1, R2, R3 and R4. But in filter option i am getting options like less than , greater than etc.
and also in 1 column i have data like 1, 2 , 3, 123, 1411, 2123 and when i click ascending it sorts like as if data is a string. Can i change the behavior. Grid i am working on is dynamic .

[Peter StoevKeymaster]

Hi akansha,

Do you set the ‘type’ property in the datafields definition?

Example:

var source =
{
    datatype: "xml",
    datafields: [
        { name: 'ShippedDate', map: 'm\\:properties>d\\:ShippedDate', type: 'date' },
        { name: 'Freight', map: 'm\\:properties>d\\:Freight', type: 'float' },
        { name: 'ShipName', map: 'm\\:properties>d\\:ShipName' },
        { name: 'ShipAddress', map: 'm\\:properties>d\\:ShipAddress' },
        { name: 'ShipCity', map: 'm\\:properties>d\\:ShipCity' },
        { name: 'ShipCountry', map: 'm\\:properties>d\\:ShipCountry' }
    ],
    root: "entry",
    record: "content",
    id: 'm\\:properties>d\\:OrderID',
    url: url,
    sortcolumn: 'ShipName',
    sortdirection: 'asc'
};

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[akanshaMember]

I am generating source object on fly. The solution might be if i’ll send the type also from back end.

one more question. I am generating column on fly as mentioned below, I want the first column as button. Below code is giving me button but with text as false. And also how will i write onclick event of this select button.

function GetColumns(jsonObj) {
    var columns = new Array();
    columns.push({
        "text": "Select",
        "datafield": "Select",
        columntype: 'button',
        "width": 220
    });
    for (var i = 0; i < jsonObj.length; i++) {
        columns.push({
            "text": jsonObj[i],
            "datafield": jsonObj[i],
            "width": 220
        });
    } 
    
    
    
    return columns;
}

[Peter StoevKeymaster]

Hi akansha,

To handle cell clicks, you can bind to the Grid’s ‘cellclick’ event.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[akanshaMember]

I am adding button in grid as mentioned below. I want the text in button as “select” . But i am getting text as “false”.

columns.push({
“text”: “Select”,
“datafield”: “Select”,
columntype: ‘button’,
“value”:”Select”,
“width”: 220

});

[Peter StoevKeymaster]

Hi akansha,

You can take a look at this sample: popupediting.htm. The sample has a button that displays ‘Edit’.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[akanshaMember]

i was missing cellsrenderer:function () {
return “Select”;}

Thanks!!!

[Author]

Posts