Adding decimal number restrictions

Decimal number restrictions limit search and filter results to items that do or do not contain numbers inside or outside of a specified range. For example, you can create a restriction to find items with 2.5 hours or less in the Estimated Effort field for the Estimate workflow event.

1. Click Add on the Add Filter, Edit Filter, or Advanced Search dialog box.

2. Select a field from the Restrict by list. The options change based on the selected field.

3. If you are adding a restriction to a filter, select Prompt for restriction information at run time to prompt for criteria when the filter is applied.

If this option is selected, you are prompted to enter or select criteria when applying a filter to a list, generating a report that uses the filter, applying a view that uses the filter on a list, or applying the filter when adding items to a link.

You may want to select this option if the restriction information changes frequently so you do not have to edit the filter. The restriction information you enter in the filter is used by default. See Selecting interactive filter criteria.

4. If the restriction is for a workflow event, select the Event to search.

  • First searches only the first instance of the event.
  • Last searches only the most recent instance of the event.
  • All searches all instances of the event.

5. Select an option to indicate how to search for the range entered in the restriction.

  • Is within the range searches for items that contain the numbers in the range.
  • Is not within the range searches for items that do not contain the numbers in the range.

6. Enter the range of numbers to search for in the From and through fields.

To search for matches less than the value in the through field, leave the From field empty. To search for matches greater than the value in the From field, leave the through field empty.

7. Click Add to add additional restrictions.