Where is Image field data stored

We have a custom module ProductClass, this stores information about our products and we are using this to pull information to our support site. As we want to use this data across multiple sites I have been asked to add some additional fields. One if these was a image field to store a picture of the device

I amended the api call to extract this data but the field itself just contained an ID

I cannot find where this id then refers to get the image data, I thought it might create a record in documents but cant find any record with that ID

Can anyone help with where sugar stores images using the image field, tried googling it but all that i can find is images as note attachments

Parents

0 Maryam Aslam over 4 years ago

Hi John,
I think you have found your answer by own. Whenever an image uploads in sugar a GUID is generated and inserted in the image column and the original image is in the ./upload directory with the same GUID.
Follow this to know, which type of files upload where and how https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.0/Architecture/Uploads/
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 john Fieldsend over 4 years ago in reply to Maryam Aslam

hi Maryam Aslam, sorry i meant how does sugar know what this file then is so that it can open the file again or so the file can be downloaded from sugar. When a file is attached to a note the attributes of the file, such as filename and file_mime_type, will be stored in the note record so trying to find where these attributes are stored when you upload a file using the image field
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 john Fieldsend over 4 years ago in reply to Maryam Aslam

hi Maryam Aslam, sorry i meant how does sugar know what this file then is so that it can open the file again or so the file can be downloaded from sugar. When a file is attached to a note the attributes of the file, such as filename and file_mime_type, will be stored in the note record so trying to find where these attributes are stored when you upload a file using the image field
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Maryam Aslam over 4 years ago in reply to john Fieldsend

According to my understanding when we attach some file in Sugar then Sugar want to know its type and file name and it get stores in the filename, file_mime_type, and file_ext fields, but when the field type is already Image then there is no need to store its type information.
That is why when field type already defined Image in Studio then no need to store side information by assuming that it must be image file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel