I called Epicor just out of curiosity, and I've got a call open for someone to confirm.
But it is looking likely that Exports is the parent table and the Query* tables are all the children. I should've thought about looking under Q...why would anyone bother naming a table the same as what it references. :)
Thanks!
But it is looking likely that Exports is the parent table and the Query* tables are all the children. I should've thought about looking under Q...why would anyone bother naming a table the same as what it references. :)
Thanks!
--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> I ran a BAQ to show me all Calc Fields using QueryClcFld. In my research I found many tables starting with "Query" that I assume are BAQ related. I suggest starting with them.
>
> Dan
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of snielsen28
> Sent: Thursday, August 02, 2012 12:14 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: What table stores BAQs?
>
> I use the exports table to return a list of BAQs. I use it in a dashboard and report along with a bunch of other tables to document my BAQs.
>
> Sue
>
> --- In vantage@yahoogroups.com, "cubcrafters_it" <jason.navarrete@> wrote:
> >
> > Can I run a BAQ to return a list of BAQs? Or just run a raw ODBC query?
> >
> > I'm trying to flush out our unused custom things (BAQs, customizations, etc).
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>