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 want.

Note: This information applies only to predefined DataViews. The data for other types of DataView displays is controlled by the source from which the display was launched.

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 are presented here.

To configure additional IDO specifications for a DataView, follow these guidelines on the DataView IDO Setup form:

  • 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 Add.

  • Order By section: As with the Order By option on the DataViews Setup form, these options are enabled only when the Source Type is IDO Collection, 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 Ascending or Descending order; and then clicking Add.

    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.
Related topics