I used to be able to query the attachments for an given Email, by using something very similar to the query documented here:
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'
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'
or just
Fullscreen
1
2
3
4
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