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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
