Dynamic Query

[8年前 に Debashish Mahato によって更新されました。]

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 !!!

[8年前 に Meera Prince によって更新されました。]

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

[8年前 に Alexey Kakunin によって更新されました。]

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.

[8年前 に Debashish Mahato によって更新されました。]

Hi
Alexey Kakunin

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