You are viewing limited content. For full access, please sign in.

Question

Question

insert data only inserting the first field in a collection

Workflow
Updated March 3, 2023
asked on March 3, 2023

Could someone please tell me what I'm missing in my workflow. I'm able to update one table with a new project, however I need to insert into related table with the name of the project from the new project and items selected from a drop-down menu located in a collection. The second insert to the 'project-scope' table works however it only updates with the first item in the collection. The goal is to add multiple rows to the 'project-scope' table with the same project name. 

0 0

Replies

replied on March 3, 2023

Are you running a For Each activity to go through the rows in your data set? Can you post screenshots of your activities so far?

0 0
replied on March 3, 2023

Thank you for your response. This post the first line in the collection, but not the other selections. The first Insert Project inserts the new row in the sql table. The next insert, 'Insert Scope of Project into Project_Scope tbl' inserts the new row and one selection from the collection. 

First table - Project has a Project Name field (primary key)

2nd table - Project_Scope has Project Name field (foreign key) and then a Scope column. 

0 0
replied on March 3, 2023

I should have added I tried adding the "For Each Row" activity after "Retrieve Business Process Variables 2" but received an error message there was no activity to select. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...