Upload Multiple doc and get all docs array ids in local or ri variables

Forum|Forum|5 years ago
February 19, 2021
14 replies
0 views

Requirement: Sore uploaded docx ids array in DB column and get array to display uploaded list on UI.

1.Upload Multiple doc and get all docs array ids in local or ri variables, how to achieve? <-- 2.Is this correct approach to store multiple docx ids as array in DB column and retrieve from DB

Using Appian documentation i was able to download multiple document from an array of {docid1,docid2,docid3}

3.How to convert? from Appian multi upload stores i.e. {fn!todocument(6645),fn!todocument(7570)} to expected {6645,7570} <-- 4.How to store/retrieve this docid array in DB ? how to design DB with integer array?

5.May be I am wrong in above approach please let me know best approach to achieve above?

Best answer by carloss662

Check out the examples in the link below, particularly Multiple File Upload with Files. Also make sure to read through the Notes section.

docs.appian.com/.../File_Upload_Component.html

C

carloss662Answer

Participating Frequently

Check out the examples in the link below, particularly Multiple File Upload with Files. Also make sure to read through the Notes section.

docs.appian.com/.../File_Upload_Component.html

deepaks0008Author

Known Participant

Hi,

I used above example but not getting array with Ids - Actually getting [documentid1-documentname1,documentid2-documentname2] format list.

Expected output docIds only- [documentid1,documentid2]

I was able to download multiple file using array DocArr:{docId1,docid2}

a!forEach(
items: {6645,7570},
expression: a!linkField(
label: "Link",
labelPosition: "ABOVE",
links: {
a!documentDownloadLink(
label: document(
fv!item,
"id"
),
document:todocument(
fv!item
)
)}
)

stefanhelzle0001

Brainy

This is the way how Appian displays the data type "Document". Internally this is just an ID. Does this help?

Sign up

Login with SSO

Login to the community

Login with SSO