How to add a link in Scandio Pocket Query results?

Joao Flavio Mendonca January 19, 2018

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

2 answers

1 accepted

1 vote
Answer accepted
Terra Nostra November 12, 2018

Thank you, but this script not worked for me.

Terra Nostra November 12, 2018

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

Terra Nostra November 12, 2018

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>

0 votes
Terra Nostra November 9, 2018

Hello,

did you find a way to do that?

Joao Flavio Mendonca November 11, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events