How to query the SQLite table for emails

[URExplorer]

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.

[kinook]

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