Link to home
Create AccountLog in
Avatar of newtoperlpgm
newtoperlpgmFlag for United States of America

asked on

Oracle APEX 4 question

I am new to Oracle APEX and have built what I think is a simple application.  I built an interactive report.  I have 4 parameters for the report, and I display the report in a region on the same page based on the query parameters. The report only displays two columns, an ID number (not unique), and a unique type.

Column1(IDCODE)       REP_TYPE
0987654321                  SAMPLE
0987654321                 ANOTHERSAMPLE

What I want to do is to set an item value to that of what is in Column1(IDCODE).  The reason I need to do that is so that I can then pass that item back to my database in a second query.
I hope this makes sense, I can elaborate further if necessary.
Thanks for any help you can give.
Avatar of ianmills2002
ianmills2002
Flag of Australia image

I assume you want to click on the value and kick off the second query?

Is this 2nd query used in a another report?
Avatar of newtoperlpgm

ASKER

Hello,
Something like that.  Yes, when I click on the link for that value I need that value to run a query against my database.  The 2nd query is actually a query outside of APEX, in Oracle though, so I need to have that value to store, and pass.  It gets more complicated...the report is not an APEX report, it's an Oracle Report 10 report.  That part I can do, if I have the value...
Thanks very much for your response and help.
ASKER CERTIFIED SOLUTION
Avatar of ianmills2002
ianmills2002
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thank you.  
Your solution below worked for me.
I just had a look at the interactive reports. It looks like in the column definition on the report, you may be able to set the value in the Column Link section of the column definition.