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?

[Marsha Dorsey]

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.

[Adrien Ragot 2 · Accepted solution]

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.

[Marsha Dorsey]

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

[Bob Swift OSS (Bob Swift Atlassian Apps)]

How to use Confluence for Business Intelligence and Reporting - specifically #5 and the Run macro