Filtering sometimes alters existing row order

#1

Hi, I found that filtering results will be ordered if you filter by <,<=,> or >=. See pic:

image

Where
Order1 = thisTable.Filter(Value<4)
Order2 = thisTable.Filter(Value!=4)

Desired outcome would be Order1 = [a,c,b]

I suppose this for performance reasons, but it breaks usability for cases where you need to keep strict row ordering (like tasks dependencies).

1 Like