# Access (link) System tables in an External BAQ

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-11-01 19:02 UTC
**Views:** 2521
**Replies:** 12
**URL:** https://www.epiusers.help/t/access-link-system-tables-in-an-external-baq/36057

---

## Post #1 by @Chris_Conn

Am I missing something here? I cant seem to figure out how to bring in system tables in an External BAQ. I am trying to link system tables to an external table.

---

## Post #2 by @josecgomez

You can't :slight_smile:

Work around is to add Views into the System Tables to your external DB

---

## Post #3 by @Chris_Conn

That being the case - how do I access E10 system tables from my other db? I have limited rights to the system hosting E10 and wouldnt even know where to begin where to locate the tables etc. I assume the actual DB is going to be locked away in some folder on the host PC I dont have access to. For a normal company, I am sure this wouldn't be a problem, for my company, if I cant find a backdoor I may as well give up.

---

## Post #4 by @Chris_Conn

Or is there some code trickery I can use from within a customization or bpm to 'drive' my external BAQ with a parameter?

---

## Post #5 by @josecgomez

Hmm yeah there may be a trick or two... The other thing you can do is have a dashboard where you have your external data but it's "driven" by an internal query and then filtered via publish and subscribe

---

## Post #6 by @softdd

When you say "E10 system tables" what are you referring to ? or which specific
info. are you looking for?

---

## Post #7 by @Chris_Conn

We use a system called Mattec (purchased by Epicor - supposedly, there is a system interface for this). Mattec has vital info like machine/mold cycles, cycle times, etc. We simply want to use the Erp.Part table to link ACTIVE parts of type M (Manufactured) to the relevant data of their molds (i..e the cycle times). Our current solution is to dump the parts out of a BAQ into excel and do some VLOOKUPs, which works, but is clunky. 

Jose.... dont tease me! I know very little about publish/subscribe, actually, all I've seen it used for is linking to a google search. I have created a dashboard based on BAQ but not an external one - I figure it's all the same. Any tips on implementing an internal query on the BAQ/Dash. It's a premature question since I haven't even glanced at it yet in the system - but I figured I preempt my failure :slight_smile:

---

## Post #8 by @Chris_Conn

BTW Jose, I thought recognized your name - I've watched several of your videos in the past 3 months. I always had to check my volume to figure out where the dialog was :smile: Still very useful videos!

---

## Post #9 by @josecgomez

Yeah most of those videos were a response to a question here ( yahoo)
So no audio

---

## Post #10 by @josecgomez

I'll have to reply in the morning. Too hard to explain on the phone

---

## Post #11 by @Chris_Conn

@josecgomez.trigemco Friendly reminder, you were going to give me a few details or example of manipulating a tracker to filter an external BAQ using internal query :blush:

---

## Post #12 by @josecgomez

Yes! sorry been slammed I'll try to get you something.

---

## Post #13 by @Chris_Conn

No worries brother, I completely understand. At your convenience!

---


**Canonical:** https://www.epiusers.help/t/access-link-system-tables-in-an-external-baq/36057
**Original content:** https://www.epiusers.help/t/access-link-system-tables-in-an-external-baq/36057