Dynamic Query

[Debashish Mahato, modificado hace 8 años.]

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

[Meera Prince, modificado hace 8 años.]

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

[Alexey Kakunin, modificado hace 8 años.]

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, modificado hace 8 años.]

Hi
Alexey Kakunin

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