The following table shows examples of filters you can create. Procedures for creating them follow the table.
|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"
- Open the Auditor Filter database, which is called deanfltr.nsf.
- Click Create Filter to open the New Filter window.
From the New Filter window, enter the following
The new filter should now look like this:
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
- In the Operation field, select the RT contains option.
- In the Compare To field, enter @DO.
- In the Flag field, click the arrow to display the list.
- Select Whole Word and click OK.
Click Add Condition.
The new condition is added to the formula in the Validation Formula field:
Save the filter and exit.