We have HTML page that displays some of the information from a parent table and

venkataa over 11 years ago

We have HTML page that displays some of the information from a parent table and a child table in a data repository. There is one to many relationship between those two tables.

The end user using the HTML page can edit the information displayed and save to the data repository. On clicking Save button, the HTML makes AJAX call to invoke web service exposed by the process model in Appian. We chose AJAX call as the HTML page displays lot of other information which we do not want to post it back to the server and refresh the screen.

The web service process model is supposed to save the information into parent table and in child table. We would like to save this information by splitting into multiple stored procedure calls - one call to save into parent table, and multiple call to save into child table. As Appian allows a maximum of 99 activities in a process model, we are not able to loop through each row to be saved in child table.

Appian Ver...

Discussion posts and replies are publicly visible

0 venkataa over 11 years ago

...sion: 6.6.1

Please suggest us the best approach solving the above problem description.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 venkateshr over 11 years ago

Hi - what is the 99 activities in a process model you are referring to?

You could consider the option of using sub-processes and also batching your inserts into the child table (i.e. using the write to data store node to insert multiple records in one node)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel