Select the columns to display when the Dataspy is applied to a list of records, and then specify the order in which the fields will be displayed.
Additionally, the system allows you to specify the number of records that the system will retrieve before it retrieves another set of records from the database in a list view. This setting does not affect the height of a table (i.e., the number of rows that are shown without scrolling the table). This setting is important because it will affect the speed at which the system downloads and displays a list containing a large number of records.
For example, if the value is set at 100 (the default), the system will only download the first 100 records that match the criteria specified in the selected Dataspy. When you scroll to the end of the 100 records, the system will download and display the next 100 records that match the criteria specified in the Dataspy. If the value is set to 300, then the system will not display any of the records until it has downloaded all 300 records.
To specify Dataspy layout criteria:
-
On any list view page, select the Dataspy to edit from the drop-down list on the filter bar, and then click Edit.
-
Click Layout from the left-hand column of the Dataspy editor.
Available Fields lists all fields that are available but not visible in the list of records, while Visible Fields lists all fields displayed as columns in the list of records.
See the following table when selecting or ordering fields:
Function
Procedure
Add a field
Select the field in Available Fields, and then click Add a field.
Remove a field
Select the field in Visible Fields, and then click Remove a field.
Add all fields
Click Add all fields.
Remove all fields
Click Remove all fields.
Reorder fields
Select the field in Visible Fields, and then click either Reorder up or Reorder down to move the field up or down in the order.
-
Specify this information:
Number of data rows to retrieve - Enter the number of rows that the system will retrieve in the list view before it downloads another set of rows.
-
Click the field to select, and then see the table above when selecting or ordering fields.
-
Click Save.