![]() |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
![]() |
Tags |
query , sql , sqlite |
Thread Tools | |
Display Modes | Rate This Thread |
|
|