Filter Example

The following table shows examples of filters you can create. Procedures for creating them follow the table.

Filter Example	Description
Search for static text	You can search your database for instances of a particular @Function such as @Do. To do this, create a filter that searches for @Do using the TMSRTContains formula. Use whole word matching, or the search result will include other functions that begin with @Do, such as @Doc, @DoChildren, and @DocFields.
Search for values included within an analysis document	To meet corporate standards, you must find and correct all the forms that do not include their name in the window title. To do this, you would likely pass the form name to the TMSRTContains function using a formula such as TMSRTContains( ffrmWinTitle; 0; "Memo"), where "Memo" is a particular form's name. However, you want to find all such forms, not just "Memo." To search for all such forms, pass the field name that contains the title of the form instead of a literal string of the form name. You can then apply this filter to all forms, not just a particular form.
Use values from the parent	One of your company's standards is that field names must start with form aliases. You can create a filter that shows all the fields in a document, where field names do not start with the alias of the form/subform they reside in.

Create a filter that searches for "@Do"

1. Open the Auditor Filter database, which is called deanfltr.nsf.
2. Click Create Filter to open the New Filter window.

3. From the New Filter window, enter the following
   

   Field name	What to enter or select
   Filter name:	Use of @Do in database
   Filter Active:	Yes
   Severity:	Medium
   Filter Class:	Generic Filters
   Comment:	Look for the use of @Do
   Apply To:	All

   The new filter should now look like this:

4. In the Property field, click the arrow to display the list. Then select the keyword All Code (Formula / LS / JavaScript).

5. In the Operation field, select the RT contains option.
6. In the Compare To field, enter @DO.
7. In the Flag field, click the arrow to display the list.
8. Select Whole Word and click OK.

9. Click Add Condition.
   The new condition is added to the formula in the Validation Formula field:
   

10. Save the filter and exit.