Gmail User's Guide | ||
---|---|---|
<<< Previous | Writing Vfolder Queries. | Next >>> |
Gmail uses two tables to store emails. Why two? Because one is fixed length for fast access, and the other contains data which is variable in length.
The fixed length table is called 'display', the vfolder usable fields are: date, subject, fromfield, readstatus (Read, Unread, Sent or Queued), direction (Incoming or Outgoing).
The other table is called 'details', the vfolder usable fields are: headers (all the headers from the email), message (the body of the email), tofield, ccfield, bccfield, attachments (not in use yet).
Of course there are other fields that are for internal gmail use, if you want to know what they are you can find out yourself!
Experiment with vfolders. You can do very powerful things with them. You can nest any level of round brackets. If you have a bad query, gmail will output your query with the database error message in a popup window.
With a little experimentation you will get the hang of writing vfolders. Remember that vfolders are not mailboxes. All your mail is always in one big mailbox. Vfolders are simply different ways of viewing that mailbox. Vfolder views can have overlapping messages. This is a very powerful way of arranging email!
<<< Previous | Home | Next >>> |
Writing Vfolder Queries. | Up | More complex vfolder queries. |