Links

How to do SQL database operations on lists of data

Alternative 1

Steps

1. Create a user macro goto-url
   • No macro body

   • Output HTML

     <script type="text/javascript">location.replace('$paramurl');</script> 
     

2. Determine the url you need
3. Create the run markup as needed

Example

{run:replace=name:My new page|titleRun=New page}

{goto-url:url=$base_url/pages/createpage-name.action?name=$name&spaceKey=$space_key&fromPageId=$page_id}

{run}

Alternative 2

This uses a more complex user macro to extract the link from the body and then redirect to the referenced link.

Steps

1. Create a user extract-link user macro or use the extract-link macro from Run Self-Service Reports for Confluence.
   • Has macro body - use Convert wiki markup to HTML so it will render embedded macros and markup

   • Output HTML

     ## Macro to search the body text for the first element that looks like a link.
     ## Finds any quoted (single or double) http:// or https:// link or href= value
     ## Returns the unquoted value as raw text or locates to the link if redirect=true
     ## @param redirect:title=Redirect|type=boolean|desc=Redirect to link|default=false
     
     #set ($body = $body.trim())
     
     <script type="text/javascript">
     var regex = /['"](http[s]{0,1}:\/\/[^'"]*)['"]/;   // http type link
     var match = regex.exec('$body');
     var redirect = ('$paramredirect' == 'true')
     
     if (!match) {  // no http type link found
        regex = /href=['"]([^'"]*)['"]/;      // href link
        match = regex.exec('$body');
     } 
     if (match) {
         if (redirect) {
             try {
                 location.replace(match[1]);
             } catch (e) {
                 document.write('Error: ' + e.message + '. ' +  match[1]);
             }
         } else {
             document.write(match[1]);
         }
     } 
     </script> 
     

2. Create the run markup as needed
3. Create the body of the run macro so that it produces the link desired.

Examples

{run:titleRun=Show going to a page on button press|replace=page:home}
{extract-link:redirect=true} Some text [$page] some more text {extract-link}
{run}

{run:titleRun=Create a page|replace=name:example}
{extract-link:redirect=true} 
{add-page:name=$name|template=template1|parent=@self}This is ignored{add-page}
{extract-link}
{run}