query for email attachments not as documented?

I used to be able to query the attachments for an given Email, by using something very similar to the query documented here:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_11.0/Architecture/Uploads/#Email_Attachments

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

Parents Reply Children
No Data