How hard would it be to change it where a user would be able to insert a select statement straight from the view page instead of in edit mode?

Currently I am trying to find a macro that is like a live search but searches a database and then displays the results. So for example when a user enters a space in confluence and selects our Element Data Dictionary page I want them to be able to enter a statement such as select element_name from element where element_date = 'February' then on submit the results will be listed.

2 answers

1 accepted

In the Play SQL macro, click on the red cell on the top left:

And an SQL panel appears to edit the SQL, right within the View Page, with the same options as in the editor. See the documentation page The Red Cell, Leo for details.

This is exactly what I ws needing. For our current database setup we wanted users to be able to quesry their own leements so that they could get a definition of what the element is. For example if a user was curious about Lease_Number and wanted a more defined explination they would enter the query and it will be displayed for them.

This is a great plugin and I highly recommend it

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Oct 31, 2018 in Marketplace Apps

Marketplace Spotlight: Zephyr

Hello Atlassian Community! Each month, we run a series of Spotlights to highlight Marketplace vendors and apps that our team thinks this Community would find valuable. In last month's Spotlig...

413 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you