Formula: Filter() with custom state property is slow

Bugs & Issues
1

Not sure if it’s slow, if there’s some sort of bug, or even that I am doing it wrong.
I actually suspect it is very slow as I saw counter of different formula field “N of Archived” change after a long while.
Update: It is indeed slow. Took about 10~15 minutes and now it shows as expected.

Expected: Formula in parent that check if all children have property of state “Archived” to be true, should return true.

Result: It always shows false.

Setup:
3 entities with a Workflow extension with 3 states, where two are “Final”.

750×314 17 KB

States also have a custom field “Archived” which is true for one of the states.

480×574 13.1 KB

Formula of Parent returning Boolean. Should be true when all children have state “Archived”:
image

2

Hi!
Not sure, but suppose, that formula has to look like
Children.Filter(State.Name = “Archived”).Count() = Children.Count()

Could you please have a try?

3

Matching name on this also seems to be slow.
Here’s a full video example

4

Hello!

It seems this formula does not work at the moment. Our monitoring showed a lot of errors on your formula, and just today I added a Bug about this. So hopefully it will be fixed next week.

5

As a workaround you may add 2 formulas with count, and a third formula that would compare those 2 formulas. Lol, but should work. Sorry for inconvenience.

6

Is it intended that it is possible to return a boolean by using State.enum_name in a formula (as opposed to using State.Name = enum_name) ?
Like Polina, I wouldn’t have expected Haslien’s formula to actually work anyway…

7

As Haslien has mentioned, “Archived” is not a state name. It is a boolean field, which he added to State type. This possibility is a bit hidden on UI, but it is actually possible to add fields to Single Select Type in fibery. As Single Select(or Multi Select) internally not differs from any other type.

8

ooops, didn’t see that…my bad