How to query the SQLite table for emails
 

Hi,

What sql can I use - without a WHERE clause - to return From, To, Date of Message, Subject and Body from the Sqlite Urd table?

I imported an mbox file into UltraRecall, which was exported from Thunderbird. The folder in Ultra Recall where all the emails start, is called emails.

You would look in the Attribute table to find the associated attributes (From, To, etc.).

Then in the ItemAttribute table for specific attribute values for a given item.

Which would be associated with the Item records for what you imported.

You could perform a JOIN on these tables based on the ItemID & AttributeID.

https://www.kinook.com/Forum/showthread.php?t=2825