Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 09-04-2024, 12:09 PM
URExplorer URExplorer is online now
Registered User
 
Join Date: 10-30-2014
Posts: 38
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.
Attached Images
 
Reply With Quote
  #2  
Old 09-04-2024, 10:11 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
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
Reply With Quote
Reply

Tags
query , sql , sqlite


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 09:21 PM.


Copyright © 1999-2023 Kinook Software, Inc.