Hide duplicate field in row of table

Here is an example how to do it using the TRAVEL.HOTEL data source

1. Drop a table on a page.

2. Drop the Data Sources > Travel > Tables > HOTEL node on the table.

2.a In the Outline window, double-click SessionBean1 > hotelRowSet and set the Sort Type for HOTELNAME to Ascending. Close the query editor for the hotelRowSet

3. Add the following code to the bottom of the Java source for the page bean:

private String hideDuplicateHotelName;

public String getHideDuplicateHotelName() {

// assumes that the table is small (and thus uses an int)

// assumes that rowKey/rowId will return row position

// and not some other type of unique identifyer

// (the JavaDoc implies that rowKey can be otherwise).

RowKey rowKey=tableRowGroup1.getRowKey();

String hotelName = "";

try {

int rowNum=Integer.parseInt(rowKey.getRowId());

hotelName = (String) hotelDataProvider.getValue(

"HOTEL.HOTELNAME",

rowKey);

if (rowNum > 0) {

String prevRowNum = Integer.toString(rowNum - 1);

RowKey prevRowKey = hotelDataProvider.getRowKey(prevRowNum);

String prevHotelName = (String) hotelDataProvider.getValue(

"HOTEL.HOTELNAME",

prevRowKey);

if (hotelName.equals(prevHotelName))

hotelName="";

}

} catch(Exception e) {

log("exception in duplicate hotel property:" + e.getMessage());

}

return hotelName;

}

4. Go back to the Visual Designer and select one of the abc in the column for HOTELNAME so that the Properties window shows the properties for the Static Text component that is in the HOTELNAME column.

5. Click the ... button to the right of the text

property and click the Bind to an Object tab. In the Bind to an Object tab, select hideDuplicateHotelName.

6. Run the project. I hope the results are what you are looking for. The

jetsons at 2007-7-6 22:22:58 >

Hi,

I have tried to follow your suggetion; however unable to work it out since

i am not dropping the table. my data is coming from array data provider(which will populate from item class). eg column 1 is from employee class , column 2 is coming from item class. for each employee has many items. when i try to bind the data with array data provider, it does give me data for both items and emplyee, but when try to hid bye using the method,, getting null propery for employee.

a_b at 2007-7-6 22:22:58 >

Thank you for the response!

I am new to JSC, but that is exactly what i am doing to remove the duplicate rows

empId = (String) myArrayDataProvider.getValue(

"empId",

rowKey);

but doesn't seems working since problem is from the top, an array data provider to join data from two different data sources.

a_b at 2007-7-6 22:22:58 >