E9 Using Alias Tables in BAQs

Yahoo Archive
1
What version of epicor are you on?

I have done it successfully in 9.04.506 but since we upgraded to patch 507A and had to get a one-off from epicor to make it possible to link more than one table it didn't work anymore with alias tables.
I submitted a call to epicor about this.


Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Joe Rojas <jrojas@...>
Sender: vantage@yahoogroups.com
Date: Fri, 18 Feb 2011 14:48:29
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] E9 Using Alias Tables in BAQs

Hello,



Has anyone successful added a table to a BAQ more than one time (created
a table alias)?

I've tried a couple of times now and each time, the fields from the
table alias are always blank even though I know the linked fields have
matching values.



If you have done this successfully, is there a trick to it?



Thanks.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
Hello,



Has anyone successful added a table to a BAQ more than one time (created
a table alias)?

I've tried a couple of times now and each time, the fields from the
table alias are always blank even though I know the linked fields have
matching values.



If you have done this successfully, is there a trick to it?



Thanks.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
You can do this in 9 and above

________________________________

From: vantage@yahoogroups.com on behalf of Joe Rojas
Sent: Fri 2/18/2011 2:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9 Using Alias Tables in BAQs




Hello,

Has anyone successful added a table to a BAQ more than one time (created
a table alias)?

I've tried a couple of times now and each time, the fields from the
table alias are always blank even though I know the linked fields have
matching values.

If you have done this successfully, is there a trick to it?

Thanks.







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
Thanks Sean.



I know that it can be done but I was wondering if anyone has
successfully done it.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sean McDaniel
Sent: Friday, February 18, 2011 3:12 PM
To: vantage@yahoogroups.com; vantage@yahoogroups.com
Subject: RE: [Vantage] E9 Using Alias Tables in BAQs





You can do this in 9 and above












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



________________________________


From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> on
behalf of Joe Rojas
Sent: Fri 2/18/2011 2:48 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9 Using Alias Tables in BAQs

Hello,

Has anyone successful added a table to a BAQ more than one time (created
a table alias)?

I've tried a couple of times now and each time, the fields from the
table alias are always blank even though I know the linked fields have
matching values.

If you have done this successfully, is there a trick to it?

Thanks.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
5
Good Day Sean:

I have done it. No real trick. I always include Company as one of
the fields to link the tables.
Watch out for the direction of the Link, and sometimes you need an
outer join.
Sample attached. Also attached is the export of the BAQ file. It is
a rather complicated one.
It is a where-used for a JOB so we can find out what Sub-Assembly it
is in because some of our JOBs have many many sub-assemblies.

Sun went live on 11/29
in Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)


len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Friday, February 18, 2011 3:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9 Using Alias Tables in BAQs




Thanks Sean.

I know that it can be done but I was wondering if anyone has
successfully done it.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Friday, February 18, 2011 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ;
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] E9 Using Alias Tables in BAQs

You can do this in 9 and above

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> on
behalf of Joe Rojas
Sent: Fri 2/18/2011 2:48 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9 Using Alias Tables in BAQs

Hello,

Has anyone successful added a table to a BAQ more than one time (created
a table alias)?

I've tried a couple of times now and each time, the fields from the
table alias are always blank even though I know the linked fields have
matching values.

If you have done this successfully, is there a trick to it?

Thanks.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
6
I have done it successfully on 9.05 myself and cant think of any peculiarities. If you let me know the details of what you are trying to achieve I might be able to help further.

Aman
--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day Sean:
>
> I have done it. No real trick. I always include Company as one of
> the fields to link the tables.
> Watch out for the direction of the Link, and sometimes you need an
> outer join.
> Sample attached. Also attached is the export of the BAQ file. It is
> a rather complicated one.
> It is a where-used for a JOB so we can find out what Sub-Assembly it
> is in because some of our JOBs have many many sub-assemblies.
>
> Sun went live on 11/29
> in Epicor 9, 9.05.601B SQL-Unidata
> Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
>
>
> len.hartka@...
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Joe Rojas
> Sent: Friday, February 18, 2011 3:42 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] E9 Using Alias Tables in BAQs
>
>
>
>
> Thanks Sean.
>
> I know that it can be done but I was wondering if anyone has
> successfully done it.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Sean McDaniel
> Sent: Friday, February 18, 2011 3:12 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ;
> vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] E9 Using Alias Tables in BAQs
>
> You can do this in 9 and above
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
> us about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> on
> behalf of Joe Rojas
> Sent: Fri 2/18/2011 2:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] E9 Using Alias Tables in BAQs
>
> Hello,
>
> Has anyone successful added a table to a BAQ more than one time (created
> a table alias)?
>
> I've tried a couple of times now and each time, the fields from the
> table alias are always blank even though I know the linked fields have
> matching values.
>
> If you have done this successfully, is there a trick to it?
>
> Thanks.
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <mailto:jrojas%40matsinc.com>
> <mailto:jrojas%40matsinc.com>
> <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
> green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
>
> [Non-text portions of this message have been removed]
>