Use the IsHidden attribute with a value of "true" to hide a column within the list builder. By default, any column defined within the query by the TVFImplementation Element is visible as an available column for the list builder unless it is marked as hidden.
...
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>
...