Caption Attribute
In the OutputField element, the optional Caption attribute provides a friendly name to display for an output field. If not specified, the column name defined in the query is used. Hidden columns typically do not require a caption. In the sample below, the FOODBANKTYPE column has a caption of "Food Bank Type."
...
SELECT
FBCONSTITUENTID
, FOODBANKTXHEADERID
, FOODBANKTXDETAILID
, FBCONSTITUENTNAME
, FOODBANKTYPE
, TXCONSTITUENTID
, TXCONSTITUENTNAME
, FOODBANKTXTYPE
FROM CTE
</CreateFunctionSQL>
<Parameters>
<common:FormMetaData>
<common:FormFields>
<common:FormField FieldID="FOODBANKID" Caption="Food Bank" Required="false" DataType="Guid">
<common:SearchList SearchListID="3eceea4c-cf42-4938-9cf1-c7c77ebc7dc9" EnableQuickFind="true" />
</common:FormField>
</common:FormFields>
</common:FormMetaData>
</Parameters>
</TVFImplementation>
<Output>
<OutputFields>
<OutputField Name="FBCONSTITUENTID" IsHidden="true" DataType="Guid" />
<OutputField Name="FOODBANKTXHEADERID" Caption="FOODBANKTXHEADERID" DataType="Guid" IsHidden="true" />
<OutputField Name="FOODBANKTXDETAILID" Caption="FOODBANKTXDETAILID" DataType="Guid" IsHidden="true" />
<OutputField Name="FBCONSTITUENTNAME" Caption="Food Bank" DataType="String" />
<OutputField Name="FOODBANKTYPE" Caption="Food Bank Type">
<LookupInfo>
<CodeTable CodeTableName="USR_FOODBANKTYPECODE" />
</LookupInfo>
</OutputField>
...