Exporting only selected rows

[SegueTech]

Hi folks,

Is it possible to use the export to Excel for only rows that have been selected with a state checkbox?

Thanks!

[paramvir]

selected rows could be filtered before exporting the data.

Code: [Select]

                {
                    type: 'button',
                    label: "Export",
                    icon: 'ui-icon-arrowthickstop-1-s',
                    listener: function () {

                        //filter the selected rows.
this.filter({
oper: 'replace',
data: [{dataIndx: 'state', value: true, condition: 'equal'}]
})

                        this.exportData({
                            url: "/pro/demos/exportData",
                            format: $("#export_format").val(),
                            zip: $("#export_zip").prop("checked"),
                            render: true
                        });

//reset the filter.
this.filter({
oper: 'replace',
data: []
})
                    }
                }


[SegueTech]

Great, thanks, I will give that a shot!

[SegueTech]

Does this mean that there would be no way to export only selected rows if I were to use the selectionModel type 'row' method? Or is there some way to allow a user to select rows that way and only export the highlighted rows to Excel?

[paramvir]

In that case add a hidden column with dataIndx: 'pq_rowselect' and use 'pq_rowselect' while filtering.

{ dataIndx: "pq_rowselect", hidden: true, dataType: 'bool' }

Code: [Select]

        //filter the selected rows.
this.filter({
oper: 'replace',
data: [{dataIndx: 'pq_rowselect', value: true, condition: 'equal'}]
});


[SegueTech]

Awesome, will try that! Thanks!

[SegueTech]

So that's working great, thanks again.  However, after the export, the selections appear in different places because the sort shifts a bit. I noticed that when I put the sort back, the selections are in the same place, which is what I want.  I have tried to get the sort model before I filter and then set it back afterwards, but I'm having trouble with this.  Following is just the listener code:

listener: function () {
//getter
var sortModel = $( "#grid_json" ).pqGrid( "option", "sortModel" );

//filter the selected rows.
this.filter({
   oper: 'replace',
   data: [{dataIndx: 'pq_rowselect', value: true, condition: 'equal'}]
});   
this.exportData({
   url: "index.cfm?fuseaction=browselist.exportExcel",             
   format: "xlsx",
   filename: "report",
   render: true
});
//reset the filter.
this.filter({
   oper: 'replace',
   data: []
})      
//setter
$( "#grid_json" ).pqGrid( "option", "sortModel", sortModel );                   
}

Please let me know if you can see what I'm missing.

Thanks!

[paramvir]

Data export and filtering doesn't change the sort order and sortModel properties, so I'm not sure what you are trying to do.

Anyways sorting can be refreshed by calling the sort() method.

Code: [Select]

this.sort();


[SegueTech]

I'm trying to prevent the selections from changing position in the grid.  When I do the export, for some reason, the rows change position.  If I click the sort twice to cycle back to where it was, then they are in the exact same position in the grid page. I just changed the listener to the following, but it is still doing the same thing:

listener: function () {
   //filter the selected rows.
   this.filter({
      oper: 'replace',
      data: [{dataIndx: 'pq_rowselect', value: true, condition: 'equal'}]
   });   
   this.exportData({
      url: "index.cfm?fuseaction=browselist.exportExcel",             
      format: "xlsx",
      filename: "report",
      render: true
   });
   //reset the filter.
   this.filter({
      oper: 'replace',
      data: []
   })      
   this.sort();         
}

I have attached a snippet of what the page looks like right before I click the export, and one of immediately after.  From the after image, if I were to click the Days_Old column until it cycles back to the same sort, the page will look exactly like the before image again.

Thanks!

[paramvir]

This code is equivalent to sorting due to twice click on the same header.

Code: [Select]

var sorter = this.option("sortModel.sorter");
if(sorter.length){
sorter[0].dir = sorter[0].dir=="up"?"down": "up";
this.sort({sorter: sorter, refresh: false});
//debugger;

        sorter[0].dir = sorter[0].dir=="up"?"down": "up";
this.sort({sorter: sorter});
}

This is only a workaround to fix the issue of shifting of selected records upon filtering, the issue would be fixed in the next version.

[SegueTech]

Thank you. That didn't work for me, still shifted to different spots, but good to know it will be fixed in the next version.

[SegueTech]

Using that pq_rowselect field, would there be an easy way to add a button to select all rows or unselect all rows on the current page?  It seems like there's no way to deselect using the space bar or the click.

Thanks!

[paramvir]

Click on any grid cell deselects the previous selections.

Example: http://paramquery.com/pro/demos/selection_row

To manipulate the selections with API, please check the documentation:

http://paramquery.com/pro/api#method-selection

[SegueTech]

Perhaps I'm missing something again, but even in the example page you sent, clicking on a different cell does deselect the previous selection, but it makes a new selection instead.  How do you deselect your selections by removing the selection entirely?  I would expect that like a checkbox, I could select and unselect without having to select something else.

[paramvir]

I would expect that like a checkbox, I could select and unselect without having to select something else

For that purpose, there are checkbox selections, http://paramquery.com/pro/demos/selection_checkbox

selection behavior can also be customized with cellMouseDown event, the following code would unselect a selected row if it's clicked while ctrl key is pressed.

Code: [Select]

cellMouseDown: function(evt, ui){

if(evt.ctrlKey &&  ui.rowData.pq_rowselect){
this.selection({
method: 'remove',
type: 'row',
rows: [{rowIndx: ui.rowIndx}]
});
return false;
}
},


Using that pq_rowselect field, would there be an easy way to add a button to select all rows or unselect all rows on the current page?

To select all rows upon click of button:

Code: [Select]

this.selection().selectAll({type: 'row'});


To deselect all rows upon click of button:

Code: [Select]

this.selection().removeAll({type: 'row'});