...
ConfiForms Form Definition | ||
---|---|---|
| ||
|
"Dependency" is defined using "ConfiForms Field Definition Rule" with action to filter choices
...
Code Block |
---|
<ac:structured-macro ac:macro-id="14859127-f36f-4e7f-9de8-219a6790b6e3" ac:name="confiform" ac:schema-version="1"> <ac:parameter ac:name="formName">f1</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="fdff034e-b509-4a3f-ae55-ed872aa6d0be" ac:name="confiform-entry-register" ac:schema-version="1"> <ac:rich-text-body> <p> </p> </ac:rich-text-body> </ac:structured-macro> <p> <ac:structured-macro ac:macro-id="2da9717f-57f5-4eda-9670-57123708c625" ac:name="confiform-field-definition" ac:schema-version="1"> <ac:parameter ac:name="fieldName">category</ac:parameter> <ac:parameter ac:name="fieldLabel">Contractor Category</ac:parameter> <ac:parameter ac:name="values">SELECT id, name FROM contractor_categories</ac:parameter> <ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter> <ac:parameter ac:name="type">dbselect</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="415940f1-d144-445d-9b72-9821d0310930" ac:name="confiform-field-definition" ac:schema-version="1"> <ac:parameter ac:name="fieldName">subcategory</ac:parameter> <ac:parameter ac:name="fieldLabel">Contractor Sub Category</ac:parameter> <ac:parameter ac:name="values">SELECT id, name, contractor_categories_id FROM contractor_subcategories</ac:parameter> <ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter> <ac:parameter ac:name="type">dbselect</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="d6b863fc-69cb-45e3-bbeb-5c76578158f7" ac:name="confiform-field-definition-rules" ac:schema-version="1"> <ac:parameter ac:name="fieldName">subcategory</ac:parameter> <ac:parameter ac:name="values">contractorcategoriesid:[entry.category.id]</ac:parameter> <ac:parameter ac:name="action">Apply Filter on a field</ac:parameter> <ac:parameter ac:name="actionFieldName">category</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> |
Optional example, where we show the same form, but the SQLs used have "as" operators and the name of the fields are chnaged in the resulting dataset. Therefore the field definition rule is changed as well. See below
Code Block |
---|
<ac:structured-macro ac:macro-id="14859127-f36f-4e7f-9de8-219a6790b6e3" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="fa517b7f-eabf-4755-bfa2-c3fce043bcc4" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:rich-text-body>
<p> </p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="b2f153ba-f8ac-455b-b63b-ea07252f149a" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">category</ac:parameter>
<ac:parameter ac:name="fieldLabel">Contractor Category</ac:parameter>
<ac:parameter ac:name="values">SELECT id as "myid", name as "myname" FROM contractor_categories</ac:parameter>
<ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter>
<ac:parameter ac:name="type">dbselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="77520462-dc4e-44d5-94f0-19fce73e80db" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">subcategory</ac:parameter>
<ac:parameter ac:name="fieldLabel">Contractor Sub Category</ac:parameter>
<ac:parameter ac:name="values">SELECT id, name, contractor_categories_id as "subcatid" FROM contractor_subcategories</ac:parameter>
<ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter>
<ac:parameter ac:name="type">dbselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="229b7d63-5896-4b43-b1ec-c06adfdc2a3f" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="fieldName">subcategory</ac:parameter>
<ac:parameter ac:name="values">subcatid:[entry.category.id]</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="actionFieldName">category</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro> |
...
The query for second dropdown is chnaged like this:
Code Block |
---|
SELECT id, name, contractor_categories_id as "subcatid" FROM contractor_subcategories |
Renaming "contractor_categories_id" to "subcatid"
Apply filter definition rule is changed as well to follow the rename
Code Block |
---|
subcatid:[entry.category.id] |
Code Block |
---|
<ac:structured-macro ac:macro-id="14859127-f36f-4e7f-9de8-219a6790b6e3" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="fa517b7f-eabf-4755-bfa2-c3fce043bcc4" ac:name="confiform-entry-register"
ac:schema-version="1">
<ac:rich-text-body>
<p></p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="b2f153ba-f8ac-455b-b63b-ea07252f149a" ac:name="confiform-field-definition"
ac:schema-version="1">
<ac:parameter ac:name="fieldName">category</ac:parameter>
<ac:parameter ac:name="fieldLabel">Contractor Category</ac:parameter>
<ac:parameter ac:name="values">SELECT id as "myid", name as "myname" FROM contractor_categories</ac:parameter>
<ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter>
<ac:parameter ac:name="type">dbselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="77520462-dc4e-44d5-94f0-19fce73e80db" ac:name="confiform-field-definition"
ac:schema-version="1">
<ac:parameter ac:name="fieldName">subcategory</ac:parameter>
<ac:parameter ac:name="fieldLabel">Contractor Sub Category</ac:parameter>
<ac:parameter ac:name="values">SELECT id, name, contractor_categories_id as "subcatid" FROM
contractor_subcategories
</ac:parameter>
<ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter>
<ac:parameter ac:name="type">dbselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="229b7d63-5896-4b43-b1ec-c06adfdc2a3f" ac:name="confiform-field-definition-rules"
ac:schema-version="1">
<ac:parameter ac:name="fieldName">subcategory</ac:parameter>
<ac:parameter ac:name="values">subcatid:[entry.category.id]</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="actionFieldName">category</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro> |
...