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 SQ…

You need to create an External BAQ for that. Setup your external datasource, give company access to it and then do the following: Create new ext baq to the (epicor db) datasource. [image] Click on the Table-Valued Functions, add epicor or your function and enter the call parameters. [image] T…

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? Thank…

[image] Upgrade from 10.2.200 to 10.2.600 dashboards with external BAQ not working ERP 10 BAQ Views are ready to use in 600. You just need a bit of magic to make them visible to BAQ Designer. I’ve sent instructions to Rich and Steve some time ago. Apparently you can r…

How do I create SQL Function BAQ's?

Epicor ERP 10

hkeric.wci (Haso Keric) January 4, 2021, 7:06pm 4

Apparently you can register SQL Views in BAQ Designer – there is no frontend for the User yet, but its coming.

Topic		Replies	Views
How to create Table-Valued Function and using it in with External BAQs Epicor ERP 10 e10 , epicor , baq	3	1270	November 21, 2019
Epicor functions and BAQs Epicor ERP 10 baq , functions	25	13208	August 2, 2024
Query added views via BAQ? Epicor ERP 10 e10	20	2880	August 21, 2019
Consultants use External BAQ to point right back to Epicor Database Epicor ERP 10 e10 , baq	29	7296	July 28, 2020
BAQ that calls a BAQ? Epicor ERP 10 baq	17	4523	April 23, 2024

How do I create SQL Function BAQ's?

Related topics