Skip to main content
kavyam0002
Brainy
Oct 5, 2022 8:12 AM UTC
Question

for each items execute SP

here in the save contracts in header table am saving multiple contract_id to the table at a time. but SP will execute only one contract_id at a time to load the data to another table...

so i want to execute SP for all the contract_id... it can be possible using for each id SP has to execute ? if so let me know how can i achieve this 

here we can use script tasks if required. 

so i can query all the contract_ids.. but how to execute this SP for each of those items 

    3 replies

    gabriele.camilli
    Employee
    Oct 5, 2022 8:37 AM UTC

    Hi, you could use a MNI: https://docs.appian.com/suite/help/21.1/Process_Node_and_Smart_Service_Properties.html#other-tab

    But i would also consider to modify the SP so it can work directly with the list of Ids

    kavyam0002
    Brainy
    Oct 5, 2022 8:52 AM UTC

    data team is on leave today! this task has to be moved to UAT by EOD

    gabriele.camilli
    Employee
    Oct 5, 2022 9:22 AM UTC

    Then Multi Node Instances could be the way to go