CountOf or having usage?

[PavelJurasek]

Hi,

I'm wondering if it is possible to use these functions to filter out entities that do not have any related records, e.g.: Select all galleries that have at least 1 photo added to it.

I expected something like Spec::gt(Spec::countOf('photos'), 0) would work but it doesn't. I also unsuccessfully tried Spec::gt('COUNT(photos)', 0).

Thanks!

[Nyholm]

Interesting use case. As you discovered, that is not supported atm. But I believe that feature should be on the wish list.

[peter-gribanov]

Now you can using functions in specification:

$spec = Spec::gt(Spec::COUNT('photos'), 0);