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 !!!
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 !!!
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
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
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.
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.
Alexey Kakunin
i have used Custom finder as suggested by you..............
Thanks for your help.