I think there was also a missing parentheses after Approver 27 = $USER$
Try this:
( 'Status' = "Proposed") AND
(
(( 'Approve' = $NULL$ ) AND (( 'Approver 1' = $USER$) OR ( 'Approver 8' = $USER$) OR ( 'Approver 15' = $USER$) OR ( 'Approver 22' = $USER$))) OR
(( 'Approve2' = $NULL$ ) AND (( 'Approver 2' = $USER$) OR ( 'Approver 9' = $USER$) OR ( 'Approver 16' = $USER$) OR ( 'Approver 23' = $USER$))) OR
(( 'Approve3' = $NULL$ ) AND (( 'Approver 3' = $USER$) OR ( 'Approver 10' = $USER$) OR ( 'Approver 17' = $USER$) OR ( 'Approver 24' = $USER$))) OR
(( 'Approve4' = $NULL$ ) AND (( 'Approver 4' = $USER$) OR ( 'Approver 11' = $USER$) OR ( 'Approver 18' = $USER$) OR ( 'Approver 25' = $USER$))) OR
(( 'Approve5' = $NULL$ ) AND (( 'Approver 5' = $USER$) OR ( 'Approver 12' = $USER$) OR ( 'Approver 19' = $USER$) OR ( 'Approver 26' = $USER$))) OR
(( 'Approve6' = $NULL$ ) AND (( 'Approver 6' = $USER$) OR ( 'Approver 13' = $USER$) OR ( 'Approver 20' = $USER$) OR ( 'Approver 27' = $USER$))) OR
(( 'Approve7' = $NULL$ ) AND (( 'Approver 7' = $USER$) OR ( 'Approver 14' = $USER$) OR ( 'Approver 21' = $USER$) OR ( 'Approver 28' = $USER$)))
)
Thad Esser
Remedy Developer
| From: | "Brittain, Mark" <[email protected]> |
| To: | [email protected] |
| Date: | 01/08/2010 12:46 PM |
| Subject: | Re: Table Qualification |
| Sent by: | "Action Request System discussion list(ARSList)" <[email protected]> |
**
Hi Dave,
I think you are off by a close bracket after Approver 28’ = $USER$. What I do in the case is break out and then count the open and closed brackets. I would suggest moving the Status to front. Usually Status is indexed and if so your performance will be better.
( 'Status' = "Proposed")
AND
(( 'Approve2' = $NULL$ ) AND (( 'Approver 2' = $USER$) OR ( 'Approver 9' = $USER$) OR ( 'Approver 16' = $USER$) OR ( 'Approver 23' = $USER$)))
OR
(( 'Approve' = $NULL$ ) AND (( 'Approver 1' = $USER$) OR ( 'Approver 8' = $USER$) OR ( 'Approver 15' = $USER$) OR ( 'Approver 22' = $USER$)))
OR
(( 'Approve3' = $NULL$ ) AND (( 'Approver 3' = $USER$) OR ( 'Approver 10' = $USER$) OR ( 'Approver 17' = $USER$) OR ( 'Approver 24' = $USER$)))
OR
(( 'Approve4' = $NULL$ ) AND (( 'Approver 4' = $USER$) OR ( 'Approver 11' = $USER$) OR ( 'Approver 18' = $USER$) OR ( 'Approver 25' = $USER$)))
OR
(( 'Approve5' = $NULL$ ) AND (( 'Approver 5' = $USER$) OR ( 'Approver 12' = $USER$) OR ( 'Approver 19' = $USER$) OR ( 'Approver 26' = $USER$)))
OR (( 'Approve6' = $NULL$ ) AND (( 'Approver 6' = $USER$) OR ( 'Approver 13' = $USER$) OR ( 'Approver 20' = $USER$) OR ( 'Approver 27' = $USER$)) OR (( 'Approve7' = $NULL$ ) AND (( 'Approver 7' = $USER$) OR ( 'Approver 14' = $USER$) OR ( 'Approver 21' = $USER$) OR ( 'Approver 28' = $USER$)))
Mark
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Boylan, David
Sent: Friday, January 08, 2010 3:25 PM
To: [email protected]
Subject: Table Qualification
I have a table field where I want to show requests that have to be signed off by the login user. There is a 4x7 possibility – 7 groups and one of 4 approvers can approve. So, here’s my qualification. This works except the table field is showing all Statuses. I just want to show Proposed. ARS keeps adding the extra ) at the end. I’ve tried removing some parens but it still keeps putting it back or I get an error if I remove the leading and trailing parens… Anyone see anything obvious?
(( 'Approve2' = $NULL$ ) AND (( 'Approver 2' = $USER$) OR ( 'Approver 9' = $USER$) OR ( 'Approver 16' = $USER$) OR ( 'Approver 23' = $USER$))) OR (( 'Approve' = $NULL$ ) AND (( 'Approver 1' = $USER$) OR ( 'Approver 8' = $USER$) OR ( 'Approver 15' = $USER$) OR ( 'Approver 22' = $USER$))) OR (( 'Approve3' = $NULL$ ) AND (( 'Approver 3' = $USER$) OR ( 'Approver 10' = $USER$) OR ( 'Approver 17' = $USER$) OR ( 'Approver 24' = $USER$))) OR (( 'Approve4' = $NULL$ ) AND (( 'Approver 4' = $USER$) OR ( 'Approver 11' = $USER$) OR ( 'Approver 18' = $USER$) OR ( 'Approver 25' = $USER$))) OR (( 'Approve5' = $NULL$ ) AND (( 'Approver 5' = $USER$) OR ( 'Approver 12' = $USER$) OR ( 'Approver 19' = $USER$) OR ( 'Approver 26' = $USER$))) OR (( 'Approve6' = $NULL$ ) AND (( 'Approver 6' = $USER$) OR ( 'Approver 13' = $USER$) OR ( 'Approver 20' = $USER$) OR ( 'Approver 27' = $USER$)) OR (( 'Approve7' = $NULL$ ) AND (( 'Approver 7' = $USER$) OR ( 'Approver 14' = $USER$) OR ( 'Approver 21' = $USER$) OR ( 'Approver 28' = $USER$)) AND ( 'Status' = "Proposed"))
Thanks!
Dave
_Platinum Sponsor: [email protected] ARSlist: "Where
the Answers Are"_
This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited.
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. *
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
