Having a hard time understanding how to use: Grid.

[jovanovicParticipant]

What is the easiest way to export selected rows from jqxGrid to CSV using jQuery?

[adminKeymaster]

Hi,

You can temporarily filter the grid only to selected rows and export them.

// Get selected row indexes
var selectedIndexes = $("#grid").jqxGrid('getselectedrowindexes');

if (selectedIndexes.length === 0) {
    alert("No rows selected");
    return;
}

// Build filter group
var filtergroup = new $.jqx.filter();
var filter_or_operator = 1;

// Assuming you have a unique column like 'id'
for (var i = 0; i < selectedIndexes.length; i++) {
    var rowData = $("#grid").jqxGrid('getrowdata', selectedIndexes[i]);

    var filtervalue = rowData.id; // change to your key field
    var filtercondition = 'EQUAL';
    var filter = filtergroup.createfilter('numericfilter', filtervalue, filtercondition);

    filtergroup.addfilter(filter_or_operator, filter);
}

// Apply filter
$("#grid").jqxGrid('addfilter', 'id', filtergroup);
$("#grid").jqxGrid('applyfilters');

// Export filtered rows
$("#grid").jqxGrid('exportdata', 'csv', 'selected_rows');

// Clear filters after export
$("#grid").jqxGrid('clearfilters');

Best regards,
Peter

[Author]

Posts