Filtering sometimes alters existing row order


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


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