1. Inici
  2. General
  3. Dynamic Query for Two tables

Dynamic Query for Two tables

thumbnail
Meera Prince, modificat fa 11 anys.
Dynamic Query for Two tables
Liferay Legend Apunts: 1111 Data d'incorporació: 08/02/11 Publicacions recents
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
thumbnail
Ravi Kumar Gupta, modificat fa 11 anys.
RE: Dynamic Query for Two tables
Liferay Legend Apunts: 1302 Data d'incorporació: 24/06/09 Publicacions recents
Meera,

Is Custom SQL not an option to implement and use here?
thumbnail
Meera Prince, modificat fa 11 anys.
RE: Dynamic Query for Two tables
Liferay Legend Apunts: 1111 Data d'incorporació: 08/02/11 Publicacions recents
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