How to map two tables in cuba. while both table have a common table.

Support
#1

Suppose there are three tables, A,B and C.
Table B has a Table A’s id and similarly table C has a Table A’s id. How to join Table B and C in cuba.
Using valueCollectionDataSource

#2

Hi Mallik,
If you mean you need to join B and C by A.id, you can simply use a JPQL query like this:

select distinct b.name, c.name from value$EntityB b join value$EntityC c
on b.aLink.id = c.aLink.id 
where b.aLink.id = :ds$entityADs

or like this

select b.name, c.name from value$EntityB b, value$EntityC c
where b.aLink.id = c.aLink.id 
and b.aLink.id = :ds$entityADs

You can see how it works in the sample project attached.

value.zip (34.2K)