The ability to filter by empty files has been added. But within Formulas it still takes two formulas. One to calculate the Count, and one to filter based on the count.
Hello.
Can you clarify here please 
.
You can write the formula: Files.Count() = 0. Which will effectively check that files collection is empty. Same way as we do for any collection field (Files are no different here)
You are right. Sorry! I thought it was possible to check if a collection is empty with this formula function.
When using Filter() in formula, I can not include a Files.Count. So I thought this would save a formula. But posted this mainly because I thought was behaving differently to other collections. Thanks for the prompt reply!
Right, unfortunately aggregation functions inside Filter are not allowed.
It’s just internal Fibery Api limitation, we will improve this one day.
2 Likes