I want to create a bunch of new BAQs, and my expertise is in SQL. Has anyone been able to copy and paste their code from SSMS into a query-builder to create new BAQs that way? It might be a reach. I really don’t want to manually build all of these connections when I can just type them out in SQL.
Not possible. Many here share your pain.
ouch my soul hurts. Thank you for your quick reply 
Not impossible! Not easy though. 7zip into a BAQ export file and snoop around. It’s all text, nothing’s obfuscated. A persistent person could do a little digging into what’s necessary and what isn’t and sort out the required syntax.
An extremely persistent cloud user could even pull Ice.ZDataField and Ice.ZDataTable and use that to give a text editor some intellisense clues. Can you tell it’s crossed my mind?
The amount of effort required to parse SQL backwards into an Epicor Dynamic Query Dataset is pretty much like writing a SQL compiler you’d have to split and parse all the individual pieces of the SQL Syntax and somehow map over the equivalent pieces in dataset like an assembler. I do not know how an effort like this would ever be worth it specially when you can just learn to use the tool which is pretty powerful.
Having written an actual compiler a couple of times in my life all I have to say to this is… #NoThanks 
1 Like
Surely that’s more work than just writing the BAQ??? I know its painful but its not THAT painful.
No, but in my experience, if you have mapped the query out in SQL it’s usually pretty quick to build the BAQ in the UI. Main pain point is that T-SQL supports things that BAQ doesn’t and you have to refactor. That discrepancy also makes a copy-paste approach difficult.
1 Like