Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.
×I have 2 project "NOT"AND "CH" In "NOT" project we have "Non Software" as issue type and in "CH" project we have "RC","CRB". Here in "CH" project "RC" is linked to "CRB" with link type "is fixed by...
We've just migrated our on premise Confluence server content to the cloud version, and our PocketQuery templates don't work anymore. We were taking the results of a query which produces a list of T...
Hello, there something wrong with our Confluence and PocketQuery plugin. When I go to PocketQuery -> Queries -> edit one and approve by OK, it dissapears after refresh whole site....
Hi, I need help (: my company uses PocketQuery. I created six really simple "selects". Each of them I put into six tabs on one page. Each of them uses the same table, just different columns....
We have the following template working with a single value in the "Computers" column, such as "C01". However, sometimes the Computers column contains more than one computer, such as: C01, C02 ...
...he number of answers "rarely", "always", "never" and enter them in a table (frequency table) (should be possible with PocketQuery) A pie chart is generated based on the frequency table I would b...
Currently it is possible to restrict the use of PocketQuery queries to specific spaces by specifying the space keys with the query. However, if the list is left empty the query will be allowed in a...
...n our organization. We set up integration with other systems via the PocketQuery for Confluence (PQ) plugin. PQ is well suited for these needs. It helps conveniently configure connections to d...
...he marketplace. Take PocketQuery by Lively Apps, for example. You can quickly create reports using your most accurate company data on any given topic. The great advantage is that the reports w...
I would like to check who created some queries in Confluence, is this information stored somewhere in Confluence database?
I'm having an issue where I'm using PocketQuery to render a Google Chart using a custom template. It works great in Confluence pages by itself. However, if I try to place the PocketQuery m...
I've been looking around documentation for PocketQuery to find information on dynamic parameters using REST API queries but I can only seem to find examples for SQL queries. What I would like to do i...
I have the following pocketquery template that is derived from the "default form template" discussed here: https://help.scandio.de/documentation/display/PQDOC/Default+PocketQuery+Templates My c...
Hi all, I'm writing an user macro (mymacro) which is using another macro (pocketquery) Pocketquery is a macro, which gets data via rest services from another server. In my case, the macro gets d...
I am running a query with single quotes in the select and it is not working in Pocket Query. This is the query: SELECT LEFT(c.title,(position('.' IN c.title)))||'pdf' as "document", ct.creationda...
Hi, I try to change a format number in the converter with toLocalString() function : number.toLocalString('fr-FR'); But there is no effect on the display number on my page... Anybody knows what c...
Hi, I'm able to do a "REST Basic" query in Jira and to display an array in my Confluence page using default template. But now I can't create filters on columns : - I would like to filter t...
Hello, I need to create a template in Pocket Query using the line chart from Google charts with multiple series (in fact 34 series). So, I have a query that results a table with 3 columns and...
I am new to PQ, and I think what I want to do is achievable, but I am struggling to make heads or tails of the best way to do this. Basically, I have an initial query, query1, on a page, http://conf...
We are creating graphs in Confluence using PocketQuery. On some pages, we don't display the tabular data, just the graph. However, if you inspect the source, you can see all of the json inside t...
Is it possible to parse html code into a table? I have the following SQL response Page Name <p> Backend Version: 8.0.0 <br />Frontend Version: 8.0.0 <br />Program Ove...
When using pocketquery plugin and open datasource section all configured datasources including usernames passwords are plainly visible when viewing "page source". &n...
We are currently testing PocketQuery - and as I am no SQL Expert i am hoping to get some help here. I am trying to achieve two things Create a list of all Confluence Spaces with these d...
Been trying to call a PocketQuery query from within a User macro, just can't get to work The reason why I want to use a User macro is because I can't parse all the parameters to the query a...
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...
Copied to clipboard