Category isn't this unless property is false

Question

As the title describes. I am stuck, an otherwise simple use of and, xor, or expressions in a LINQ statement.

from s in db.Items
where <Other boolean operations> &&
      s.Category.Contains("something") &&
      s.IsReviewed == false

Where I want the other boolean operations to filter the list down, and where the remainder of items should not be of the category "something" unless the IsReviewed bool is false.

An alternate way to express this is: I want items of any category to show, except "something" category unless it hasn't been reviewed.

Your direction is appreciated.

To clarify, you want all filtered items to be `IsReviewed` if they are not in `Category.Contains("something")` and `!IsReviewed` if they are in `Category.Contains("something")`? Or do you not care the state of `IsReviewed` if the item is not in category? — strongbutgood, Dec 30 '16 at 21:25
I want all filtered items to be "IsReviewed" bool agnostic (true or false), unless it is of the category "something", for them I only want those that are false. — CAD.Dev, Dec 30 '16 at 21:42

score 1 · Answer 1 · answered Dec 30 '16 at 22:04

1

Based on all the comments I am understanding you are looking for all items that aren't in Category.Contains("something") or the ones that are if they are !IsReviewed

from s in db.Items
where <Other boolean operations> &&
      (!s.Category.Contains("something") || !s.IsReviewed)

You can move the negation around so you are excluding any items that are in Category.Contains("something") and are IsReviewed

from s in db.Items
where <Other boolean operations> &&
      !(s.Category.Contains("something") && s.IsReviewed)

answered Dec 30 '16 at 22:04

strongbutgood

655
7
22

I feel like this is the correct answer: i am looking for Not(category = "something" and isReviewed = true) – CAD.Dev Dec 30 '16 at 22:08
If I could choose two answers, I would. – CAD.Dev Dec 30 '16 at 22:14

Venkat Pasumarthi · Accepted Answer · 2016-12-30T21:55:29.803

0

Updated answer to reflect logic according to your comment.

from s in db.Items
where <Other boolean operations> &&
      (!s.Category.Contains("something") || s.IsReviewed == false)

edited Dec 30 '16 at 21:55

answered Dec 30 '16 at 21:06

Venkat Pasumarthi

59
9

@CAD.Dev Do you have any other categories? Do they meet all of your other criteria? – Servy Dec 30 '16 at 21:36
Yes, there are many other categories. Where I would like to show both reviewed and unreviewed items. – CAD.Dev Dec 30 '16 at 21:37
@CAD.Dev Updated answer. – Venkat Pasumarthi Dec 30 '16 at 21:44
@CAD.Dev Then they would have passed the criteria as originally shown. If they weren't being shown, then they either didn't exist, or didn't pass your other criteria. – Servy Dec 30 '16 at 21:52
@VenkatPasumarthi The change is semantically identical. It will never produce a different result than the previous revision. – Servy Dec 30 '16 at 21:52
@Servy Right again – Venkat Pasumarthi Dec 30 '16 at 21:54
@CAD.Dev This should work exactly as you described. Qualifies all scenarios you mentioned here: IF NOT "Something" IS True IF "Something" && Unreviewed IS True IF "Something" && Reviewed IS False – Venkat Pasumarthi Dec 30 '16 at 21:57
There are now two semantically identical solutions. Thank you for your help. This works! – CAD.Dev Dec 30 '16 at 22:10

Servy · Answer 3 · 2016-12-31T01:12:09.793

-1

So you want all of the items where the category is NOT "something" OR IsReviewed is false.

edited Dec 31 '16 at 01:12

answered Dec 30 '16 at 21:07

Servy

202,030
26
332
449

3

Can you add this as a comment? Rather than an answer? – CAD.Dev Dec 30 '16 at 21:13
@CAD.Dev It's an answer to the question, not a comment, so...no. – Servy Dec 30 '16 at 21:23
@Servy: Does the added code illustrate what you were saying? – David Dec 31 '16 at 01:02

Category isn't this unless property is false

3 Answers3