Hello,
I need to initialize dynamically generated list with values from SQL server in PIPA initProcess. I see that there already were several topics related dynamically generated list and SQL like this:
http://bpms.intalio.com/forums/workflow/getting-dynamically-generated-...
But I still cannot find the answer about filling of dynamically generated list during process initialization step.
In attachment is my “stub” process, with one UI form which contains only one element- combo box. I need to fill this with values from SQL database.
Anyone can help with this?
Thanks,

Oleg L.

I think that there is no solution within the Intalio XFORMS / PIPA scenario.
If you want to keep using XFORMS, then you could hack the XFORM file to give the list a src. Look at standard XFORMS guides for this ... Intalio designer will destroy any hacking you do the next time the form is opened for editing.
Alternatively use another UI approach following the TEMPO documentation. The Intalio AJAX form (at Intalio 6.0) would allow you to set the dynamic list from a URL (front your MySQL db with a web service)

David

typo corrected AJAX replaced AXIS above

You mean the _Intalio|Ajax_ framework: yes, you can do an ajax call in there to call a REST service that would give you a nice JSON list of elements fresh out of the DB to populate the combo box.

You can do the same in xform but the editor will indeed remove those elements because they are not supported by its WYSIWYG approach.

Thanks,

Antoine

Thanks, I will try this approach with Ajax framework!

Oleg

But still some example or explanation will be very helpful...

Thanks,
Oleg L.

still some example or explanation will be very helpful.For all of us!
My assumption was that the URL should return XML in the same form as the default string supplied in the property XML string of the select widget.
As I use eXist-db which provides a handy REST webservice, I provided a URL complete with an XQUERY to generate the XML

Code: :

http://demo.exist-db.org/exist/rest/db/shakespeare?_query=%3Cdata%3E{for%20$V%20in%20/PLAY/TITLE%20return%20%3Crecord%20jsxid=%22{data($V)}%22%20jsxtext=%22{data($V)}%22/%3E}%3C/data%3E

This also runs on the default distribution of exist-db from exist.org to give a list of 3 play titles

Code: :

<exist:result xmlns:exist="http://exist.sourceforge.net/NS/exist" exist:hits="1" exist:start="1" exist:count="1">     <data>         <record jsxid="The Tragedy of Macbeth" jsxtext="The Tragedy of Macbeth"/>         <record jsxid="The Tragedy of Romeo and Juliet" jsxtext="The Tragedy of Romeo and Juliet"/>         <record jsxid="The Tragedy of Hamlet, Prince of Denmark" jsxtext="The Tragedy of Hamlet, Prince of Denmark"/>     </data> </exist:result>

If you supply a url like this to the XML URL property of the select widget you will see the result displayed as the select options in the Intalioi|AJAX form design window. The outer exist:result seems to be accepted happily.
Getting this to work in real life requires getting around the javascript restrictions so I think you will need to set up proxy'ing from the tomcat webserver or running the webserver at the same location as the intalio BPMS


My assumtion was that you could also supply an XML file of the same form within the XML Documents folder of Intalio|AJAX. This also works in designer to produce an appropriate select list but does not appear to deploy the file to the BPMS server for you.

Hi Oleg,

Can you please refer to sample "http://bpms.intalio.com/samples-5.2/dynamicprocess.html" . You can get more explanation in this sample.

Hope it may helps you.

Thanks,
Sumit.

Thanks Sumit!
This example really describes how to use dynamically generated values. But If I need to fill the list it in PIPA-init element, it will not work. I need to use initProcess as extra step to create process instance. Yes, it is just one additional mouse click, but how to do it in Ajax framework, as there it is possible to fill list with dynamic values in initProcess without additional steps. As less elements on the diagram, as it looks more user friendly.

Oleg L.

A previous post of mine may have gone astray but you may get a better idea of the use of Intalio|AJAX from http://www.tibco.com/devnet/gi/getting_started.jsp
as the underlying General Interface is the same.
In your example of the INIT operation, the dynamic table can be set using the XML URL property. If the URL returns the same XML structure as the example presented in the XML string property,
the effect is identical in the designer view of the form. Unfortunately, I have not been able to get this to work in the deployed form which fails while being painted.