We plan to use your search api for very specific queries, like “unassigned tasks” or "floating tasks (not in any project).
My question is…
Can I trust the “sort_by” ?
You mention that we can use sort_by parameter, and the default value is “modified_at”.
I tried it, and look at some results I got:
“2019-07-12T06:40:52.185Z” <---- ???
So, it looks like I can’t use that method for paging.
You also mention that we should use created_at for paging, instead of modified_at.
I tried it with the same data, it looks ok.
Is it always “safe” to use the created_at? I tried a few queries, and results looks fine, but I’m not 100% sure they are always.
I really prefer to use the modified_at, as I can compare with my local cache and stop querying when I reach an in-cache task. I can’t do that using created_at ordering.
Did I found a bug, or is it a known issue that we must live with?