Nitrite/Flutter: Sorting stuff I'm running into

[381outrageousDoors]

Hey, I'm implementing sorting and trying to sort with each of my fields and noticed that my enum field can only be sorted by the index, which makes sense because that is what is being stored.

I can sort my enums and have it work off that, but it would be a pain when I decide to add more enum values because I believe that would require migrations to each object's stored index to that enum's new index

Any way to use a mapper with SortingOptions, so that it sorts by the enum's name instead of index?

Also, I'm trying to sort by a key-value pair in a map, but not all my objects have that key-value pair, and it ends up not sorting my result. When I sort by a key-value all my objects have, it sorts as expected.

I'm thinking that when it can't find the value in the map, the sorting operation breaks. I don't believe that's intentional, so something like a sortingOption for what to do when null values are encountered would be appreciated.

Thank you!

[anidotnet]

Any way to use a mapper with SortingOptions, so that it sorts by the enum's name instead of index?

You can write your own entity converter in that case and for the enum fields you store the name values in the document instead of its index, then you will get what you are looking for.

I'm thinking that when it can't find the value in the map, the sorting operation breaks. I don't believe that's intentional, so something like a sortingOption for what to do when null values are encountered would be appreciated.

Nitrite has a default sorting order for Null values like other databases which is - null has lowest of values. In descending order sort, null values goes at the last and in ascending order sort, null values comes first.

Could you please give me a small reproducible code, so that I can better understand what your looking for and debug it to find the cause?

[381outrageousDoors]

Figured out my issue and I'm not sure if this is actually feasible. Short version: I'm trying to access a DateTime value in a map that I've set using an enum key, but I don't know how to write out the field it needs to pull the value out of the map to sort with.
I'm trying something like below:

get() {
    final fields = SortableFields()
      ..addSortedField('properties.dateMap[(index, 0)]', SortOrder.descending);
    _findOptions = FindOptions(orderBy: fields);
 
    return repository.find(findOptions: _findOptions);
  }

In properties, I have a map of <enum, DateTime> and I'm trying to sort by the DateTime value. My issue is that I don't know what to put in the field portion for SortableFields to be able to get the value it needs to sort with

I'm able to sort with 'properties.id' but trying to get the value from the dateMap in properties returns a null value with the field inputs I've been trying.
For example, using 'properties.dateMap[(index, 0)]' gives a null value in the _compare method, but I can see the value in the NitriteDoc

Picture has (name, Created On) because I tried rolling my own EntityConverter using name instead of index to see if that would help, but didn't.

I've tried
properties.dateMap[(index, 0)]
properties.dateMap[((index, 0))]
properties.dateMap[(name, Created On)]
properties.dateMap[((name, Created On))]
properties.dateMap{((name, Created On))}