Page Comparison

...

In the Service column, you select the service which will serve as the data source for this filter statement. In most cases, this is the service whose records the view will display. Selecting another service allows the view to be filtered by data in a related service. For example, a view showing all people who have placed orders since the beginning of the year displays records from the 'Persons' service, but the filter is based on information from the Orders service.

...

• If you select a field that uses the Datetime DateTime format from the Field drop-down list, an ellipsis (…) button appears in the Value field. Clicking this button opens a Date Selection Box.
• For the date-based filter, the use of NOW, TODAY, and GETDATE() should all retrieve the current date. You can further manipulate that by adding plus or minus a specific number of days. For example, OrderDate >= TODAY-7 will retrieve records with an order dated within the last week.
• If you select a field that has a defined list of possible values in the Field column (such as a Person's State), the Value field includes a drop-down list with these values. You can either select a value from the drop-down list or manually enter a value in the field.
• If you select a field that is linked to another service from the Field drop-down list (for example, filtering based on CompanyID in a Persons view), an ellipsis (…) button appears in the Value field. Clicking this button opens a Link Box to the related service.
• When Between is selected as the Operator of a filter statement, an ellipsis (…) button appears in the Value field. Clicking the button will display the Select a Range dialog and a user can input the appropriate range as shown below:

...

• If you select a field that has no defined list of values in the Field column, a list of the first 100 possible values may appear in the Value field. Note that these possible values are only a suggestion: Only the first 100 values appear in the list, even if the field contains more than 100 values. If the field contains less than 100 values, then all of the values appear in the list. You can either select a value from the drop-down list or manually enter a value in the field.
  • Note that this feature is designed for character-based fields. It does not apply to fields with the following data types: text, ntext, varchar(max), nvarchar(max), datetimeDateTime, or numeric.