View Source

Use case

You have a table with page titles. You need to get a dynamic result table where rows correspond to the current page title.

Switch the page to the edit mode.
Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.
Select the macro and click Edit.
In the Presets tab select Custom transformation and click Next.

Enter the following SQL query:

SELECT *
FROM T1 
WHERE T1.'Page Title' = @PAGETITLE

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > @pageTitle variable > pagetitle variable 1.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > @pageTitle variable > pagetitle variable 2.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > @pageTitle variable > pagetitle variable 3.png

The @pageTitle variable can be combined with other variables within the same query and successfully used in more complex SQL queries.

To learn more about the @currentUser variable, please visit the corresponding page.