I was going through "insert user" sample.Here's the link http://bpms.intalio.com/samples/fetching-values-from-an-array.html.Few things that I am not getting is how count is used with mappings?

Also,why attributes like definition, execution and count are declared in xsd file?I mean I am not sure about their functionality.

Can someone please shed light on this issue?I will appreciate it.Please bear in mind that I am new to BPMN and related technologies.

Thanks in advance.

Best Regards,
Gagan Virk

how count is used with mappings?
The process receives a set on names from the input (console) and inserts them one by one into the database. To do this, it needs to step through the set of nodes.

The BPEL code at the activity INVOKE is

Code: :

<bpel:copy>               <bpel:from>$thisReceiveRequestMsg.body/tns:name[position()=$count]</bpel:from>               <bpel:to>$processQuery1RequestMsg.parameters/Process1:execute/Process1:parameters/Process1:Name</bpel:to>             </bpel:copy>

In this, the name is passed to a parameter in the sql statement that is to be executed. The name is selected from the set by the XPATH position function using the value of the global pool variable $count as the index.

$count is initially set to the number of names in the set in the ASSIGN activity using the XPATH count() function, and reduced by 1 in the DECREMENT activity.

why attributes like definition, execution and count are declared in xsd file?
This is to do with how Intalio communicated with services (and the database is a service). The process xsd is created by intalio designer. count in the reply definition is unrelated to the $count variable it is a standard return from SQL saying how many rows were affected by the statement executed.

There are other samples introducing the use of( MySQL) databases.

Note: It is probably not a good practice to update an external database in this way in a production environment as the state of the database and the process could get out of step if there is a system failure during the execution of the loop. Inserting rows in a single statement would be safer.