Union query in aware IM like mysql

swiftinitpvtltd

SELECT
timestamp, amount, username
FROM
transaction1
UNION SELECT
timestamp, amount, username
FROM
transaction2
ORDER BY timestamp;

How do I achieve this in aware Im to combine 2 tables into single grid? In stored procedure I get data via union but I am not able to see user or shortcut columns(exist in these 2 BO's) in mysql tables. User_RID shows up but returns error in query.

PointsWell

To get the Shortcut details you’d need to join to the tables with the shortcut data.

AIM is doing the heavy lifting for you via shortcuts but if you use a stored procedure you need to do all the selects yourself. (You might get away with not having to do explicit selects for the shortcuts if you put the results into an already existing BO - this is a guess I have tested exotic SPs into existing BOs)

It’s hard to tell what you are trying to achieve from transaction 1&2 BOs.

Are Transaction 1 and Transaction 2 a recursive relationship to themselves?

himanshu

User Business Object Groups

swiftinitpvtltd

Thank you!
There is no fix relationship except both store same type of data but at different times and one column type has different data (UserType transaction vs financial transaction in these 2 tables). As its large data we are using different tables to distinguish user actions vs other actions. I want to combine these tables for display purpose as thats one requirement and now I do not want to create another BO for storing both in single BO and display so I need union.

Jaymer

The union of two or more tables is exactly what happens when you are using business object GROUP.
( You can see union in the SQL code when you look behind the scenes at operations involving BO groups. )
Just make a group over the top of both of those tables, and query using that new BO.