nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to apply a Date/DateTime/Time format to a dynamic table cell

denisMoret

Hi, 
 
I am trying to create a dynamic table using the following example : 
<a class='bbc_url' href='http://wiki.eclipse.org/Java_-_Build_Dynamic_Table_(BIRT'>Java - Build Dynamic Table (BIRT - Eclipsepedia</a>) 
I would like to format columns with a custom DateTime format. I don't know on which object and what method I should apply. I believe it should be done somehow somewhere in the following loop but I am not sure of course. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
// table detail
RowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 );
for( int i=0; i < cols.size(); i++){
CellHandle cell = (CellHandle) tabledetail.getCells( ).get( i );
DataItemHandle data = designFactory.newDataItem( "data_"+(String)cols.get(i) );
data.setResultSetColumn( (String)cols.get(i));
cell.getContent( ).add( data );
}
</pre>
 
Thanks

Find more posts tagged with

Comments

JasonW

Try this:

FormatValue formatValueToSet = new DateTimeFormatValue( );
formatValueToSet.setCategory( "Short Date" );
formatValueToSet.setPattern( "yyyy/mm/dd" );
data.setProperty( "dateTimeFormat", formatValueToSet );

Jason

denisMoret

Thanks JasonW, it works perfectly. 
 
I used the following code: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
FormatValue formatValueToSet = new DateTimeFormatValue( );
formatValueToSet.setCategory("Custom");
formatValueToSet.setPattern(mDateFormat);
data.setProperty( StyleHandle.DATE_TIME_FORMAT_PROP, formatValueToSet );
</pre>
StyleHandle.DATE_TIME_FORMAT_PROP is a String equal to dateTimeFormat which can be found in the XML code in the property name of structure nodes. 
 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">dd.MM.yyyy</property>
</structure>
</pre>
I took a look at the XML code of a few reports made with Eclipse and I noticed that whatever the DateFormat you set, even if you set a Time format (e.g HH:mm), the property name is always set to dateTimeFormat. I say this because you can also find 
StyleHandle.DATE_FORMAT_PROP equals to dateFormat 
StyleHandle.TIME_FORMAT_PROP equals to timeFormat 
If you use them you may have trouble and not get the result you expect. 
 
 
Thanks again.