Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How can Pass more variable in Column Link (11G,APEX 3.1.2,win32)
icon4.gif  How can Pass more variable in Column Link [message #377812] Thu, 25 December 2008 08:03 Go to next message
kinghow
Messages: 13
Registered: December 2008
Junior Member
Why oracle just set three item in Column Link? from 1.6 up 3.1.2,I'm very disappointed.why not 5 or 10?

who can tell the best method !
Re: How can Pass more variable in Column Link [message #377835 is a reply to message #377812] Thu, 25 December 2008 20:31 Go to previous messageGo to next message
kinghow
Messages: 13
Registered: December 2008
Junior Member
My app like BI report,I'm drillthrough more than 5 to get detail data,so many variable must be pass by Column Link.I build many view to merge variable column to one column to pass,it's so bad.

why oracle just set 3 item?
Re: How can Pass more variable in Column Link [message #377864 is a reply to message #377835] Thu, 25 December 2008 23:51 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Just pass the primary key and then lookup the row again from the new page

Ross Leishman
Re: How can Pass more variable in Column Link [message #377865 is a reply to message #377812] Thu, 25 December 2008 23:59 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
is it not possible to write some process in before page header and using n number of columns parameter.

In many of the application packages, conveniently every one used three column link only. ofcourse i do not know why. further concatenating columns we shall be able solve. But in apex 3.1.2 concatenation is not getting permitted while passing the parameter link. For me it is a mistery too.
yours
dr.s.raghunathan

Re: How can Pass more variable in Column Link [message #377888 is a reply to message #377865] Fri, 26 December 2008 01:54 Go to previous messageGo to next message
kinghow
Messages: 13
Registered: December 2008
Junior Member
In BI report,many level report is statistic view,can not pass the primary key.

drillthrough more level to untill get detail data,must pass many dimensions column.

The app is developer begin 1.6,run on 2.0,recently need add some function,so rise to 3.1.2, I'm very disappointed Column Link is still 3 items.I wish next vesion it can be add by userself.
Re: How can Pass more variable in Column Link [message #379397 is a reply to message #377812] Tue, 06 January 2009 05:36 Go to previous messageGo to next message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
What you could do is disable the link, and write it in manually in the HTML expression field in the column attributes.
E.g. You have a table called mytable with the columns col1, col2, col3 and col4. If your report code is then
select col1, col2, col3, col4 from mytable

You can give in something like this in the column where you want your link (this is if you want to link to page 2)
<a href="f?p=&APP_ID.:2:&APP_SESSION.::&DEBUG.::ITEM1,ITEM2,ITEM3,ITEM4:#COL1#,#COL2#,#COL3#,#COL4#">Link text</a>

The fields with hash signs around them are the names of the columns which you want to pass to the page you're linking to from the report. And if you want the link to display the value of column 1 you could just replace "Link text" with #COL1#
Re: How can Pass more variable in Column Link [message #389335 is a reply to message #377812] Sat, 28 February 2009 13:19 Go to previous messageGo to next message
craig67
Messages: 8
Registered: February 2009
Junior Member
you can still add in more items using the standard item, value section. simply append each new item or value with a comma.


Craig
www.oracleapplicationexpress.com
icon14.gif  Re: How can Pass more variable in Column Link [message #389400 is a reply to message #389335] Sun, 01 March 2009 20:56 Go to previous message
kinghow
Messages: 13
Registered: December 2008
Junior Member
Thanks,Craig!

It's work.It's answer i expect,powerful and simple,i like it.
Previous Topic: Saving to two different tables
Next Topic: MULTIPLE VALUE PASSING "IN" OPERATOR FROM "MULTISELECT LIST"
Goto Forum:
  


Current Time: Thu Mar 28 16:45:53 CDT 2024