:: Forum >> Version 2 >>

URGENT!!!! Get Column values for Selected Rows

I'm trying to get all column values from a list of selected rows.
There is a way to do it?

I did this but is not working.

function GetColumnBySelectedRows(ColoGrid){
    
    var 
myRowsIndex oGrid.getSelectedRows();
    
alert(myRowsIndex);
    var 
mySelectedRowsIndex =  myRowsIndex.split(","); <-- problem here
    
    alert
(mySelectedRowsIndex);
    
//alert(oGrid.getData(0,SeletedRowsIndex));
    //var mySelectedRowsIndex = SeletedRowsIndex.split(",");
    //alert(mySelectedRowsIndex);
    
var rowIndexiIndexrowColumnValue "";
     
    for(
iIndex=0iIndex<aSelectedRowsIndex.lengthiIndex++){ 
           
rowIndex aSelectedRowsIndex[iIndex]; 
        
      
rowColumnValue += oGrid.getCellText(Col,rowIndex) + ","
    }
     
    return 
rowColumnValue
Any ideas?
Odimar Tomazeli
Wednesday, April 11, 2007
Here a piece of a function I wrote to export all visible data. Hope this helps.

/**
 * function dataHandler_exportData(oDatagrid, aDatagridData, aDatagridColumns, bWYSIWYG)
 * 
 * + exports rows in dataGrid
 * 
 * @param  oDatagrid               object   ActiveWidget's grid 1.0 object
 * @param  aDatagridData           array    data represented in oDatagrid
 * @param  aDatagridColumns        array    array containing the column names
 * @param  bWYSIWYG                boolean  if set to true, only visible data is exported; default is TRUE                                                                      
 *                                 
 * @returns nothing       
 */   
function dataHandler_exportData(oDatagridaDatagridDataaDatagridColumnsbWYSIWYG)
{
  
/* init */
  
var aExportData    = new Array();
  var 
aExportColumns = new Array();
  var 
iColumnLength  aDatagridColumns.length;
  var 
iRowLength     aDatagridData.length;
  
  if (
bWYSIWYG==null)
  {
    
bWYSIWYG true;
  } 
  
/* get form */
  
var oForm document.getElementById(oDatagrid.name+'_actionForm');
  
  
//save action and target
  
sFormAction oForm.action;
  
sFormTarget oForm.target;
  
  
//change action and target
  
oForm.action 'Helper/exportTable.php?action='+iAction;
  
oForm.target '_blank';
  
  
/* remove columns/data which arent visible */ 
  
if (bWYSIWYG==true)
  {
    var 
aiVisibleColumnIndexes oDatagrid.getColumnValues();
    
    
//columns
    
for (var j=iColumnLength-1j>=0j--)
    {
      if (
aiVisibleColumnIndexes.indexOf(j)==-1)
      {
        
//column is not visible: remove entry
        
aDatagridColumns.splice(j,1);
      }
    }  
    
    
//data
    
for (var i=0i<iRowLengthi++)
    {
      for (var 
j=iColumnLength-1j>=0j--)
      {      
        if (
aiVisibleColumnIndexes.indexOf(j)==-1)
        {
          
//column is not visible: remove entry
          
aDatagridData[i].splice(j,1);
        } 
      }  
    }
  }  
       
  
/* put columns and data in string */ 
  
for (var i=0i<iRowLengthi++) //walk through rows
  
{    
    
//add column data to export array
    
aExportData[i] = encodeURIComponent(aDatagridData[i].join(','));      
  } 
  
(...)
}
 
Rekcor
Wednesday, April 11, 2007
(hint: you must alter the last part of the code: my code walks through all rows, your code should walk to selected rows only; something like

/* get selected rows in grid */
var selectedRows oDatagrid.getSelectionProperty("values");

for (
i=0i<selectedRows.lengthi++)
{
  
aExportData[i] = aDatagridData[selectedRows[i]].join(',');
}
 
)
Rekcor
Wednesday, April 11, 2007
I'm gonna use this for sure!!! Thank you very much
Odimar Tomazeli
Wednesday, April 11, 2007



This topic is archived.

Back to support forum

Forum search