Forums de discussion

Dynamic Query

Debashish Mahato, modifié il y a 8 années.

Dynamic Query

New Member Publications: 9 Date d'inscription: 12/03/15 Publications récentes
Hi all
how can i use union operator in Dynamic query
i do not want to use custom sql is there any way to do it in dynamic query.

i will explain my scenario
i have two tables from which i have to fetch two colum data ( these two column are not related to each other)

Please Help !!!
thumbnail
Meera Prince, modifié il y a 8 années.

RE: Dynamic Query

Liferay Legend Publications: 1111 Date d'inscription: 08/02/11 Publications récentes
HI
If data is independent then simply fetch from each table and use java code to merge in the list or map its just my opinion i am not sure what complexcity you have.

Regards,
Meera Prince
thumbnail
Alexey Kakunin, modifié il y a 8 années.

RE: Dynamic Query

Liferay Master Publications: 621 Date d'inscription: 07/07/08 Publications récentes
Hi!

Dynamic Query not supporting scenario like this. So - you should do 2 queries (and merge them in java as already advices) or write custom finder (what is a little bit more complex). In Custom Finder you will have access to database connection and you will able to implement any custom sql query.
Debashish Mahato, modifié il y a 8 années.

RE: Dynamic Query

New Member Publications: 9 Date d'inscription: 12/03/15 Publications récentes
Hi
Alexey Kakunin

i have used Custom finder as suggested by you..............
Thanks for your help.