Working with Dataspies

A Dataspy is a named, predefined view of a list of records that can be used on any page, lookup, or data area that contains that same list of records. A Dataspy consists of these four basic components:

• Filter: Contains the conditional statements that make up a filter. For example, a Dataspy filter for all requisitions that have a Status "equal to" Approved and a Creation Date "greater than" last Friday.
• Sort: Specifies the order in which records must be sorted. For example, a Dataspy sorts the rooms so that the most recently created rooms are displayed at the top of the list in descending order.
• Layout: Specifies the fields that are displayed in the list and the order in which those fields must be displayed. For example, a Dataspy can specify that the Room Description column is displayed to the left of the Room column and that the Building field is not displayed in the list.
• Advanced: Specifies an additional Where clause that is used for filtering data. The Where clause is appended to the Where clause that is generated by the Dataspy filter.