Setting additional IDO specifications for a DataView
When you create a predefined DataView, you can set up the associated IDO so that only the desired data is retrieved when the DataView is displayed. This ensures that you minimize the retrieval time and get only the data that you really need.
Also, the information in this topic is closely related to the information in the topic Specifying DataView setup information - General tab. In general, when information is presented in that topic, it is not repeated here. Only additional information and the expanded capabilities of the DataView IDO Setup form is presented here.
To configure additional IDO specifications for a DataView, use these guidelines:
- IDO section - Depending on the Source Type, you can change or modify several of the settings in this section. You can also set or modify these settings on the General tab of the DataViews Setup form.
- Link By section
- As with the Link
By option on the DataViews
Setup form, these options are enabled only when a Parent IDO is specified on
that form.
This form, however, provides additional specification options. You can specify which properties are to be used to link and display data. Do this by specifying a Parent Property and a Child Property and then clicking .
- Order By
section - As with the Order
By option on the DataViews
Setup form, these options are enabled only when the Source Type is , as specified on that form.
This form, however, provides additional specification options. You can specify properties by which to sort the data that is displayed. Do this by specifying one or more properties by which to sort the data and whether the data is to be displayed in
or order; and then clicking .Note: If a record cap is in use, the Order By setting determines which records are selected for retrieval first. - Properties
section - You can specify exactly which properties are to be included in the
data query by selecting them in this section. Properties that are not
"Selected" are
not included in the return results for the data query.
In addition to selecting which properties to include in the data query, you can also view and/or specify these settings for each property:
Setting Description Description Read-only. This field displays any description provided for the property, as specified on the IDO Properties form. Default Caption Read-only. This field displays any default caption currently defined for the property, as specified on the IDO Properties form. You can override the default caption, using the Caption Override field.
Caption Override Use this field to override the default caption for a property. Whatever you provide as a caption override is what displays as the column header for that property in the DataView Results form. System Record When selected, this option prevents anyone other than a Vendor Developer from making modifications to or deleting a property specification for the DataView.