The text mode field is provided to allow searching for fields not available in the builder. Using Text Mode, will allow you to extend your filter criteria to access relationships through the “Reference Table Objects” section of the Table of Database Relationships. This enables you to filter on more criteria than the Builder Interface allows you to.
To use a relationship, you need to reference the object as identified in the Table of Database Relationships followed by a colon ( : ).
It is permissible to filter on several attributes in a single text mode filter. In this case, each carriage return is treated as an AND condition; meaning, all the conditions must be met for an item to be included in the results.