Sign in Register
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
    Jesper Skjønnemand
    0

    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 2348 posts 14896 karma points MVP 8x c-trib
    Feb 07, 2019 @ 12:18
    Kevin Jump
    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
    Jesper Skjønnemand
    0

    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 6182 posts 24284 karma points MVP 8x admin c-trib
    Feb 07, 2019 @ 13:05
    Alex Skrypnyk
    0

    Hi Jesper,

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

    Alex

    Copy Link
  • Marcio Goularte 389 posts 1362 karma points
    Feb 07, 2019 @ 12:47
    Marcio Goularte
    0

    Try

    Where(x => x.IsVisible() && x => x.GetPropertyValue<string>("personInternal").Equals("1"))
    Copy Link
  • Alex Skrypnyk 6182 posts 24284 karma points MVP 8x admin c-trib
    Feb 07, 2019 @ 13:04
    Alex Skrypnyk
    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
    Jesper Skjønnemand
    102

    this worked

    .Where(x => x.IsVisible() && x.GetPropertyValue<string>("personInternal").Equals("True"))
    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies