Need help on where-object in powershell

Question

if I execute the below code it is not filtering, it is returning all the results.

$R datatype is below

As tip for future questions: don't add images of code in the question. Instead add the code as Formatted text — Theo
– Theo, Commented Nov 16, 2020 at 9:52

Mathias R. Jessen · Accepted Answer · 2020-11-16 11:34:12Z

2

{} creates a [scriptblock] literal, the value of which will always evaluate to $True when cast to [bool].

Remove the {} around the comparisons inside the filter block:

$filteredRows = $R |Where-Object {$_.db_sync_state -eq 'NOT SYNCHRONIZING' -or -not $_.is_failover_ready}

As Gert Jan Kraaijeveld mentions, you can use () to group the individual comparisons if required:

$filteredRows = $R |Where-Object {($_.db_sync_state -eq 'NOT SYNCHRONIZING') -or (-not $_.is_failover_ready)}

edited Nov 16, 2020 at 11:34

answered Nov 16, 2020 at 9:49

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gert Jan Kraaijeveld Over a year ago

If you like to structure the filter (I personally do) you can use parentheses: $filteredRows = $R |Where-Object {($_.db_sync_state -eq 'NOT SYNCHRONIZING') -or (-not $_.is_failover_ready)}

Mathias R. Jessen Over a year ago

@Hussain That's great! Please consider marking the answer "accepted" by clicking the checkmark on the left

Collectives™ on Stack Overflow

Need help on where-object in powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related