jQuery Grid Plugin - jqGrid

Hi,

    i have a jqgrid which populates data form database.when i click on name header to search particular name and press enter it will give only those records with the searched name.now i want to export to excel that filter names.while exporting its giving all the rows in the grid not the filter records which i searched with particular name not sure where i am doing wrong.

here is my code..

$("#list").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: true, defaultSearch: "cn" }).navButtonAdd('#pager', {caption:"Export to Excel",

buttonicon:"ui-icon-disk",

onClickButton:function() {

ExportDataToExcel("#list");

},

position:"last"

});

 

function ExportDataToExcel(tableCtrl) {

ExportJQGridDataToExcel(tableCtrl,"View.xlsx");

}

 

function ExportJQGridDataToExcel(tableCtrl, excelFilename) {
   
    var allJQGridData = $(tableCtrl).jqGrid('getGridParam', 'data');

    var jqgridRowIDs = $(tableCtrl).getDataIDs();              
    var headerData = $(tableCtrl).getRowData(jqgridRowIDs[0]);   // Fetch the list of "name" values in our colModel

 
    var columnNames = new Array();      
    var columnHeaders = new Array();    
    var inx = 0;
    var allColumnNames = $(tableCtrl).jqGrid('getGridParam', 'colNames').slice();
    allColumnNames.splice(0, 1);

    for (var headerValue in headerData) {
      
        var isColumnHidden = $(tableCtrl).jqGrid("getColProp", headerValue).hidden;
        if (!isColumnHidden && headerValue != null) {
            columnNames.push(headerValue);
            columnHeaders.push(allColumnNames[inx]);
        }
        inx++;
    }

  
    var excelData = '';
    for (var k = 0; k < columnNames.length; k++) {
        excelData += columnHeaders[k] + "\t";
    }
    excelData = removeLastChar(excelData) + "
";

 
    var cellValue = '';
    for (i = 0; i < allJQGridData.length; i++) {

        var data = allJQGridData[i];

        for (var j = 0; j < columnNames.length; j++) {

          
            cellValue = '' + data[columnNames[j]];

            if (cellValue == null)
                excelData += "\t";
            else {
                if (cellValue.indexOf("a href") > -1) {
                 
                    cellValue = $(cellValue).text();
                }
               
                cellValue = cellValue.replace(/'/g, "&apos;");

                excelData += cellValue + "\t";
            }
        }
        excelData = removeLastChar(excelData) + "
";
    }

 
    postAndRedirect("Helpers/ExportGridToExcel.ashx?filename=" + excelFilename, { excelData: excelData });
}