Dynamic Query for Two tables

Message Boards

Meera Prince, modified 8 Years ago.

Dynamic Query for Two tables

Liferay Legend Posts: 1111 Join Date: 2/8/11 Recent Posts

Hi ALL

How can we make inner join between two table using liferay dynamic query API and some table might not have model class then how can we create dynamic query for them
Example
assetentry and assetentries_assetcategories When we crate dynamic query it always expect model call to create it so please let me know if any one have examples regarding to this scenario

Regards,
Meera Prince

Ravi Kumar Gupta, modified 8 Years ago.

RE: Dynamic Query for Two tables

Liferay Legend Posts: 1302 Join Date: 6/24/09 Recent Posts

Meera,

Is Custom SQL not an option to implement and use here?

Meera Prince, modified 8 Years ago.

RE: Dynamic Query for Two tables

Liferay Legend Posts: 1111 Join Date: 2/8/11 Recent Posts

HI
Ok thank you .. but it should also work for those type of scenarios too I think otherwise again we need to go for custom sql. anyway thank you very much for your information.

Regards,
Meera Prince