Rank: Newbie
Groups: Registered
Joined: 4/25/2016(UTC) Posts: 5  Location: Bangalore Thanks: 1 times
|
Hi Team,
We had a requirement where the we needed to execute a union operation on the database to get the query. Could you please advise if Seal Report supports Union operation ???
Any help is greatly appreciated.
Thanks in advance.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Not really, to have a UNION you should define it in a view or to define a table in your Source like: Code:select * from (
select col1 from table1
union
select col2 from table2
) a
Then you have a table with your union.
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/25/2016(UTC) Posts: 5 Location: Bangalore Thanks: 1 times
|
Thank you for you reply.
Just to make sure my understanding is correct. I will have to either create a view or table in the database and access that view or table to get the result ??
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
No you can either create a View in your database
OR in your Data Source, create a new table definition and use the "SQL Statement" property to define your select with union or not...
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/25/2016(UTC) Posts: 5 Location: Bangalore Thanks: 1 times
|
Thank you, that helped a lot. :)
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
