1. Fields

1.1. From/To/Cc/Any

An email address is expected. You may type only a part of the address and hit the space bar to autocomplete: a list of addresses containing the substring typed will then be fetched and shown in the combobox. Any means that the messages to retrieve must have that address either in a From, To, or Cc field.

1.2. Dates between

The date format expected is YYYY/MM/DD (US style) or DD/MM/YYYY (european style) depending on the current preferences. One of the minimum (lower bound) or maximum (upper bound) can be omitted to select an semi-open interval of dates.

1.3. Not older than

Use this field to retrieve only the more recent messages, with "recent" expressed as a number of days, or weeks, or months back from now.

1.4. To

an email address is expected, and autocompletion is available by hitting the space bar, as for the From/To/Cc/Any input field.

1.5. Subject

a substring that the message subject must contain. The search will be case insensitive.

1.6. Contains

a substring that the message body must contain. Be aware that the search is case sensitive.

1.7. SQL statement

This field should be used by users who know SQL and the Manitou-Mail database schema. The input has to be a sql statement that returns a list of mail_id. Example:

 SELECT mail_id FROM attachments
WHERE content_type like 'image/jpeg' and content_size>1024*1024

(that query will retrieve any message to which a big jpeg image has been attached). As with any other field of the query dialog, the result of that query will be ANDed with the other criteria.

1.8. Contains tag

The combobox lists all available tags. Selecting a tag will constrain the messages retrieved to those to which that tag is assigned. The hierarchy of tags is flattened so that child tags are expressed as parent_tag->child_tag

1.9. Status

Pressing the "More..." button will display a panel of all possible status combinations, with "Yes","No" and "Either" choices for each one. The status is a set of boolean properties (properties that can be true or false)

  • "Either" means no test will be performed on the corresponding property.

  • "Yes" means the corresponding property has to be true.

  • "No" means the corresponding property has to be false.

For example, choosing "No" for "Replied", and "No" for "Forwarded", and "Yes" to "Processed", means you want to constrain the messages to retrieve to those that have been marked as processed, but for which no reply has been issued, and that haven't been forwarded as well.

1.10. Limit To

An integral number is expected in this field. It will limit the number of messages fetched from the database to this value, even if there are more messages that match the criteria entered.

It is intended to avoid cluttering the network and/or your computer if the query hasn't been narrowed enough to retrieve a reasonable number of messages. Several thousands of messages to fetch in one go is still reasonable, but millions of messages is not (it actually depends on the throughput of the link with the database and the power of the computer running manitou-mail user's interface, though).

1.11. In trash

Only messages that are trashed will be retrieved.