Skip to main content
S
srimathig0001
Participating Frequently
April 22, 2021
Question

Getting issue on prod.

  • April 22, 2021
  • 3 replies
  • 0 views

I have to update 6rows in a table and need to create a new row with updated values in a table.

I have used query entity to fetch the data and configured in script task at output and writing into the table.but am calling same rule for 6 times to update each fields,so it may not work efficiently.can you provide me alternative way.

Thanks in advance

    3 replies

    csteward
    csteward
    Brainy
    April 22, 2021

    If you set your CDT process variable to multiple, retrieve/update all 6 rows from queryEntity, and update your Write to Datastore Entity node as multiple, you can handle all 6 rows at once.  If you have any specific questions beyond that, let us know.  

    S
    srimathig0001Author
    Participating Frequently
    April 23, 2021

    How is it possible on script task,how can i update a 6 rows at once?

    csteward
    csteward
    Brainy
    April 23, 2021

    You can retrieve and update your data via a script task, and then utilize a Write to Datastore Entity node to persist back to the DB, which can handle multiples.  Can you include screen shots / code snippets of your current configuration here?

    Terms & ConditionsAccessibility statement