Listing entity with a query containing: $or mongo operator is no more possible

[senecajs]

Listing entity with a query containing: $or mongo operator is no more possible

[rjrodger]

Thanks!
@lilsweetcaligula can we develop test to validate this fix and apply it if so?
Does it break anything else?

[lilsweetcaligula]

@rjrodger Will look into it. Thank you for the report.

[rjrodger]

let's resolve this before next release

[lilsweetcaligula]

@jeromevalentin

Again, thank you for the report. You may pass the Mongo's native qualifiers via the native$ property in a query, like so:

const products = seneca.make('products')

products.list$({
  native$: {
    $or: [{ name: 'cherry' }, { price: 200 }]
  }
}, done)

Would that work for your use case?

[jeromevalentin]

I knew that, but it implies to change a lot of existing queries in my app. That's why, I preferred to patch mongo-store like in my pull request, to remain compliant with previous version.Regards,JérômeLe 6 juin 2021 12:21, lilsweetcaligula ***@***.***> a écrit : @jeromevalentin Again, thank you for report. You may pass the Mongo's native qualifiers via the native$ property in a query, like so: const products = seneca.make('products') products.list$({ native$: { $or: [{ name: 'cherry' }, { price: 200 }] } }, done) Would it work for your use case? —You are receiving this because you were mentioned.Reply to this email directly, view it on GitHub, or unsubscribe.

[rjrodger]

@jeromevalentin Try the pattern customization below - this should solve the problem for your use case:

seneca.add('role:entity,cmd:list', function mongo_custom(msg, reply) {
  let mongo_ops = Object.keys(msg).filter(prop=>prop.startsWith('$'))
  msg.native$ = mongo_ops.reduce((a,op)=>(a[op]=msg[op],a), {})
  return this.prior(msg, reply)
})

Use this after loading the mongo-store plugin
Apologies, this code is not tested, but should give you the basic idea