Send SQL query to the database of third-party applications passing parameters from Confluence

[Vladislav Belyaev]

Hello everyone!

I want to make the user go to Confluence page and see all their open task in another system (no from Atlassian). Ideally, the query should work similarly to such a JQL query in JIRA (assignee = currentUser() AND resolution = Unresolved).

Have you met such a practice? Is there a plugin to solve this issue?

Sincerely,

Vladislav.

[Sven Schatter _Lively Apps_ · Accepted solution]

Hi @Vladislav Belyaev,

sounds very much like our app PocketQuery could be useful for you!

In PocketQuery you can define REST & SQL queries in a separated admin interface. These Queries can be executed in a page via a Macro and you can define with a Velocity templates how the results should be displayed. (Default is a simple table)

These Queries can also be parameterized and receive so called wildcards. An example could be:

SELECT *
FROM sometable
WHERE something = :@pageid

Or with REST:

/some/rest/api?user=:@username

If you have any questions about PocketQuery and/or need help with creating your query you can ask here or raise a support ticket at our HelpDesk. :)

Cheers,
Sven