I’ve written a couple of queries that find listings with errors in them. I now need to count how many results each query returns and associate that number with whatever project it is associated with. Ideally, the queries that I have already written could be used as subqueries of the query that lists the project, but so far I have not found any way to import or copy queries in that way. Does such a technique exist, or is the art of copy and paste a foreign concept in the land of Epicor?
1 Like
I have wondered this too, but never seen a solution for this. Sometimes, you’re just better off writing the sub-query in SQL to see if you get the right result and then re-creating that query as a sub-query in the BAQ, unfortunately. It would be really neat if there was a way to test a portion of a query or import a query as a sub-query though…
1 Like
Agree. Such functionality would be great, but I have not figured out how to do it.
However when it comes to testing sub-queries, I have been able to change a sub-query to top level (and the top level to an Inner Sub-Query) for the purposes of running the sub only. Then I change it back or edit and re-run. When I am happy with it, I change the sub back to an InnerSub and change the real top level one back to a Top Level.
3 Likes
I’ve been trying to figure out how to do this as well. This would be a great feature. If it exists, can someone enlighten me?