In this quick demo we show how to access other fields your database query returns together with the data for your dropdown field
Which uses a SQL like this to get the values:
select id, name, link from CD_DEMO |
In a table we have just 3 rows and we return 3 columns:
id | name | link |
---|---|---|
1 | ConfiForms add-on for Confluence | https://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.confiform/server/overview |
2 | ConfiDoc add-on for Confluence | https://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.confirest/server/overview |
3 | Smart Templates & Pages nice app | https://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.smart-templates/cloud/overview |
values in a form so far
Storage format
<ac:structured-macro ac:macro-id="0ce974b8-3d3e-4a91-9b95-4b93c50f67d8" ac:name="confiform" ac:schema-version="1"> <ac:parameter ac:name="formName">cddemo1</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="c3d7a641-7ff5-4ae2-8a3b-770ea93acad1" ac:name="confiform-field-definition" ac:schema-version="1"> <ac:parameter ac:name="fieldName">choice</ac:parameter> <ac:parameter ac:name="fieldLabel">Make a choice</ac:parameter> <ac:parameter ac:name="values">select id, name, link from CD_DEMO</ac:parameter> <ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter> <ac:parameter ac:name="fieldDescription">Select the plugin</ac:parameter> <ac:parameter ac:name="type">dbselect2</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <p>values in a form so far</p> <ac:structured-macro ac:macro-id="d8cf6cfa-59da-467c-8540-cb103e04895b" ac:name="confiform-table" ac:schema-version="1"> <ac:parameter ac:name="formName">cddemo1</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="c9b1c589-4659-4da4-824b-269f8e237caa" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">choice</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="64ec846a-4321-4d92-8ffe-74e2d5af7e6c" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="overrideLabel">Show the link</ac:parameter> <ac:parameter ac:name="fieldName">choice.link</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> |