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
5 subscribers
Views
2013 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 7 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
0
brettf
over 7 years ago
Check the write to datastore node. Is the node input for your documents set to be multiple?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kumaraveln
over 7 years ago
I am not sure how you are document object into dB as apian does not support doing that. But anyways the most common mistake we do is missing to define the activity class variable in write to data store node as multiple. In such cases, only the first value from array will be copied into dB
Please check it and if the issue still exist share a screenshot of your node input mappings
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
weronikak6206
Certified Lead Developer
over 7 years ago
@kumaraveln Just as an aside, when you save a document object to the database, it is the document id that is saved to the corresponding db integer field
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Karthik
over 7 years ago
You can get the list of document ids from the array of documents and store it as comma saparated values in a table's column of type varchar
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mohammedz
A Score Level 2
over 7 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