Output Element

The Output element designates the fields to include in the query view from among the columns that the ViewSQLelement returns.

<Output>
 <OutputFields>
  <OutputField Caption="System record ID" Category="System Fields" Name="ID" />
  <OutputField Name="EXAMPLE" Caption="Example Field" DataType="String" />
  <OutputField Name="EXAMPLE2" Caption="Example Field 2" DataType="Integer" />
 </OutputFields>
</Output>

Within the Output element, the OutputFields element contains an OutputField element for each field to include in the query view. For information about the attributes of the OutputField element, see OutputField Attributes. The OutputField element's child LookupInfo element is discussed below.

Warning: Do not change Caption attributes for OutputField elements after you release query view specs to your production environment. Changing the caption of an output field breaks backwards compatibility for ad-hoc queries based on the query view.