Skip to main content
A
anithad
March 14, 2023
Question

How to set the array of particular value to second array particular field

  • March 14, 2023
  • 3 replies
  • 1 view

Hi All,

i have 2 tables. 1.project(id,requesttype,automationname,etc), 2.Task(id,projectid,workflowtype,etc)

Project:{ { "",test,test}, {"",test,test},{"",test,test}} 

task:{{ "","",task}, {"","",task},{"","",task}} }

for example  After write to data store entity of my project data is{ { 1,test,test}, {2,test,test},{3,test,test}} 

once project data is created i want to create the task respectively before that i want to assign the PROJECT DATA (ID) which is 1,2,3 to Task Data(PROJECTID)

finally after i write the task data into db i want my task data as: {{1,1,task},{2,2,task},{3,3,task}}

can you please help how i can set the id of project to particular cloumn in the task data

    3 replies

    S
    sanchitg0002
    March 14, 2023

    Hi [mention:b809190fb6374dbeb73b1f468c0b54e3:e9ed411860ed4f2ba0265705b8793d05],

    From the Project Write to data store entity take the output of stored values in a pv of type Project and when configuring write to Data store for Task use pv!Project.id as value for Task's projectId.

      harshitb6843
      harshitb6843
      March 14, 2023

      Or, you can also add a script between 2 write to DSEs and use it to store the project id in the task id. Use the output tab and create a custom output. 

        A
        anithadAuthor
        March 14, 2023

        Thanks Sanchit and Harshit, i used script task between the 2 DSE and set the value.. its worked now. Thanks

        Terms & ConditionsAccessibility statement