Skip to main content
S
shahedj3682
October 1, 2023
Question

a!writeToDataStoreEntity

  • October 1, 2023
  • 5 replies
  • 0 views

I am trying to use a!writeToDataStoreEntity   to write to into a database , if one on the fields is a (foreign key) which is an auto-generated primary key of another table in the "same interface ", how can i pass it to the other table when it  hasn't been generated yet?   

    5 replies

    S
    shahedj3682Author
    October 1, 2023

    or i am obliged to use process models and script task?

    A
    amits0028
    October 2, 2023

    You can use a!startprocess() to first write in the first table and then use its primary key in the second table 

    mathieud0001
    mathieud0001
    October 2, 2023

    If you are using 23.2 and lower you'll need to do in with 2 writes wrapped in a Process Model called with a!startProcess. If you are on 23.3, you can simply create a nested Record type with relationships and it will take care of it for you.

    Z
    zacharym5676
    October 13, 2023

    Ok, thank you sir. I will try it and if I still face any issue, I will update you by starting my own thread. 

    rishikeshr4182
    rishikeshr4182
    October 3, 2023

    You need to do these things inside a process.

    Terms & ConditionsAccessibility statement