Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi,
I'm trying to save multiple upload document ID to an Array Field but it turned out blank in the database.
I checked the variables and they show value but nothing has been saved
I was wondering if you have a solution for this?
Thanks,
Discussion posts and replies are publicly visible
In your DB, what is the datatype of the column? what is your structure? saving multiple rows for multiple documents or saving data into a single row. If single row, you have to use join array function to save.
datatype is integer.
saving data to single row.
I tried joinArray(ri!ID, ", ") but it shows as blank because they are not text.
you should save it to text, as join array creates a string
still it did not work. still saved as null while variable is "[Document:1012]"
Could you please share some screenshots?
taxform saved as number and ssi saved as text
user interface:
Variables from Process model:
Database:
You need to make your data structure flat. You should be saving one Doc ID per row, into a single integer field. If you need multiple documents, your logic needs to create multiple rows each referring to an individual doc ID.
Other workarounds are possible, but they're much more complicated to implement and it can't really be easily explained here if you don't already know how to pull it off anyway.
you have to use join array under save into Configuration.
I'd recommend against a joinArray() approach here, especially for anyone who's not very well versed in how to use that (and how to transform it back into an array of integers, easily). The issue is then if your value parameter relies on the save target, you need to transform that array back, and there are all sorts of null handling and exception case handling situations.