Dynamically populate the HTML Dropdown template using pocketquery plugin in confluence

Question

Hi i am new to pocketquery and till now i just know how to write and MySQL query to read the MySql db and populate the table.I want to populate a dropdown list with the table data.

The Query to populate data is quite simple

' select distinct AccountId from Accounts ' I want the values returned by this query to be the options of select html tag (dropdown).

After the dropdown is populated i would like to select one one value and based on the selected value it will fire a query to MySql DB with selected value as input parameter the 2nd Query is something like below

'select AccountId,AccountName from Accounts where AccountId=the input parameter selected in dropdown'.

Please help me @Felix Grund (Scandio).

Former user · Answer

Hi @pmayne

very cool that you figured it out yourself and also provided the solution here for others to find! :)

Best regards,
Sven

EDIT: There's now also an example in our docs that does something very similar https://help.livelyapps.com/documentation/display/PQDOC/Query+depending+on+multiple+select+boxes

pmayne · Answer

After looking at the support desk tips I found out that I needed to add the following code as part of the form It is now remembering the pageid to submit the parameter values thanks

Former user · Answer

Hi @pmayne

could you raise a support ticket at our service desk for PocketQuery and tell me exactly what you are trying to achieve? Please also include your current template and query (feel free to censor sensitive data).

Best regards,
Sven