How to sort a group

Can you tell me how to add sorting to table group in code shown below 
String[] columnNames = new String[colCount]; 
cn = new String[colCount]; 
for (int i = 0; i < colCount; i++) { 
columnNames = meta.getColumnName(i + 1); 
cn = columnNames; 
} 
 
TableGroupHandle group = design.getElementFactory().newTableGroup(); 
group.setName("GroupPerValue"); 
group.setKeyExpr(""Floor""); 
RowHandle grpHdrHandle = design.getElementFactory().newTableRow(4); 
CellHandle tblCellHandle = (CellHandle) grpHdrHandle.getCells().get(0); 
//tblCellHandle.setDrop(DesignChoiceConstants.DROP_TYPE_DETAIL); 
LabelHandle lbl = efactory.newLabel(null); 
lbl.setText("kuku"); 
tblCellHandle.getContent().add(lbl); 
RowHandle grpFtrHandle = design.getElementFactory().newTableRow(4); 
CellHandle tblCellHandle2 = (CellHandle) grpFtrHandle.getCells().get(0); 
//tblCellHandle2.setDrop(DesignChoiceConstants.DROP_TYPE_DETAIL); 
LabelHandle lbl2 = efactory.newLabel("test2"); 
lbl2.setText("kuku-ruku"); 
tblCellHandle2.getContent().add(lbl2); 
 
group.setStringProperty("repeatHeader", "false"); 
group.setPageBreakAfter("always"); 
//group.setStringProperty("intervalBase", "6"); 
//group.setStringProperty("interval", "interval"); 
//group.setStringProperty("intervalRange", "14, 20"); 
group.setPageBreakBefore("always-excluding-first"); 
TableHandle table = efactory.newTableItem("tbl", colCount, 1, rowCount, 0); 
//table.setWidth("100%");

Find more posts tagged with

Comments

JasonW

Create your Group like:

TableGroupHandle group = elementFactory.newTableGroup( );
group.setName("MyGroup");
group.setKeyExpr( "row["ORDERNUMBER"]" );
group.setInterval("none");
group.setSortDirection("asc");

Then call one of the functions below

void addSortKey(TableGroupHandle th){
try{
SortKey sk = structFactory.createSortKey();
//sk.setKey("row["CustomerName"]");
sk.setDirection(DesignChoiceConstants.SORT_DIRECTION_ASC);
sk.setKey("if( params["srt"].value){ if( params["srt"].value == 'a' ){ row["CustomerName"]; }else{ row["CustomerCity"];}}");

PropertyHandle ph = th.getPropertyHandle(TableHandle.SORT_PROP);
ph.addItem(sk);
}catch (Exception e){
e.printStackTrace();
}
}

void modSortKey(TableGroupHandle th){
try{
SortKeyHandle sk;
PropertyHandle ph = th.getPropertyHandle(TableHandle.SORT_PROP);
//get number or iterate
sk = (SortKeyHandle)ph.get(0);
sk.setDirection(DesignChoiceConstants.SORT_DIRECTION_DESC);
}catch (Exception e){
e.printStackTrace();
}

}

Jason