Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
4 subscribers
Views
2138 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi All, I am facing Issue while storing the Multiple Documents(Document PV
rameshm
over 8 years ago
Hi All,
I am facing Issue while storing the Multiple Documents(Document PV is Multiple) into Database.But database storing only one document.Kindly help me in resolving this issue?
Thanks
OriginalPostID-219647
OriginalPostID-219647
Discussion posts and replies are publicly visible
Parents
0
mohammedz
A Score Level 2
over 8 years ago
@ramesh
If your main table has primary key and if you want to store multiple documents id's upon it then best way is to go for nested objects.. like in your case for one order there can be 10 documents
So create a table for documents alone like Pkey,OrderId,Document_I'd etc.. details you want
And now map the corresponding documents of particular order and persist into that table , and when ever u need it you can query using ur order I'd so that it will return all 10 docs I'd
You can consider this approach as well ....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mohammedz
A Score Level 2
over 8 years ago
@ramesh
If your main table has primary key and if you want to store multiple documents id's upon it then best way is to go for nested objects.. like in your case for one order there can be 10 documents
So create a table for documents alone like Pkey,OrderId,Document_I'd etc.. details you want
And now map the corresponding documents of particular order and persist into that table , and when ever u need it you can query using ur order I'd so that it will return all 10 docs I'd
You can consider this approach as well ....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data