Forums

Home » Liferay Portal » English » 3. Development

Combination View Flat View Tree View
Threads [ Previous | Next ]
Ishan Sahore
Dynamic Query on Multiple Tables
October 17, 2012 5:48 AM
Answer

Ishan Sahore

Rank: Junior Member

Posts: 56

Join Date: April 25, 2012

Recent Posts

Hi all,

I want to know if we can use dynamic query for querying multiple tables.
1DynamicQuery query = DynamicQueryFactoryUtil.forClass(ExpandoTable.class,PortletClassloaderUtil.getClassLoader())                    .add(PropertyFactoryUtil.forName("tableId").eq(tableId));List<ExpandoTable> li=ExpandoTableLocalServiceUtil.dynamicQuery(query);

Above dynamic query queries a single table (ExpandoTable).
I want to query ExpandoColumn and ExpandoValue tables together.

Any help is appreciated.

Thanks,
Ishan