The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Tagging attachments to a dashboard
Hello,
I have a Dashboard that has an attachment button, setup as "File Upload" to the Application Database. We want the client to be able to attach files (this part is working).
Due to the number of attachments, every file that is attached, will have to be tagged to a Text field for a specific Member. We'd like to tag multiple files on a single text line, separated by commas.
Has anyone done something similar? How did you go about this?
Thank you for your time.
As RobbSalzmann said, this doesn't seem like a good idea.
If you don't want to go to the trouble of managing a custom table, why don't you simply organise the files in folders, each folder being named after a Member? Then, instead of looking up a Text property, your code will just go to that specific folder and retrieve all the files it finds.
3 Replies
Hi FM
While you could go through the api layer to update the text value in each member every time a file is uploaded,.
This presents some risks:- the length allowed in the text field could be exceeded by the number of attachments its describing
- when files are removed, you then also have to remember and remove the bit you added to the member's text.
- you're using the hierarchy metadata-metadata to store information its not really designed for
Consider another approach that uses a custom table to index and store this information. This approach will
- be easier to implement and maintain
- perform better/faster
- not put unnecessary strain on the hierarchy
- JackLacava
OneStream Employee
As RobbSalzmann said, this doesn't seem like a good idea.
If you don't want to go to the trouble of managing a custom table, why don't you simply organise the files in folders, each folder being named after a Member? Then, instead of looking up a Text property, your code will just go to that specific folder and retrieve all the files it finds.
Thank you to the both of you, I think that I am going to go with Jack's idea and setup a business tule that does that.
