This discussion is archived
3 Replies Latest reply: Jan 4, 2013 4:41 AM by fac586 RSS

How to create multiple links in one column

979748 Newbie
Currently Being Moderated
Hi,

Could someone please help me with creating 2 different links in one column as below.

I enclosed is the screen shot of my current application view... I would like to put the link one below the other in one column instead in two different columns.

Table Name - SR_PROCESS
Functions - get_open_project , get_open_be
Columns - ''Initiate New Project'' , ''Initiate New Bug or Enhancement''

Below is my coding.

select

''Initiate New Project'' AS "Initiate New Project" ,
get_open_project("SR_PROCESS"."PROCESS_ID") "Open Projects",
''Initiate New Bug or Enhancement'' AS "Initiate New Bug" ,
get_open_be("SR_PROCESS"."PROCESS_ID") "Open Bugs"

from SR_PROCESS

Thanks, Sheetal
  • 1. Re: How to create multiple links in one column
    fac586 Guru
    Currently Being Moderated
    976745 wrote:
    Hi,
    Welcome to the forum: please read the FAQ and forum sticky threads (if you haven't done so already), and update your profile with a real handle instead of "976745".

    When you have a problem you'll get a faster, more effective response by including as much relevant information as possible upfront. This should include:

    <li>Full APEX version
    <li>Full DB/version/edition/host OS
    <li>Web server architecture (EPG, OHS or APEX listener/host OS)
    <li>Browser(s) and version(s) used
    <li>Theme
    <li>Template(s)
    <li>Region/item type(s) (making particular distinction as to whether a "report" is a standard report, an interactive report, or in fact an "updateable report" (i.e. a tabular form)

    With APEX we're also fortunate to have a great resource in apex.oracle.com where we can reproduce and share problems. Reproducing things there is the best way to troubleshoot most issues, especially those relating to layout and visual formatting. If you expect a detailed answer then it's appropriate for you to take on a significant part of the effort by getting as far as possible with an example of the problem on apex.oracle.com before asking for assistance with specific issues, which we can then see at first hand.
    Could someone please help me with creating 2 different links in one column as below.

    I enclosed is the screen shot of my current application view...
    Where is the screenshot? Providing an example on apex.oracle.com is a much better way to share details of your application.
    I would like to put the link one below the other in one column instead in two different columns.

    Table Name - SR_PROCESS
    Functions - get_open_project , get_open_be
    Columns - ''Initiate New Project'' , ''Initiate New Bug or Enhancement''

    Below is my coding.

    select

    ''Initiate New Project'' AS "Initiate New Project" ,
    get_open_project("SR_PROCESS"."PROCESS_ID") "Open Projects",
    ''Initiate New Bug or Enhancement'' AS "Initiate New Bug" ,
    get_open_be("SR_PROCESS"."PROCESS_ID") "Open Bugs"

    from SR_PROCESS
    Depends on your APEX version and the type of report. Please provide the information detailed above.
  • 2. Re: How to create multiple links in one column
    979748 Newbie
    Currently Being Moderated
    I don't see any option to attach the attachment.

    Current View of my application is as below:

    Column1 Column2

    Link 1 Link2

    My code for the above two columns are:

    ''Initiate New Project'' AS "Column1" ,
    ''Initiate New Bug or Enhancement'' AS "column2" ,

    (OR)

    ''Link1'' AS "Column1" ,
    ''Link2'' AS "column2" ,

    Now, is there a way I can write the above 2 statement as one statement and club both the link to show one column like below:

    Column1
    ------------
    Link1

    Link2

    Thanks, Sheetal
  • 3. Re: How to create multiple links in one column
    fac586 Guru
    Currently Being Moderated
    It depends on your APEX version and the type of report. Please provide the information detailed above.*

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points