I'm trying to store array of files in database since it does not picks blob as a datatype any work around would be much appreciated.
Discussion posts and replies are publicly visible
May I ask why you're trying to store the files in the database, and not within an Appian folder?
I am trying to make a helpdesk system to track record of complaints in order to track I would require user to upload some sort of files and for each file uploaded should be added to the database so I can track which user raised what issue along with the file uploaded
To achieve this use case, you don't need to store the file in the database. As Harshit has indicated, store the file in an Appian folder, and store the Appian Document ID along with the complaint details in the database.
the user is able to upload multiple doc how am I suppose to upload multiple doc id in the db for each user associated with the doc. I know I am a beginner and I might sound stupid right now but any help will be much appreciated.
You can create another database table for storing document IDs that also has a foreign key for storing the complaint ID. This will allow you to establish a one-to-many relationship between the 'Complaint' database table and 'Complaint Documents' database table.