Clientside merging of resultsets and providing them to a ListGrid using setData
Hi Isomorphic,
I'm in a situation where I have a few (currently four) complicated DB-Views.
As of today, I'm showing the aggregated (with server summaries) data of one of those views in a ListGrid.
Now I need to show the remaining data as well. But instead of having four ListGrids (one for each DB-View), I'd like to have the data in one ListGrid.
The "primaryKey" (=the grouped by fields) are always the same.
I could create another view, JOINing (perhaps UNIONing) the four other views. But this would make the query very complicated and I don't know how Oracle will behave in this situation, yet.
Is it possible (and common and supported) to query my four views in a Queue, then take the four DSRepsonses in the Queue-Callback and somehow merge the datasets in my application logic?
Finally I'd assign them to the ListGrid via setData().
I'm using latest 5.1p.
Thank you & Best regards
Blama
I'm in a situation where I have a few (currently four) complicated DB-Views.
As of today, I'm showing the aggregated (with server summaries) data of one of those views in a ListGrid.
Now I need to show the remaining data as well. But instead of having four ListGrids (one for each DB-View), I'd like to have the data in one ListGrid.
The "primaryKey" (=the grouped by fields) are always the same.
I could create another view, JOINing (perhaps UNIONing) the four other views. But this would make the query very complicated and I don't know how Oracle will behave in this situation, yet.
Is it possible (and common and supported) to query my four views in a Queue, then take the four DSRepsonses in the Queue-Callback and somehow merge the datasets in my application logic?
Finally I'd assign them to the ListGrid via setData().
I'm using latest 5.1p.
Thank you & Best regards
Blama
Comment