Add as many details as possible, by providing details you’ll make it easier for others to reply
Solved
Attachments in database structure assyst 11.8
Best answer by Caroline Schaffner
Hello Lloyd,
The table’s name in assyst is ole_items
This table is generally the largest table in any assyst database in terms of the sheer size of data. It stores all images and attachments for all the record types in assyst. Most records on most other tables can be associated with one or more files known as attachments.
Bare i mind that assyst has the option to have attachments stored either in the Database, or separately from the database in Azure BLOB Storage. If you are using assyst version 11.8 have a look at the following: Installation:assyst Server Required Services - assyst11-8Wiki
Best Regards,
Caroline
@lloyd1306 - what exactly is your question here?
Apologies not sure whats happened there but looks like the body of my questions isnt there! Basically which tables are the item attachments info held, I just need to the names of attachments on an item.
Thanks
Please send IFS Cloud release details and a possibly a screen shot of the screen(s) where items are viewed to help the Community give a more helpful response.
Hello Lloyd,
The table’s name in assyst is ole_items
This table is generally the largest table in any assyst database in terms of the sheer size of data. It stores all images and attachments for all the record types in assyst. Most records on most other tables can be associated with one or more files known as attachments.
Bare i mind that assyst has the option to have attachments stored either in the Database, or separately from the database in Azure BLOB Storage. If you are using assyst version 11.8 have a look at the following: Installation:assyst Server Required Services - assyst11-8Wiki
Best Regards,
Caroline
Hello Lloyd,
The table’s name in assyst is ole_items
This table is generally the largest table in any assyst database in terms of the sheer size of data. It stores all images and attachments for all the record types in assyst. Most records on most other tables can be associated with one or more files known as attachments.
Bare i mind that assyst has the option to have attachments stored either in the Database, or separately from the database in Azure BLOB Storage. If you are using assyst version 11.8 have a look at the following: Installation:assyst Server Required Services - assyst11-8Wiki
Best Regards,
Caroline
That’s great thank you for this.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.