FORUMS


Discussion about Intalio|BPP Community Edition.


Back to General Questions (0 viewing) 
Go to bottom Favoured: 0
TOPIC: Re:HowTo use dynamically generated list in initProces
Apr 1, 2009 10:06 pm
9 posts
Fresh Boarder

Karma: 0  
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.
File Attachment:
File Name: ListFromSQL.zip
File Size: 24454
 
  The administrator has disabled public write access.
Apr 2, 2009 12:33 am
dfrench (User)
367 posts
Platinum Boarder

Karma: 14  
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
 
 
Last Edit: 2009/04/02 00:58 By dfrench.
  The administrator has disabled public write access.
Apr 2, 2009 12:53 am
Antoine (Admin)
2745 posts
Admin

Karma: 56  
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
 
 
Intalio, The Enterprise Cloud Company
www.intalio.com
  The administrator has disabled public write access.
Apr 2, 2009 10:55 am
9 posts
Fresh Boarder

Karma: 0  
Thanks, I will try this approach with Ajax framework!

Oleg
 
  The administrator has disabled public write access.
Apr 2, 2009 2:20 pm
9 posts
Fresh Boarder

Karma: 0  
But still some example or explanation will be very helpful...

Thanks,
Oleg L.
 
  The administrator has disabled public write access.
Apr 5, 2009 5:59 am
dfrench (User)
367 posts
Platinum Boarder

Karma: 14  
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.
 
  The administrator has disabled public write access.
Apr 6, 2009 8:42 am
sumit.taneja1 (User)
42 posts
Senior Boarder

Karma: 0  
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.
 
  The administrator has disabled public write access.
Apr 6, 2009 11:54 am
9 posts
Fresh Boarder

Karma: 0  
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.
 
  The administrator has disabled public write access.
Apr 6, 2009 10:31 pm
dfrench (User)
367 posts
Platinum Boarder

Karma: 14  
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.
 
  The administrator has disabled public write access.
Go to top Post Reply
get the latest posts directly to your desktop

Upcoming Trainings

More Trainings...

Upcoming Webinars

More Webinars...

Top Posters

Last 30 days

  • Antoine (135)
  • himar.rodriguez (9)
  • german.santana (8)
  • kevin.fernandez (8)
  • ddd.m123 (8)
  • lars.roediger (6)
  • gayatri.chandak (5)
  • jal1967 (5)
  • rune.lindvig (4)
  • iakovos.karakas (4)

All time

  • Antoine (2745)
  • Shivanand (1194)
  • cshekhar (933)
  • psq (797)
  • metabyte (415)
  • jag (393)
  • dfrench (367)
  • arnaud (329)
  • jalateras (325)
  • talita.pezzi (253)

Show last 4 hrs - 12 hrs - 24 hrs

Copyright © Intalio, 1999-2010.