Can't use orderBy or sortBy as well?

[cmroanirgo]

I'm having trouble figuring out how to use sortBy() or orderBy() with with():

This works fine:

db.tables.where('someIdx').equals(someIdx)
	.with({other: 'otherId'})
	.then(function(results) {
		...
	});

Adding sortBy fails:

db.tables.where('someIdx').equals(someIdx).sortBy('date')
	.with({other: 'otherId'})
	.then(function(results) {
		...
	});

Currently, my only workaround is to manually sort the results manually, which seems incorrect.

I understand why this occurs, because sortBy() returns an array (rather than staying as a collection). Unfortunately, dexie-relationships also converts the data to an array and makes the whole thing impossible to use...

It would be better if the data could be kept as a collection. (imho sortBy() suffers the same issue)

[jayarjo]

@cmroanirgo did you find any workaround?