Hi,
First up some details on the environment - i'm using the oracle virtual box image of the latest developer days download from oracle.com. This includes DB version 12.1.0.2 and Apex version 4.2.5.00.08. For the question though i don't think specifics of the versions are that relevant.
What i want to do is have an apex page which consists of a summary section at the top followed by a detail section underneath - a row is selected/highlighted in the top section which then causes rows relevant to that summary row to be displayed beneath. Its essentially a master/detail screen - however the source of both datasets is just a query - it's not a table.
So the top query is something like
select * from summary
and the section below is
select * from details where id = (the id value clicked in summary above)
This feels like it should be really easy (and indeed it is for tables through the master/detail apex wizard) - but i can't seem to figure it out when both datasets are the results of queries.
I can't seem to make any reference to page items when it's a report and i think i may need to go down some sort of dynamic actions and jquery route but i'm not getting very far very fast. I've found a few notes which seem similar but nothing that does exactly what i want. The APEX_APPLICATION function to loop through an array also doesn't seem to be possible for report output as far as i could see (the tags are not there) - is this only relevant for forms?
I hope I explained that simply enough.
Can anyone help?
Cheers,
Rich