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...
We have pages with a large number of pocketquery macros to display different information. All of the queries take a simple alias relating to the page. Currently we have to enter this alias as a p...
I created a query (pocketQuery) to query our JIRA database, which works fine. But I'm having issues properly gathering first and last name, instead of username's. Can anyone give me a hand with t...
I'm trying to render the Jira issues macro from within a pocketquery template and I can't get it to load/render the issue data properly. I see the Jira macro column headers (grayed out) and a s...
I want to change bar color in pocket query template which is written as below, default color is blue but i want to change as per my requirement. Please suggest. <script> PocketQuery.chart('C...
Hello. First of all: Thanks to Scandio for PocketQuery. This add-on is awesome. I´d like to setup a customer-dashboard in confluence, using multiple charts, based on some customer-data. The chart s...
I am trying to round some values in my SQL query result and table. Is it possible to use the MathTool in the pocketQuery template? I can't seem to get it to work.
...ueryName+'"]'); var dataIndex = container.data('index'); var data = PocketQuery.getDynamicLoadData(dataIndex); data.queryParameters = queryParameters; PocketQuery.load...
Hi, We're loving PocketQuery so much that the popularity is also rising. Are there any plans to allow for delegated administrators - i.e. users that have access to a subset of database and the q...
Hi, We just updated to 2.1.2 and somehow lost our existing queries. How can we get them back or roll back the update? Thanks, Boris image2016-10-27 11:37:58.png
Copied to clipboard