Skip to content

Filter Example

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

Filter ExampleDescription
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 parentOne 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 nameWhat to enter or select
    Filter name:Use of @Do in database
    Filter Active:Yes
    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:
    Filter formula

  10. Save the filter and exit.