Using YQL To retrieve message content using either an mid or a list of mids
I was trying out YQL for ymail tables and I couldn't figure out how to get email content for a specific email using its mid or a list of content using a list of mids.
A few queries that I tried either did not return results or returning more than what it should based on the the query conditions.
1) select * from ymail.msgcontent where mids in ('mid_goes_here') 2) select * from ymail,msgcontent where fid = 'fid_goes_here' and mids in ('mid_goes_here') 3) select * from ymail.messages where mid = 'mid_goes_here' (tried in clause also). This one returns a bunch of messages
I modified the sample
select message from ymail.msgcontent where (fid,mids) in (select folder.folderInfo.fid,mid from ymail.messages where query="Yahoo" limit 1)
select message from ymail.msgcontent where (fid,mids) in (select folder.folderInfo.fid,mid from ymail.messages where mid='mid_goes_here') and it returns a bunch of messages
The mid(s) that I use are ones that I got back from "select hits.mid from ymail.search where fid='fid_goes_here' and subject in ('subject_token1', 'subject_token2',..) and date-start > value
I'm I doing this correctly or did I missed something?