Is there a "children.count" property for selectors that accounts for visibility?

[J_Szwarga]

Here's my query:

$pages->find("template=collection, sort=-children.count");

However it is sorting my collections based on the total number of children. I've searched all over and cannot find a way to take visibility into account for this property. (I don't want to include any hidden or unpublished children). 

While rendering the child items in the html, I use

$collection->numChildren(true) 

to show the number of visible, published children. But the sorting is all messed up because it includes all the hidden and unpublished.

 

There's got to be some way to find the count of  visible children in an efficient manner, without retrieving every single record to check it with a for loop??

[dragan]

Did you try to add the include parameter in your selector?

https://processwire.com/docs/selectors/#access_control