Extracting Lyris Database Thinking

From KM4DevWiki

Jump to: navigation, search

What fields do we want?

  • subject line
  • body
  • author
  • date
  • threads

Kevin says:

A (simple) thread is not a field but a collection of messages grouped together based on the Subject: line. Full threading (where you see multi-levels -- replies to replies, etc.) is accomplished by examining the Message-ID:, In-Reply-To: and References: headers of a message and grouping them accordingly. Unfortunately, Lyris does not store this information in individual database table fields. Rather, it stores everything in a field called Headers. This is why it is difficult to derive full threading views with Lyris archives.

I can provide the first 4 fields.

Personal tools