Support for $meta: 'textScore'

[jgutix]

Suggestion

I assume $meta: 'textScore' is not supported, so far I tried the following:

let references = await this.referenceRepository.find(
    {
      fields: {name: true, city: true, /*score: {meta: 'textScore'}*/}, //Error: Type '{ meta: string; }' is not assignable to type 'true'.
      where: {
        '$text': {search: param.reference},
        // score: {meta: 'textScore'} //500 MongoError: unknown operator: $meta
      },

      /*order: {
        score: {meta: 'textScore'} //Error: Type '{ score: { meta: string; }; }' is not assignable to type 'string[]'.
      }*/
    }, /*{score: {meta: 'textScore'}}*/); // doesnt work

Mostly what stop the implementation here is the type constraint on fields and order filters.

As a workaround I had to access directly to the mongodb's driver as shown here: https://gist.github.com/jgutix/71cbb8a9f5946ecd57328862154e3c15

Use Cases

Most of the time will go hand on hand with the use of $text search

Examples

Following the syntax from mongo driver:

let references = await this.referenceRepository.find(
    {
      fields: {name: true, city: true, score: {meta: 'textScore'}}, 
      where: {
        '$text': {search: param.reference},
      },
      order: {
        score: {meta: 'textScore'},
      }
    },);

Acceptance criteria

TBD - will be filled by the team.

[agnes512]

We're working on Repository.execute method that allows raw queries, see loopbackio/loopback-next#3342. I think once it is implemented, it would be a good workaround.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[agnes512]

See https://loopback.io/doc/en/lb4/Executing-database-commands.html

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been closed due to continued inactivity. Thank you for your understanding. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository.