The menu items in the Add Filter screen are used to generate a SQL WHERE clause. You may wish to enter this clause directly, rather than have it generated for you.

Before you enter a where clause directly, you should make sure the configuration parameter show_sql is turned on, then study the sql statement that appears the bottom of the appropriate browse screen (e.g. tasks or faqs).

To make the most effective use of this feature, use this screen to create a "throwaway" filter that is close to what you are looking for. After you add the filter, copy the where clause from the SQL text at the bottom of the browse screen. Then paste that text here and edit to suit your needs.

Do not include the word "where" in the WHERE clause.