• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

How do I create a List View Filter with More than one condition - And vs. OR

Im having issues getting SharePoint list filters to work when I have more than one condition.  I just dont understand the or/and operations well enough to make these work.  They seem logical to me but the views dont yield the results I desire.

Example:
Form Location is equal to eApp Wizard
And
Form Status is equal to Pending Revision
Or
Form Location is equal to eApp Wizard
And
Form Status is equal to New Form

My desire is to show forms that are in the eApp Wizard and have a form status of Pending Revision or New Form, however Im only getting the ones that have a New Form.  Do you have any insight or any online resources that youve seen for this situation.  I just havent had a clear understanding of how to use the or vs the and option.  

0
jonlaguna
Asked:
jonlaguna
  • 3
1 Solution
 
MCummings111400Commented:
Try using just this:

Form Status is equal to Pending Revision
or
Form Status is equal to New Form
And
Form Location is equal to eApp Wizard
0
 
jonlagunaAuthor Commented:
That works but obviously isn't what i thought would work... I'm having an issue grasping when to use Or vs. And and the order of operations to get these filters to work.... do you have any insight on how i can better understand this?  I tried doing some online research but I must be the only one that doesn't understand how this works because i can't find anything.  
0
 
jonlagunaAuthor Commented:
Here is an example of how my confusion continues...

What if i want to check the status of another column in my list for this example.  Say i have an eApp Release Status coulmn as well and i want to also see all fields that are not blank or "Active"

I tried using:

Form Status is equal to Pending Revision
or
Form Status is equal to New Form
And
Form Location is equal to eApp Wizard
or
eApp Release Status is equal to Active
or
eApp Release Status is equal to

But again this didn't work for me.  
0
 
jonlagunaAuthor Commented:
Still not sure why it works.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now