BAQ Nested Parentheses

system · November 30, 2010, 11:55am

Joe,

Actually, if the BAQ follows the "order of operations rules", it should
execute AND's before it executes OR's. If that 's the case, you should be
able to write the query as:

Aaaa AND bbbb AND cccc AND dddd AND (xxxx AND zzzz OR yyyy AND zzzz)

Order of operations dictate that it executes "xxxx AND zzzz", and it
executes "yyyy AND zzzz", then it does the "OR". I've gotten so used to
explicitly putting in parenthesis that I forgot about the order of
operations. It may be worth a try.

Kevin

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Tuesday, November 30, 2010 11:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

My bad. I was trying to keep it simple and I didn't mention that I also
have additional criteria, which is why I need to use additional
parentheses.

It looks more like this:

Aaaa AND bbbb AND cccc AND dddd AND (xxxx OR (yyyy AND zzzz))

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

ok how about this:

the first criteria with no parentheses xxxxxxx
or (next criteria yyyyyyy
and third criteria zzzzzz)

close parentheses

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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>
<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]

[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]

system · November 30, 2010, 10:26am

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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]

system · November 30, 2010, 10:33am

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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]

system · November 30, 2010, 10:33am

My mistake... I'm trying to represent (xxxx OR (yyyy AND zzzz))

For what it's worth.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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]

system · November 30, 2010, 10:35am

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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]

system · November 30, 2010, 10:54am

ok how about this:

the first criteria with no parentheses xxxxxxx
or (next criteria yyyyyyy
and third criteria zzzzzz)

close parentheses

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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]

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

system · November 30, 2010, 11:01am

My bad. I was trying to keep it simple and I didn't mention that I also
have additional criteria, which is why I need to use additional
parentheses.

It looks more like this:

Aaaa AND bbbb AND cccc AND dddd AND (xxxx OR (yyyy AND zzzz))

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

ok how about this:

the first criteria with no parentheses xxxxxxx
or (next criteria yyyyyyy
and third criteria zzzzzz)

close parentheses

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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>
<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]

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

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

system · November 30, 2010, 11:13am

it does make it harder now because you can't filter by calculated fields
as you could in Vantage6.

can you fool it like maybe:
aaaaa
and bbbbbb
and ccccc
and ddddd
and (xxxxx
or (yyyyy
and zzzzz)
and company = your company)

maybe using a field that would always be true no matter what records are
equal to your criteria

just a thought

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 10:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

My bad. I was trying to keep it simple and I didn't mention that I also
have additional criteria, which is why I need to use additional
parentheses.

It looks more like this:

Aaaa AND bbbb AND cccc AND dddd AND (xxxx OR (yyyy AND zzzz))

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

ok how about this:

the first criteria with no parentheses xxxxxxx
or (next criteria yyyyyyy
and third criteria zzzzzz)

close parentheses

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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>
<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]

[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]

system · November 30, 2010, 11:43am

It's too bad Epicor didn't give you an "advanced" button, and allow you to
edit the query statement directly.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Tuesday, November 30, 2010 11:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

My bad. I was trying to keep it simple and I didn't mention that I also
have additional criteria, which is why I need to use additional
parentheses.

It looks more like this:

Aaaa AND bbbb AND cccc AND dddd AND (xxxx OR (yyyy AND zzzz))

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

ok how about this:

the first criteria with no parentheses xxxxxxx
or (next criteria yyyyyyy
and third criteria zzzzzz)

close parentheses

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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>
<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]

[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]

system · November 30, 2010, 11:45am

Agreed. :)

One parentheses is cause my headache.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kevin Simon
Sent: Tuesday, November 30, 2010 11:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Nested Parentheses

It's too bad Epicor didn't give you an "advanced" button, and allow you
to
edit the query statement directly.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Tuesday, November 30, 2010 11:02 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

My bad. I was trying to keep it simple and I didn't mention that I also
have additional criteria, which is why I need to use additional
parentheses.

It looks more like this:

Aaaa AND bbbb AND cccc AND dddd AND (xxxx OR (yyyy AND zzzz))

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

ok how about this:

the first criteria with no parentheses xxxxxxx
or (next criteria yyyyyyy
and third criteria zzzzzz)

close parentheses

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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.

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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

Thanks Lisa.

I'm trying to add it to the criteria grid for a table in a BAQ.

Unfortunately, it doesn't give me the ability to specify how many
opening or closing parentheses to you. :(

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lisa Kelepolo
Sent: Tuesday, November 30, 2010 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Nested Parentheses

here is the code if you are using it with an if-then-else statement:
if (ResourceGroup.OpCode = 'cncvm' and (ResourceGroup.Number20 = 1 or
ResourceGroup.Number20 = 2)) then 'y' else 'n'

Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com
<http://www.electromech.com/>

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>
<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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, November 30, 2010 9:26 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Nested Parentheses

Is it possible to nest parentheses when creating a BAQ? If so, how?

I'm trying to add criteria to a BAQ that represents:

( xxxx AND (yyyy OR zzzz))

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>
<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]

[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]

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