Sorting/Ordering reports by timestamp in Mongo is not working

[Velcrow81]

In reporting, it is not possible to order by date (timestamp) in an acending order. Only decending. Below is an example of reports ordered by timestamp ascending:

The same problem occurs if we run queries directly against Mongo in Studio 3T:

I got the timestamp from the top 5 documents and they have the same problem as in the frontend. Descending works but ascending is apparently random:

Ascending
637013082263970000
637012111923990000
637012506804020000
637019928394040000
637020792304050000

Descending
637041960614550000
637039299834670000
637035012714420000
637034735494500000
637033988174520000

The timestamp is stored as an array and that might be causing problems for the sorting, but I do not know why descending is working

Timestamp" : [
 637013082263970000, 
 0
 ]

Sorting should work on timestamp for both descending and ascending order

[gardnk]

From MongoDB docs:

With arrays, a less-than comparison or an ascending sort compares the smallest element of arrays, and a greater-than comparison or a descending sort compares the largest element of the arrays.

So the ascending sort doesn't work because the smallest element of the array is always 0 in this case.

MongoDB has it's own Timestamp type, but our timestamp is stored as an array of NumberLong.
My guess is this needs a fix from the dolittle framework @woksin @jakhog ? Or can we specify mongo types ourselves?