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.