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 a litle issue to create a view. Let me summarize the case. There is a list with all the daily tasks, assigned to someone. I would like to create a view that shows one the assigned task to "you", that needs to be handled today and that was not handled previously.

It should be something like: AssignedTo=[ME] AND (HandlingDate=[TODAY] OR Handled!="Yes")

I can not create it because I dont have the option (or most likely i dont know how) to add the brackets.

What I need is:

AssignedTo=[ME] AND (HandlingDate=[TODAY] OR Handled!="Yes")

What I got with SP Filter

AssignedTo=[ME] AND HandlingDate=[TODAY] OR Handled!="Yes"

You help is hardly appreciated. Thanks.

share|improve this question

2 Answers 2

Did you try to make it HandlingDate=[TODAY] OR Handled!="Yes" and AssignedTo=[ME]? Does that give the expected results?

If that doesn't work, you'll probably have to convert it to an XSLT data view in Sharepoint Designer so you can take advantage of the XSLT filtering.

share|improve this answer
    
Thanks Pirate, I will try it soon and will let you know. –  user1360 Feb 3 '11 at 15:27

so you want to create additional filters conditions, right? You might not find it, because it's too easy:

In the form where you create a view -in the "Filter" section, there is a link on the right saying "Show More Columns..." that is where you can add a new filter condition.

So you go like this:

  • AssignedTo=[ME]
  • Show More Columns... (select AND with the radio button)
  • HandlingDate=[TODAY]
  • Show More Columns... (select OR with the radio button)
  • Handled!="Yes"
share|improve this answer
1  
Thanks AlexPoint, but by doing this my query will be AssignetTo=[me] AND HandlingDate=[today] OR Handled!="Yes" and not AssignetTo=[me] AND (HandlingDate=[today] OR Handled!="Yes") –  user1360 Feb 1 '11 at 13:16
    
Ok, I see -my fault. I dont have a solution for that. Sorry –  AlexPoint Feb 2 '11 at 7:23

Your Answer

 
discard

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