• State Not Answered
  • Replies 4 replies
  • Subscribers 7 subscribers
  • Views 5015 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Process

Process Model Question and Output View

allynj

We have created a single process Model. We have two Data Type Entities (T_Proposals and T- Users). In this process model, we would like to Link the two Data Type Entities. In the Data Type Table, We have establish a Primary Key in the Proposal and a Primary Key for the Users. Each is represented as a Foreign key in each table. We have tried to use Multiple data store, we have tried to create two data stores and even tried using a sub process. Unfortunately, we have not been able to accomplish this task. Please advise

 In the end the goal is to be able to pull information from the Proposals and the Users into one report or to be able to show User Information on the Proposal  Record Summary View. 

 

Hope this explanation is clear. 

 

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 2
    Hi,
    As per my understanding. U have a two tables :
    1. T_Proposals has a primary key and Foreign Key
    2. T- Users has a primary key which is Foreign key of T_Proposals.
    if this is the case, i believe the write to multiple data store entity will not work since it will through a foreign key constraint on T_proposals.
    What u need to do is user write to data store entity and persist T_USers you will get a primary key. Now map that primary key into T_proposals foreign key and try to persist to using write to data store entity.

    Please let me know if my understanding is correct.
Reply
  • 0
    A Score Level 2
    Hi,
    As per my understanding. U have a two tables :
    1. T_Proposals has a primary key and Foreign Key
    2. T- Users has a primary key which is Foreign key of T_Proposals.
    if this is the case, i believe the write to multiple data store entity will not work since it will through a foreign key constraint on T_proposals.
    What u need to do is user write to data store entity and persist T_USers you will get a primary key. Now map that primary key into T_proposals foreign key and try to persist to using write to data store entity.

    Please let me know if my understanding is correct.
Children
No Data

© 2024 Appian. All rights reserved.