Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article explains how to use SQL for Confluence with Run Self Service Reports to display dynamic content on a page.

Instructions

  1. For dynamic value substitution, you need to use $ with the field name. Write a SQL statement in the SQL macro as shown below.

    Code Block
    Select CREATOR,CREATIONDATE from SPACES WHERE SPACEID='$Space Id' AND SPACEKEY='$Space Key';



Info