How to add a link in Scandio Pocket Query results?

[Joao Flavio Mendonca]

Hello,

I am creating some reports in pocket query and the result of this report is a weblink which I would like the user could click on and be directed to a confluence page, however, in pocket query the result appears as plain text only.

How can I configure this link to be "clickable"?

Thanks  a lot

Joao Flavio

[Terra Nostra · Accepted solution]

Thank you, but this script not worked for me.

[Terra Nostra]

Can you tell me what data is in your clickable table?

[Terra Nostra]

I used a different template, it's works.

<tbody>
#foreach ($row in $result)
<tr>
#foreach ($key in $row.keySet())
#if ($key == "link")
<td>
<a href="$row.Link">$row.get("title")</a>
</td>
#elseif($key != "title")
<td>$row.get($key)</td>
#end
#end
</tr>
#end
</tbody>

[Terra Nostra]

Hello,

did you find a way to do that?

[Joao Flavio Mendonca]

Hello, 

Yes, I managed to create a HTML script as a Pocket Query template and it works very well.

This is the code I used:

<script>
## @Param colresizable:true
PocketQuery.template("default")
</script>

<table class="aui confluenceTable pocketquery-table">
<thead>
<tr>
#foreach ($column in $columns)
<th>$!column</th>
#end
</tr>
</thead>

<tbody>
#foreach ($row in $result)
<tr>
#foreach ($column in $row)
<td>$!column</td>
#end
</tr>
#end
</tbody>
</table>

Thanks for your attention

Best Regards