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…

No but it’s been discussed. Go vote for the idea of you think someone should try and find a way. [image] Direct SQL entry and editing in BAQ Designer Feature Requests and Suggestions I think this speaks for itself. Just let us quickly edit/copy into a BAQ the correct SQL.…

And this one too: [image] Integrate source control into all Epicor Customizations Feature Requests and Suggestions Expand Solution Manager to work with Source Control Systems. This would allow users to see what was changed from the vanilla code as well as help with upgrade…

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

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

Epicor ERP 10

Mark_Wonsil (Mark Wonsil) June 19, 2019, 10:32pm 3

And this one too:

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

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

Related topics