Using sql plugin inside user macro

[Bruce Schlueter]

Hi,

I am looking for a way to reuse the result from the sql plugin inside a user macro. What I actually want to do is to create a table that contains the titles of the last edited pages from a space.

The result I receive via sql plugin. Now I want to create links underneath the title so that if you click onto the title inside the table you will be switched to that page. I thought this might be possible with a usermacro. Any help is apreciated.

Thanks, Bruce

[Bob Swift OSS (Bob Swift Atlassian Apps) · Accepted solution]

Just use wiki markup for linking as the output of your column data. Set the output format for the macro to be wiki.

select '[' || title || ']' from ...

[Bruce Schlueter]

thanks for your response but that does not solve my problem. I did find that hint in the reporting documentation, but this leads to a table filled with "0" instead of the title. If I just add the query to the page it works fine but has no links to the page. Am I missing anything? We are running Confluence 4.3.2 against a MySQL.

[Bob Swift OSS (Bob Swift Atlassian Apps)]

This is pretty standard usage scenario. With MySQL you probably need to use the concat function, but it virtually the same. I need more details to see what you are doing. Open an issue if you have more difficulties and provide your SQL.

[Bruce Schlueter]

Thanks, I got it now. Reading is one thing understanding correct another :-(

For those who are unable to see it directly in MySQL the query should look like this

select title AS Titel,concat("[",contentid,"@easypage","]") as Link from vw_newest_pages_easywiki

You need to add the square brackets inside the "concat"

Anyway, thanks for your hint to head me into the right direction