Database Connection SQL parameters

[Stefano Falasca]

Hi, is possible use a paramater variable to add into SQL Query. For example:

select * from Customers where Code='{variable}'

and define variable from something into page or space of confluence. I've several query, with a condition field is equal for all, I'd like define this variable into space confluence and use it into SQL.

Is possible ?

[Scott Selberg]

Hi, are you trying to have a confluence page where there is a form element (text input, dropdown) that users can select that then gets passed into the query?

[Scott Selberg]

Waiting for customer response.

[Winfried Mühl]

Hi Scott,

at the Goettingen State and University Library we are using Confluence 6.12 as an intranet wiki instance. I’m just testing the Keysight Database Connector, espacially the Database Query Macro and it works fine! Thanks a lot for this!

But, as you suggest in your comment, we would appreciate it very much if it would support more interactive use by users that are not familiar with database SQL queries! Choosing an item from a text input or better drop down form (with data input from an appropriate database query) and using this item as a variable in the SQL query of the Database Query Macro would be very fine!

Do you have any idea for a solution or even dev ressources to support our wish? (sorry, and this for free, as our budget is rather small …)

Best wishes

Winfried