3 Replies Latest reply: Jan 4, 2013 6:41 AM by fac586 RSS

    How to create multiple links in one column

    979748
      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
          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
            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
              It depends on your APEX version and the type of report. Please provide the information detailed above.*