Using a Dataspy - HxGN EAM - Version 11.07.01 - Help

HxGN EAM User Guide for Requestor

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
11.7.1

A Dataspy is a named, predefined view of a list of records or set of data that can be used on any page, lookup,or data area that contains that same list of records.

A Dataspy consists of the following four basic components:

  • Filter - Contains the conditional statements that make up a filter. For example, a Dataspy might 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 the records should be sorted. For example, a Dataspy might sort the requisitions so that the most recently created requisitions 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 should be displayed.For example, a Dataspy might specify that the Requisition Description column is displayed to the left of the Requisition Number column and that the Storeroom field is not displayed in the list.

  • Advanced - Specifies an additional Where clause used for filtering data. The Where clause is appended to the Where clause generated by the Dataspy Filter.

You can also specify column order by arranging the columns in a list view.

If a custom field saved in a Dataspy is ever unassociated, then that custom field will no longer appear in the Dataspy nor will it impact the Dataspy. If the same custom field is ever associated again, the relationship in the Dataspy will automatically be restored.