Fórumok
Dynamic Query
Debashish Mahato, módosítva 8 év-val korábban
Dynamic Query
New Member Bejegyzések: 9 Csatlakozás dátuma: 2015.03.12. Legújabb bejegyzések
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, módosítva 8 év-val korábban
RE: Dynamic Query
Liferay Legend Bejegyzések: 1111 Csatlakozás dátuma: 2011.02.08. Legújabb bejegyzések
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, módosítva 8 év-val korábban
RE: Dynamic Query
Liferay Master Bejegyzések: 621 Csatlakozás dátuma: 2008.07.07. Legújabb bejegyzések
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, módosítva 8 év-val korábban
RE: Dynamic Query
New Member Bejegyzések: 9 Csatlakozás dátuma: 2015.03.12. Legújabb bejegyzések
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.