I am currently working on creating a function or method that can generate sorting options from an array. One example is when using Mikro-ORM, where there is a type called FindOptions<T> that can be filled with the desired sorting order for database queries.
The FindOptions interface is defined as:
export interface FindOptions<T, P extends string = never> {
populate?: readonly AutoPath<T, P>[] | boolean;
orderBy?: (QueryOrderMap<T> & {
0?: never;
}) | QueryOrderMap<T>[];
limit?: number;
offset?: number;
...
}
When directly interacting with FindOptions, I can specify my Entity as the generic
const MikroORMSoryBy: FindOptions<TimeEntryEntity>To set up my sort by fields, I would do the following:
const MikroORMSoryBy: FindOptions<TimeEntryEntity> = {
orderBy: { EntryDate: QueryOrder.ASC, Id: QueryOrder.ASC, UserId: QueryOrder.ASC }
};
I am able to list my fields without any issues, even as strings within the object.
orderBy: { 'EntryDate': QueryOrder.ASC, 'Id': QueryOrder >ASC, 'UserId': QueryOrder ASC }
My question is, how can I dynamically build the orderBy object based on input provided in an array, rather than hardcoding the field names? This would allow me to create a reusable function for generating sorting options.
What I ideally want to achieve is something like the following:
const Fields: Array<string> = ['EntryDate', 'Id', 'UserId'];
Fields.forEach( (OneField: string) => {
orderBy[OneField] = QueryOption.ASC; // ???
});