Hello ,
I was going through the product training videos from the Appian Academy and I came across this trick which I wanted to show you.
Scenario : Lets say we have a table whose primary key would be a foreign key to some other table (like an Order table whose primary key will be a foreign key to Order_Items table)
In such scenario, when we insert the record in the first table (order table) , we need to extract the ID of the inserted row and we will use a script task to update the ID to the other table rows (Order_Items)
In the script task we have couple of ways to update the foreign key as suggested in the below answers
https://community.appian.com/discussions/f/process/25333/script-task-to-multiple-parameter-in-process-model
https://community.appian.com/discussions/f/new-to-appian/24905/script-task-in-process-model/98510#98510
But the trick I found is, as below. It can be found in the community edition process name : AA New Estimate (Notify)
In the script task output's custom output, they used the below expression and operator "is stored as" and the target the destination table's foreign key field.
a!forEach( items: pv!repairItem, // Order Items table expression: pv!collisionRepair.collisionrepairid // Primary key from Order table )
I have found it clean way of updating the table with foreign key. But I don't know how useful is this. Since the code is written by Appian Community, I think they will use the best code.
Any insights / suggests / corrections are always welcome.
Thanks ,
Vasu
Discussion posts and replies are publicly visible
The repeat function is another option. It repeats a value a given number of times returning a list. The result is the same, and the code is more expressive.
repeat(count(pv!repairItem), pv!collisionRepair.collisionrepairid)
Thanks Stefan for your contribution