Solved my own problem.
It turns out the issue is with my lack of understanding on how
territories and workforce IDs create boundaries.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Wednesday, January 26, 2011 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ too complex?
Hi All,
I am trying to make a BAQ where the first table is OrderHed.
If you were looking at the graphical Phrase Builder tab, there are three
tables that "branch" off of OrderHed.
My BAQ works fine with two branches but once add the third branch, it
stops returning rows.
The third branch is Customer so I know there are matching customer
numbers.
Is this too complex for a BAQ? Is this just bad form and it needs to be
designed better?
The query it generates is:
for each OrderHed no-lock where OrderHed.OpenOrder = TRUE , each
UD14 no-lock where (OrderHed.Company = UD14.Company and
OrderHed.OrderNum = UD14.Number01 ) , each SaleAuth no-lock where
SaleAuth.DcdUserID = Constants.CurrentUserID and (UD14.Company =
SaleAuth.Company and UD14.ShortChar01 = SaleAuth.SalesRepCode ) , each
OrderDtl no-lock , each Part no-lock where (OrderDtl.Company =
Part.Company and OrderDtl.PartNum = Part.PartNum ) , each Customer
no-lock where (OrderHed.Company = OrderDtl.Company and
OrderHed.OrderNum = OrderDtl.OrderNum ) and (OrderHed.Company =
Customer.Company and OrderHed.CustNum = Customer.CustNum ).
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]
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]
It turns out the issue is with my lack of understanding on how
territories and workforce IDs create boundaries.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Wednesday, January 26, 2011 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ too complex?
Hi All,
I am trying to make a BAQ where the first table is OrderHed.
If you were looking at the graphical Phrase Builder tab, there are three
tables that "branch" off of OrderHed.
My BAQ works fine with two branches but once add the third branch, it
stops returning rows.
The third branch is Customer so I know there are matching customer
numbers.
Is this too complex for a BAQ? Is this just bad form and it needs to be
designed better?
The query it generates is:
for each OrderHed no-lock where OrderHed.OpenOrder = TRUE , each
UD14 no-lock where (OrderHed.Company = UD14.Company and
OrderHed.OrderNum = UD14.Number01 ) , each SaleAuth no-lock where
SaleAuth.DcdUserID = Constants.CurrentUserID and (UD14.Company =
SaleAuth.Company and UD14.ShortChar01 = SaleAuth.SalesRepCode ) , each
OrderDtl no-lock , each Part no-lock where (OrderDtl.Company =
Part.Company and OrderDtl.PartNum = Part.PartNum ) , each Customer
no-lock where (OrderHed.Company = OrderDtl.Company and
OrderHed.OrderNum = OrderDtl.OrderNum ) and (OrderHed.Company =
Customer.Company and OrderHed.CustNum = Customer.CustNum ).
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]
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]