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.