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