I used to be able to query the attachments for an given Email, by using something very similar to the query documented here:
SELECT filename, file_mime_type FROM notes WHERE notes.parent_type = 'Emails' AND notes.parent_id = 'the email id here'
However I am finding that in my Sugar Professional v11 (I know I need to upgrade) the parent_type is blank, while the email_type is "Emails".
So now the query is:
SELECT filename, file_mime_type FROM notes WHERE notes.email_type = 'Emails' AND notes.email_id = 'the email id here'
or just
SELECT filename, file_mime_type FROM notes WHERE notes.email_id = 'the email id here'
When did that change? Or is is something weird with my system/setup?
FrancescaS