Date: Thu, 28 Mar 2024 13:02:17 +0200 (EET) Message-ID: <722274700.991.1711623737959@wiki.vertuna.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_990_712304585.1711623737930" ------=_Part_990_712304585.1711623737930 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
We have a simple form with just one field of type "Dynamic dropd= own (database)"
Which uses a SQL like this to get the values:
select = code as id, name from somevals
In a table we have just 3 rows:
23 23
23.00 23.00
23.00.00 23.00.00
id | name |
---|---|
23 |
23 |
23.00 | 23.00 |
23.00.00 | 23.00.00 |
Typing 23 into the field will offer you the other possible choices for t= he field
values in a form so far
Dyn |
---|
23.00.00 |
23 |
23.00 |
Storage format
<ac:= structured-macro ac:macro-id=3D"02ab691f-7a29-4345-84aa-d187accd8f82" ac:na= me=3D"confiform" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">ioimTest1</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id=3D"b3bfde7a-aefa-4006-897f-60e900= a6841e" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dyn</ac:parameter> <ac:parameter ac:name=3D"fieldLabel">Dyn</ac:parameter> <ac:parameter ac:name=3D"values">select code as id, name from= somevals</ac:parameter> <ac:parameter ac:name=3D"extras">7422036e-9a6f-4455-92d9-7140= 131fb9da</ac:parameter> <ac:parameter ac:name=3D"type">dbdynamicselect</ac:paramet= er> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id=3D"60746106-054b-4aeb-a9e7-3149219d8f70= " ac:name=3D"confiform-entry-register" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">ioimTest</ac:parameter> <ac:rich-text-body> <p> </p> </ac:rich-text-body> </ac:structured-macro> <p> </p> <p>values in a form</p> <ac:structured-macro ac:macro-id=3D"8713fd28-cbf5-4a40-95c7-425ed62913ae= " ac:name=3D"confiform-table" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">ioimTest1</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id=3D"d5028632-9ae4-4201-a8e2-212689= 1c3be1" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dyn</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro>