dynamic datagrid

Hello,

I'd like to create a component from scratch whose aim is to display values from multiple different queries.

to do that, I've created a new component class(extends Component), a new XML and jsp.

In the Jsp, I added a dropdown to select the query I want to execute and the datagrid to display the queries results.I tried to make the datagrid as generic as possible to handle data from multiple queries -> I created 1 celllist for the headers and 1 for the rows. in these celllists, I've added the celltemplates to match the different possible fields.

My problem is that as the queries are returning different fields, I do not know how to set this dynamically to the celllists(I've tried to call celllist.setFields("fieldA,FieldB") in the drop down change but an error occurs telling that I cannot call setFields at that moment). if I put all the fields of all the queries on the cellllist fields, I have warnings telling that the grid cannot bind to fields that are not returned by the query(as I've put fields comming from the other queries)

the good thing would be:

when I select a query from the drop down, I set the query in the datagrid data provier(already done)

AND set the celllist fields according to the selected query. doing that when I make a selection in the dropdown generates errors.

Any idea?

thanks,

Michael.

Find more posts tagged with

Comments

udeleng

Note that DA has a DQL component which can display any kind of column which you can use as a reference.

Does your JSP look something like this?

<dmf:datagrid paged='true' preservesort='false'>

<dmf:celllist>

     <dmf:celltemplate>
          <dmf:datagridTh resizable="true">
               <dmf:datasortlink datafield='CURRENT'/>
          </dmf:datagridTh>
     </dmf:celltemplate>
</dmf:celllist>
<dmf:datagridRow>

<dmf:celllist>

          <dmf:celltemplate>
               <dmf:datagridRowTd nowrap="true">
                    <dmf:label datafield='CURRENT'/>
               </dmf:datagridRowTd>
          </dmf:celltemplate>
     </dmf:celllist>

</dmf:datagridRow>

<dmf:datagrid>

Michael_Planamente

I have the jsp BUT the celllist expects "fields" to be filled...

If I late it empty, I have an exception telling that celllist must contain the fields comming from the executed query. if I put all the fields of all possible queries, durng execution, Ihave warning telling that the grid cannot map to the expected fields(the fields comming from the otehrs queries)

I think the best thing would be to set the celllist at run time when a query is selected, with the exact returned fields of the selected query BUT I cannot do that because the cellist.setFields() tells me that I cannot do taht at that moment

Michael.

lastnitescurry

As already suggested please review the DQL query componwnr in Webtop and DA. It can handle a dynaminc number of columns. I used this to create such a flexiable datagrid as you require

udeleng

In your component,

implement IControlListener

In onInit add,

addControlListener(this);

In onControlInitialized() add,

if (control instanceof CellList) {

((CellList)control.setFields("my_field");

}

Hope this helps.