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

Fullscreen
1
2
3
4
SELECT filename, file_mime_type
FROM notes
WHERE notes.parent_type = 'Emails'
AND notes.parent_id = 'the email id here'
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

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:

Fullscreen
1
2
3
4
5
SELECT filename, file_mime_type
FROM notes
WHERE
notes.email_type = 'Emails'
AND notes.email_id = 'the email id here'
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

or just

Fullscreen
1
2
3
4
SELECT filename, file_mime_type
FROM notes
WHERE
notes.email_id = 'the email id here'
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

When did that change? Or is is something weird with my system/setup?

FrancescaS