This content has been marked as final. Show 5 replies
You would need to call the "Execute SQL query" a second time and pass the information for the second driver licence section.
Something like /process_data/xfaform/object/data/xdp/datasets/data/App/DriverLicense/drvlicstate
In my workflow, there could be different results of driver license information. Sometimes there could be one or more instances.
Are you suggesting that I will need one SQL query for every instance ? Is there a way to created a loop ?
"Something like /process_data/xfaform/object/data/xdp/datasets/data/App/DriverLicense/drvlicstate"
Just to clarify - would it be the DiverLicense or drvlicstate ? In other words, would I specify the instance on the subform or the field ?
Yes you can and will have to set up a loop in your process. Use an integer process variable as your loop increment start it at 1 (I'm pretty sure the indexing begins at 1...could be 0). You'll have to use the count() XPath function to count the number of nodes. Something like...
Compare that number with the index value to know if you've looped through every node (and inserted each, one at a time) or if you need to loop again. Email me and I'd be glad to discuss this further with you if need be. It's not as complicated as it sounds.
Hope this helps!
Ryan D. Lunka
Cardinal Solutions Group
"Just to clarify - would it be the DiverLicense or drvlicstate ? In other words, would I specify the instance on the subform or the field ?"
I think you'll need to get to use DriverLicense to get the count of how many driver licenses you have.
then you can have a loop (just a route coming back to a previous step) that get the value using something like:
You can set up a loop as described, or you can do it in a single step using the following custom component: