SourceOne Email Management - How to Force SourceOne Web search to run SQL searches and not Full Text Index

SourceOne Search performs searches using either SQL or full-text index (FTI) queries. If content is archived to folders without indexing (Enable Indexing checkbox on the New Archive Folder page is clear), then a FTI search may not find items in those folders.
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:

1. Parent message size is 2500 bytes.
2. 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. 

See the SourceOne Search User Guide chapter: SQL or full-text index queries for further information