problem with where something something - Templates, (partial) views and macros

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Jesper Skjønnemand 66 posts 441 karma points c-trib

Feb 07, 2019 @ 12:08

problem with Where(something && something)

I am having trouble filtering the items on a list page. The selection below works fine, but it displays every "person" under "people".

var selection = Model.Content.Site().FirstChild("people").Children("person").Where(x => x.IsVisible()).OrderBy(x => x.GetPropertyValue("personFirstName")).ThenBy(x => x.GetPropertyValue("personLastName")).ToArray();;

I need the selection to display only items ("person") where the property "personInternal" is TRUE.

I have tried various things without success (Runtime Error):

Where(x => x.IsVisible() && x => x.person.personInternal.Equals("TRUE"))
Where(x => x.IsVisible() && x => x.person.personInternal.Is("TRUE"))
Where(x => x.IsVisible() && x => x.person.personInternal == "TRUE")
Where(x => x.IsVisible() && x => x.person.personInternal.Equals(TRUE))
Where(x => x.IsVisible() && x => x.person.personInternal.Is(TRUE))
Where(x => x.IsVisible() && x => x.person.personInternal == TRUE)

Where(x => x.IsVisible() && x.person.personInternal.Equals("TRUE"))
Where(x => x.IsVisible() && x.person.personInternal.Is("TRUE"))
Where(x => x.IsVisible() && x.person.personInternal == "TRUE")
Where(x => x.IsVisible() && x.person.personInternal.Equals(TRUE))
Where(x => x.IsVisible() && x.person.personInternal.Is(TRUE))
Where(x => x.IsVisible() && x.person.personInternal == TRUE)

Where(x => x.IsVisible() && person.personInternal.Equals("TRUE"))
Where(x => x.IsVisible() && person.personInternal.Is("TRUE"))
Where(x => x.IsVisible() && person.personInternal == "TRUE")
Where(x => x.IsVisible() && person.personInternal.Equals(TRUE))
Where(x => x.IsVisible() && person.personInternal.Is(TRUE))
Where(x => x.IsVisible() && person.personInternal == TRUE)

Where(x => x.IsVisible() && personInternal.Equals("TRUE"))
Where(x => x.IsVisible() && personInternal.Is("TRUE"))
Where(x => x.IsVisible() && personInternal == "TRUE")
Where(x => x.IsVisible() && personInternal.Equals(TRUE))
Where(x => x.IsVisible() && personInternal.Is(TRUE))
Where(x => x.IsVisible() && personInternal == TRUE)

What am I doing wrong? Any suggestions?

Best

Copy Link

Kevin Jump 2342 posts 14889 karma points MVP 8x c-trib

Feb 07, 2019 @ 12:18
0
Hi Jesper

try
```
Where(x => x.IsVisible() && x => x.GetPropertyValue<bool>("personInternal"))
```
K
Copy Link

Jesper Skjønnemand 66 posts 441 karma points c-trib

Feb 07, 2019 @ 12:39

Hi Kevin

I still get Runtime Error. I tested various strings:

 && x => x.GetPropertyValue<bool>("personInternal")
 && x => x.GetPropertyValue<bool>("personInternal") == TRUE
 && x => x.GetPropertyValue<bool>("personInternal").Equals(TRUE)
 && x => x.GetPropertyValue<bool>("personInternal") == "TRUE"
 && x => x.GetPropertyValue<bool>("personInternal").Equals("TRUE")

Suppose none of those are what you meant (?)

Copy Link

Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib

Feb 07, 2019 @ 13:05

0

Hi Jesper,

Try to print "personInternal" value or debug what is the value of this property?

Alex

Copy Link
Marcio Goularte 388 posts 1360 karma points

Feb 07, 2019 @ 12:47
0
Try
```
Where(x => x.IsVisible() && x => x.GetPropertyValue<string>("personInternal").Equals("1"))
```
Copy Link
Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib

Feb 07, 2019 @ 13:04
0
Marcio, you provided code with a mistake, it should be at least:
```
.Where(x => x.IsVisible() && x.GetPropertyValue<string>("personInternal").Equals("1"))
```
Copy Link
Jesper Skjønnemand 66 posts 441 karma points c-trib

Feb 07, 2019 @ 13:20
102
this worked
```
.Where(x => x.IsVisible() && x.GetPropertyValue<string>("personInternal").Equals("True"))
```
Copy Link
is working on a reply...

Please Sign in or register to post replies