nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

PocketQuery and SQLforConfluence

artafon

Hi.

I have 2 the same sql query with columns: ID, Summary, Desc

In PocketQuery, data is displayed with the same column width. But, In SQLForConfluence - columns of different widths.

So, In desc columns I see all the text.

Could you help me please, is it real in PocketQuery?

Accepted answers

Carla Roocks (Scandio)

Hi Artashes,

you can make it possible for the user to change the column width by setting the parameter colresizable:true for the template in question. Then the column widths can be adjusted by draging the borders, so the full content becomes visible. Is this what you have in mind?

This minimalistic template simply adds the resizing function to the default template:

## @param colresizable:true
$PocketQuery.template("default")

"Load macro dynamically" has to be disabled for this to work, that's a known issue we will take care of.

Does this solve your problem? Let me know if you need further help.

Regards,

Carla

All comments

Carla Roocks (Scandio)

Hi Artashes,

This minimalistic template simply adds the resizing function to the default template:

## @param colresizable:true
$PocketQuery.template("default")

"Load macro dynamically" has to be disabled for this to work, that's a known issue we will take care of.

Does this solve your problem? Let me know if you need further help.

Regards,

Carla

artafon

Carla Hi!

thx for your reply. Could you tell me please, where is the default template?

Carla Roocks (Scandio)

If you add a new Query in the PocketQuery administration, you can set a template that is used for displaying it. Among the choices you will always find a template called "default" that is a simple table.

Have you already had a look at the templating section in the PocketQuery Documentation (the very last tab)? You will find lots of information there, including the source code of the default template (in case you want to further adjust it).

The code snippet I gave you above is also a complete and working template. Simply add it as a new template in the PocketQuery administration with a reasonable name and you can select it for your queries.

The templates are quite powerful. It's really worth having a closer look at that feature smile

artafon

You are not understood smile

So, what I do:

I added new template with code default from your site

&lt;table class="pocketquery-table confluenceTable"&gt;
  &lt;tr&gt;
  #foreach ($column in $columns)
    &lt;th class="col-$velocityCount"&gt;$!column&lt;/th&gt;
  #end
  &lt;/tr&gt;
  #foreach ($row in $result)
    &lt;tr class="#if($velocityCount % 2 !=
0)odd#{else}even#end"&gt;
    #foreach ($column in $row)
      &lt;td class="col-$velocityCount"&gt;$!column&lt;/td&gt;
    #end
    &lt;/tr&gt;
  #end
&lt;/table&gt;

Then, I need to add your code(parametr) above. Where?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration