Filtering in Powershell

Question

I have an array of objects called $listy. I am looking for object for which property $_.WorkflowAssociations.Count is greater than 0.

When I select that property I can see that several objects fulfill my criteria:

$listy | select title, workflowassociations.count

However when I use where: $listy | where {$_.WorkflowAssociations.Count -gt 0} none of the objects are listed: enter image description here

I have the same issue with $_.Views.Count property. Other numeric properties seem to filter without issues. Is it because of the point (.)? Why? The property is called exactly Views.Count: enter image description here

Please post your terminal output as text (formatted as code) rather than screen captured image. It is quite a task to read through. — Srikanth Venugopalan
– Srikanth Venugopalan, Commented May 19, 2015 at 16:19

Ansgar Wiechers · Accepted Answer · 2015-05-19 16:49:15Z

2

As @EtanReisner already pointed out in the comments to your question: if you have a property name containing a dot (like WorkflowAssociations.Count) you must put the name in quotes when trying to access it via dot notation:

$listy | Where-Object { $_.'WorkflowAssociations.Count' -gt 0 }

If you don't, the term $_.WorkflowAssociations.Count will be interpreted as the property Count of a property WorkflowAssociation of the current object ($_). Which, of course, doesn't exist.

answered May 19, 2015 at 16:49

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

Filtering in Powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related