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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

77 views 0 5
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