Search terms in simple search query

Only the following search fields are candidates for SQL queries:

◆ Date

◆ Entry ID

◆ Item Type

◆ Platform Type

◆ Sensitivity/Mood

◆ Has Attachments

◆ Size

When performing queries using the Size search field, search results can differ

depending on whether SourceOne performs a SQL or a FTI query. For SQL queries,

SourceOne considers the parent message size but not the size of an embedded

message. When performing FTI queries, SourceOne considers both the parent

message size and the size of an embedded message.

For example, consider the following scenario:

• Search criteria is Size > 10000.

• In the dataset, a parent message exists with an attachment that is an embedded

message. Attributes are as follows:

– Parent message size is 2500 bytes.

– Embedded message size is 15000 bytes.

For SQL queries, the parent message does not appear in the search results because

the message size of 2500 is < 10000.

For FTI queries, the parent message appears in the search results because the

embedded message size of 15000 is > 10000.

◆ Owner

◆ Sender when selected from address book only

◆ Recipient when selected from address book only

◆ Sender or Recipient when selected from address book only

Using any other search fields results in a FTI query.