留言板
Dynamic Query
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 !!!
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
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.