Created
January 17, 2014 23:17
-
-
Save avernet/8483487 to your computer and use it in GitHub Desktop.
Using values from checkboxes in an IN clause
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<xh:html xmlns:xh="http://www.w3.org/1999/xhtml" xmlns:xf="http://www.w3.org/2002/xforms" | |
xmlns:xs="http://www.w3.org/2001/XMLSchema" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
xmlns:ev="http://www.w3.org/2001/xml-events" | |
xmlns:xi="http://www.w3.org/2001/XInclude" | |
xmlns:xxi="http://orbeon.org/oxf/xml/xinclude" | |
xmlns:xxf="http://orbeon.org/oxf/xml/xforms" | |
xmlns:exf="http://www.exforms.org/exf/1-0" | |
xmlns:fr="http://orbeon.org/oxf/xml/form-runner" | |
xmlns:saxon="http://saxon.sf.net/" | |
xmlns:sql="http://orbeon.org/oxf/xml/sql" | |
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" | |
xmlns:fb="http://orbeon.org/oxf/xml/form-builder"> | |
<xh:head> | |
<xh:title>Untitled Form</xh:title> | |
<xf:model id="fr-form-model" xxf:expose-xpath-types="true"> | |
<!-- Main instance --> | |
<xf:instance id="fr-form-instance"> | |
<form> | |
<section-1> | |
<a/> | |
<b/> | |
<result/> | |
<run-check/> | |
</section-1> | |
</form> | |
</xf:instance> | |
<!-- Bindings --> | |
<xf:bind id="fr-form-binds" ref="instance('fr-form-instance')"> | |
<xf:bind id="section-1-bind" name="section-1" ref="section-1"> | |
<xf:bind id="a-bind" ref="a" name="a"/> | |
<xf:bind id="b-bind" ref="b" name="b"/> | |
<xf:bind id="result-bind" ref="result" name="result"/> | |
<xf:bind id="run-check-bind" ref="run-check" name="run-check"/> | |
</xf:bind> | |
</xf:bind> | |
<!-- Metadata --> | |
<xf:instance xxf:readonly="true" id="fr-form-metadata"> | |
<metadata> | |
<application-name>a</application-name> | |
<form-name>a</form-name> | |
<title xml:lang="en">Untitled Form</title> | |
<description xml:lang="en"/> | |
</metadata> | |
</xf:instance> | |
<!-- Attachments --> | |
<xf:instance id="fr-form-attachments"> | |
<attachments> | |
<css mediatype="text/css" filename="" size=""/> | |
<pdf mediatype="application/pdf" filename="" size=""/> | |
</attachments> | |
</xf:instance> | |
<!-- All form resources --> | |
<!-- Don't make readonly by default in case a service modifies the resources --> | |
<xf:instance id="fr-form-resources" xxf:readonly="false"> | |
<resources> | |
<resource xml:lang="en"> | |
<a> | |
<item> | |
<label>First choice</label> | |
<value>one</value> | |
<hint/> | |
</item> | |
<item> | |
<label>Second choice</label> | |
<value>two</value> | |
<hint/> | |
</item> | |
<item> | |
<label>Third choice</label> | |
<value>three</value> | |
<hint/> | |
</item> | |
<label>A</label> | |
<hint/> | |
</a> | |
<b> | |
<item> | |
<label>First choice</label> | |
<value>one</value> | |
<hint/> | |
</item> | |
<item> | |
<label>Second choice</label> | |
<value>two</value> | |
<hint/> | |
</item> | |
<item> | |
<label>Third choice</label> | |
<value>three</value> | |
<hint/> | |
</item> | |
<label>B</label> | |
<hint/> | |
</b> | |
<result> | |
<label>A is in B</label> | |
<hint/> | |
</result> | |
<run-check> | |
<label>Run check</label> | |
<hint/> | |
</run-check> | |
<section-1> | |
<label>Untitled Section</label> | |
</section-1> | |
</resource> | |
</resources> | |
</xf:instance> | |
<!-- Utility instances for services --> | |
<xf:instance id="fr-service-request-instance" xxf:exclude-result-prefixes="#all"> | |
<request/> | |
</xf:instance> | |
<xf:instance id="fr-service-response-instance" xxf:exclude-result-prefixes="#all"> | |
<response/> | |
</xf:instance> | |
<xf:instance id="a-in-b-instance" class="fr-database-service" | |
xxf:exclude-result-prefixes="#all"> | |
<body xmlns:secure="java:org.orbeon.oxf.util.SecureUtils" | |
xmlns:frf="java:org.orbeon.oxf.fr.FormRunner" | |
xmlns:version="java:org.orbeon.oxf.common.Version" | |
xmlns:p="http://www.orbeon.com/oxf/pipeline" | |
xmlns:fbf="java:org.orbeon.oxf.fb.FormBuilder"><sql:config xmlns:sql="http://orbeon.org/oxf/xml/sql"> | |
<sql:datasource>oracle</sql:datasource> | |
<sql:query>select count(*) c from dual where | |
<sql:param type="xs:string" select=""/> in ( | |
select regexp_substr(<sql:param type="xs:string" select=""/>,'[^ ]+', 1, level) from dual | |
connect by regexp_substr(<sql:param type="xs:string" select=""/>, '[^ ]+', 1, level) is not null | |
) | |
</sql:query> | |
</sql:config></body> | |
</xf:instance> | |
<xf:submission id="a-in-b-submission" class="fr-database-service" | |
ref="instance('fr-service-request-instance')" | |
resource="/fr/service/custom/orbeon/database" | |
method="post" | |
serialization="application/xml" | |
replace="instance" | |
instance="fr-service-response-instance"/> | |
<xf:action id="check-a-in-b-binding"> | |
<!-- React to event... on control... --> | |
<xf:action ev:event="DOMActivate" ev:observer="run-check-control" if="true()"> | |
<!-- Service to call --> | |
<xf:send submission="a-in-b-submission"/> | |
</xf:action> | |
<!-- Request actions --> | |
<xf:action ev:event="xforms-submit" ev:observer="a-in-b-submission"> | |
<!-- Get reference to initial request --> | |
<xf:var name="request-instance-name" value="'a-in-b-instance'" as="xs:string"/> | |
<!-- Copy over to read-write request instance --> | |
<xf:insert ref="instance('fr-service-request-instance')" | |
origin="saxon:parse(instance($request-instance-name))"/> | |
<!--<xf:insert ref="instance('fr-service-request-instance')" origin="instance($request-instance-name)"/>--> | |
<!-- Set values if needed --> | |
<xf:action context="instance('fr-service-request-instance')"> | |
<xf:action class="fr-set-database-service-value-action"> | |
<xf:var name="control-name" value="'a'"/> | |
<xf:var name="parameter" value="1"/> | |
</xf:action> | |
<xf:action class="fr-set-database-service-value-action"> | |
<xf:var name="control-name" value="'b'"/> | |
<xf:var name="parameter" value="2"/> | |
</xf:action> | |
<xf:action class="fr-set-database-service-value-action"> | |
<xf:var name="control-name" value="'b'"/> | |
<xf:var name="parameter" value="3"/> | |
</xf:action> | |
<!-- Setvalue actions will be here --> | |
</xf:action> | |
</xf:action> | |
<!-- Response actions --> | |
<xf:action ev:event="xforms-submit-done" ev:observer="a-in-b-submission" | |
context="instance('fr-service-response-instance')"> | |
<xf:action class="fr-set-control-value-action"> | |
<xf:var name="control-name" value="'result'"/> | |
<xf:var name="control-value" value="/response/row/c"/> | |
</xf:action> | |
<!-- Response actions will be here --> | |
</xf:action> | |
</xf:action> | |
</xf:model> | |
</xh:head> | |
<xh:body> | |
<fr:view> | |
<fr:body xmlns:xbl="http://www.w3.org/ns/xbl" | |
xmlns:oxf="http://www.orbeon.com/oxf/processors" | |
xmlns:p="http://www.orbeon.com/oxf/pipeline"> | |
<fr:section id="section-1-control" bind="section-1-bind"> | |
<xf:label ref="$form-resources/section-1/label"/> | |
<fr:grid> | |
<xh:tr> | |
<xh:td> | |
<xf:select1 id="a-control" appearance="full" bind="a-bind"> | |
<xf:label ref="$form-resources/a/label"/> | |
<xf:hint ref="$form-resources/a/hint"/> | |
<xf:alert ref="$fr-resources/detail/labels/alert"/> | |
<xf:itemset ref="$form-resources/a/item"> | |
<xf:label ref="label"/> | |
<xf:value ref="value"/> | |
<xf:hint ref="hint"/> | |
</xf:itemset> | |
</xf:select1> | |
</xh:td> | |
<xh:td> | |
<xf:select id="b-control" appearance="full" bind="b-bind"> | |
<xf:label ref="$form-resources/b/label"/> | |
<xf:hint ref="$form-resources/b/hint"/> | |
<xf:alert ref="$fr-resources/detail/labels/alert"/> | |
<xf:itemset ref="$form-resources/b/item"> | |
<xf:label ref="label"/> | |
<xf:value ref="value"/> | |
<xf:value ref="hint"/> | |
</xf:itemset> | |
</xf:select> | |
</xh:td> | |
</xh:tr> | |
<xh:tr> | |
<xh:td> | |
<xf:output id="result-control" bind="result-bind"> | |
<xf:label ref="$form-resources/result/label"/> | |
<xf:hint ref="$form-resources/result/hint"/> | |
<xf:alert ref="$fr-resources/detail/labels/alert"/> | |
</xf:output> | |
</xh:td> | |
<xh:td> | |
<xf:trigger id="run-check-control" bind="run-check-bind"> | |
<xf:label ref="$form-resources/run-check/label"/> | |
<xf:hint ref="$form-resources/run-check/hint"/> | |
<xf:alert ref="$fr-resources/detail/labels/alert"/> | |
</xf:trigger> | |
</xh:td> | |
</xh:tr> | |
</fr:grid> | |
</fr:section> | |
</fr:body> | |
</fr:view> | |
</xh:body> | |
</xh:html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment