You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@click.apache.org by dian ruzda <di...@gmail.com> on 2009/05/07 08:28:23 UTC
Display inner join list in Table Control
Hi, all
I have problem in my project. I use Hibernate to handle Data Access. When I
try query with HQL inner join I want to set into table control with
setRowList(list);
But I have problem when Query in hibernate with join must set on array of
Object to extrak data. This my sample query with HIbernate:
*****************************************************************************************************************
Query q = sess.createQuery("select p,dt from Product p inner join
b.dtTrans as dt");
List myList = q.list();
*****************************************************************************************************************
can we set Object myList directly on Table Control to display all data from
this query ?
Re: Display inner join list in Table Control
Posted by dian <di...@gmail.com>.
Ok, it's Work .
Thx Bob
sabob wrote:
>
> Hi Dian,
>
> From your query it seems your list will contain two types of objects,
> Product and DTTrans. So your list content will look like this:
>
> [Product, DTTrans, DTTrans, Product, DTTrans, Product, ...]
>
> In this case you will need to set a Decorator on your Columns to
> render the content depending on the type of object that is processed.
>
> See this example of how to use Decorators:
> http://www.avoka.com/click-examples/table/table-decorator.htm
>
> Hope this helps.
>
> bob
>
> On 5/7/09, dian ruzda <di...@gmail.com> wrote:
>> Hi, all
>>
>> I have problem in my project. I use Hibernate to handle Data Access. When
>> I
>> try query with HQL inner join I want to set into table control with
>> setRowList(list);
>>
>> But I have problem when Query in hibernate with join must set on array of
>> Object to extrak data. This my sample query with HIbernate:
>> *****************************************************************************************************************
>> Query q = sess.createQuery("select p,dt from Product p inner join
>> b.dtTrans as dt");
>> List myList = q.list();
>> *****************************************************************************************************************
>>
>> can we set Object myList directly on Table Control to display all data
>> from
>> this query ?
>>
>
>
> --
> http://incubator.apache.org/click/
>
>
--
View this message in context: http://n2.nabble.com/Display-inner-join-list-in-Table-Control-tp2826377p2905646.html
Sent from the click-user mailing list archive at Nabble.com.
Re: Display inner join list in Table Control
Posted by Bob Schellink <sa...@gmail.com>.
Hi Dian,
>From your query it seems your list will contain two types of objects,
Product and DTTrans. So your list content will look like this:
[Product, DTTrans, DTTrans, Product, DTTrans, Product, ...]
In this case you will need to set a Decorator on your Columns to
render the content depending on the type of object that is processed.
See this example of how to use Decorators:
http://www.avoka.com/click-examples/table/table-decorator.htm
Hope this helps.
bob
On 5/7/09, dian ruzda <di...@gmail.com> wrote:
> Hi, all
>
> I have problem in my project. I use Hibernate to handle Data Access. When I
> try query with HQL inner join I want to set into table control with
> setRowList(list);
>
> But I have problem when Query in hibernate with join must set on array of
> Object to extrak data. This my sample query with HIbernate:
> *****************************************************************************************************************
> Query q = sess.createQuery("select p,dt from Product p inner join
> b.dtTrans as dt");
> List myList = q.list();
> *****************************************************************************************************************
>
> can we set Object myList directly on Table Control to display all data from
> this query ?
>
--
http://incubator.apache.org/click/