We just upgraded to 10.2.700 and I noticed a BAQ called zUsersSecGroupsForCompany that is only querying a SQL Table Value Function called Ice.UsersAndSecGroupsVisibleToCompanyFunc. There doesn’t seem to be anything in ZDataTable or ZDataField that references this function so how do I add a custom SQL Table Value function to a BAQ?
You can view all of the BAQ’s with Table Value Functions with: select * from ice.QueryTable where TableType=‘FN’
Thanks so much @carlosqt! Theirs isn’t marked as External, I was curious how they did that without making it an external BAQ? I thought that you had to create the ZData records in order for it to be recognized by a BAQ?
Also, do the custom functions stick around during major version upgrades? Thanks!