When you create a BAQ, it shows you the SQL code right on the front tab (General tab) of the BAQ. I can copy this code and edit it locally in my preferred editor, or play around with it in SQL Server Management Studio. But is there a way to go in reverse? What I am thinking is that I want to copy m…

see Epicor Idea: Log In - Epicor Identity and vote for it.

Just did, while I appreciate all of the complexity that a BAQ can handle without touching SSMS or being super proficient in SQL, it’s very cumbersome if you do know SQL.

[image] utaylor: it’s very cumbersome if you do know SQL. But even for those who know SQL, how many understand the database? Are users Adding company/site/territory/field security to their SQL code? handling _UD tables? Will they also include columns temporarily stored in Ice.PatchFld? And …

I think it’s more of a conversion utility - converting those things we can do in SQL into the BAQ syntax that may never have known you could do. I don’t want it to bypass any of the Epicor code, just convert my SQL to a BAQ.

Oh, I think I get it. Will the conversion utility add this for us? Will SQL authors test in SSMS first? They won’t provide the same results as a BAQ unless we do the stuff above. Is the idea to get us started instead of messing with the GUI? Just quick and dirty queries? I’m trying to understand the…

[image] Mark_Wonsil: I’m trying to understand the use cases where this makes our lives easier. Something as simple as being able to take just part of another BAQ, like a subquery, and copy paste into a new BAQ would be nice. Currently, I think the only way to do that is to copy the whole quer…

[image] Mark_Wonsil: I’m trying to understand the use cases where this makes our lives easier. I can see it being useful for 2 scenarios: Quick & Dirty Super Advanced

Also, for repetitive queries/fields, where you can copy paste code to things relatively quickly in a text editor, but you have to do one at a time in BAQ land. Calculated fields that are super similar but not quite (like things with ranges, like number of days, where you need 1-10, 10-30, 30-60 etc)…

Using BAQs within BAQs satisfies this need, no?

It helps. But I believe there are limitation with that right? Can you use that feature with Updateable BAQ’s? I haven’t had time to dig into that functionality yet. Also, you might be making the calculated fields for the first time.

Is there a way to create a BAQ from its SQL code?

Epicor ERP 10

timshuwy (Tim Shoemaker) October 8, 2024, 6:18pm 23

see SQL to BAQ?

Topic		Replies	Views
Direct SQL entry and editing in BAQ Designer Feature Requests and Suggestions	35	10121	June 20, 2019
This might be a quick answer... Has anyone generated a BAQ from SQL code? Kinetic ERP baq	6	663	October 18, 2023
Simple method to convert BAQ query to SQL server Epicor ERP 10 baq	32	10230	June 25, 2025
SQL to BAQ? Kinetic ERP sql , baq	48	4936	March 25, 2025
Poll - do you use BAQ designer or SQL? Epicor ERP 10 sql	32	3068	January 1, 2023

Is there a way to create a BAQ from its SQL code?

Related topics