IsHidden Attribute
In the OutputField element, you can set the IsHidden attribute to "true" to hide a column within a query view or list builder. By default, any column defined within the query by the ViewImplementation or TVFImplementation elements is visible as a field in a query view or as an available column in a list builder. To hide a column, you just add the IsHidden attribute to its OutputField element and set it to "true."
...
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>
<OutputField Name="TXCONSTITUENTID" Caption="TX Constituent ID" IsHidden="true" DataType="Guid" />
<OutputField Name="TXCONSTITUENTNAME" Caption="TX Constituent" DataType="String" />
<OutputField Name="FOODBANKTXTYPE" Caption="TX Type">
<LookupInfo>
<TranslationList>
<common:Options>
<common:TranslationListOption Value="Receive" />
<common:TranslationListOption Value="Distribute" />
</common:Options>
</TranslationList>
</LookupInfo>
</OutputField>
</OutputFields>
</Output>
...