Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
Replies
2 replies
Answers
1 answer
Subscribers
8 subscribers
Views
2223 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We have requirement of storing multiple CDTs in one transaction, But id of the t
ajinkyab277
Certified Lead Developer
over 8 years ago
We have requirement of storing multiple CDTs in one transaction, But id of the the cdt1 is foreign key in cdt 2 and id of the cdt2 is foreign is cdt3
e.g
Tables
Permit
-------------
permitId
permitName
PermitStatus
--------------
permitStatusId
permitId
PermitStatusTypeId
PermitStatusState
------------------
permitStatusStateId
permitStatusId
permitStateTypeid
The options I have thought are
1. Create a Nested CDT
Permit
--PermitStatus
--PermitStatusState
Cons:- Nested CDT structure is not recommended as per best practices
2. Use of store procedure
Cons:- Need to maintain extra CDT for store proc, will loose CDT benefits.
Is there any other best way so that i can achieve this.
OriginalPostID-153073
OriginalPostID-153073
Discussion posts and replies are publicly visible