Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have two different conditions based on which I need to apply filter on the list data.

The conditions are based on the user role and status column.

I have applied the filter condition as : Createdby equals to [Me] or Manager equals [Me] and Status equals to "Resubmitted" or Status equals to "In Progress".

The condition never turns out to be true so I none of my forms are visible.

Please guide...

Thanks a lot.

share|improve this question
1  
Could you please provide some additional information: are you applying the conditions through GUI, or through SharePoint Designer, or you're using CAML? Besides, I'd recommend you to work on your accept rate. You are supposed to accept answers to your questions which were useful to you by clicking small accept mark next to the helpful question. This will encourage site experts to help you much more eagerly. –  Andrey Markeev May 3 '12 at 9:22
    
In addition you need to accurately describe the condition you're after. What you've written could be (A or B) and (C or D) or it could be A or (B and C) or D or lots of other combinations. You won't get anywhere without being very specific in your details. –  Ryan May 3 '12 at 11:50

2 Answers 2

To group conditions like this,(I'm going to assume (A or B) and (C or D)) you could use calculated columns in conjunction with you list view filter.

Create two columns like this:

1stLogic = OR(CreatedBy = A, Manager = B) 2ndLogic = OR(Status = C, Status = D)

List view filters: 1stLogic equals Yes AND 2ndLogic = Yes

I haven't tried using the current user as data, or the [Me] operator, so that may be a problem with this method.

share|improve this answer
    
+1 for creative problem solving. –  DrivenDevelopment May 3 '12 at 18:06

The SharePoint UI does not allow you to group the ORs and ANDs when building the filter in the browser. Thus the order of operations is top down.

To group the operations in your filter you would need to customize the view in ShaerPoint Designer.

More specific instuctions can be found here.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.