Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Vladislav Belyaev February 11, 2020

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.

1 answer

1 accepted

3 votes
Answer accepted
Sven Schatter _Lively Apps_
Atlassian Partner
February 11, 2020

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

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira product discovery learning path, product discovery training, idea prioritization, align stakeholders, discovery to delivery, product collaboration, atlassian learning, dev process, roadmap planning, insight capture, team alignment

Elevate Your Skills with Jira Product Discovery!

Unlock your potential and learn how to use Jira Product Discovery to your advantage. You’ll have the expertise to revolutionize ideas and insights, roadmapping, engage and align teams and stakeholders, and deliver the best solutions—faster. Enroll today!

Start Learning
AUG Leaders

Atlassian Community Events