Javascript convert array to object to use in Find in Mongoose

Question

I'm trying to do a dynamic filter building for a search in Mongoose.

I got an array containing various filters, and I would like to use them in this.mySchema.find ({QUERY}) as follows:

[
  { name: { '$eq': 'John' } },
  { surname: { '$regex': '.*t', '$options': 'i' } }
]

Now I would like to search by all filters as below

const query = this.customerModel.find(findFilters);

But I am getting the error below

Parameter "filter" to find() must be an object, got [object Object],[object Object]

I tried converting this to an object, but I'm getting something that I can't use either

{ ...findFilters }

Result:

{
  '0': { name: { '$eq': 'John' } },
  '1': { surname: { '$regex': '.*t', '$options': 'i' } }
}

I also tried this:

const result = {};
findFilters.forEach(e => result[e] = {});

But I got something that also doesn't work in Find and the filters don't work during the search

{ '[object Object]': {} }

So, how can I use my array of filters in the Find method?

Robby Cornelissen · Accepted Answer · 2022-07-25 08:52:14Z

2

You need to reduce() to a single object:

const filters = [
  { name: { '$eq': 'John' } },
  { surname: { '$regex': '.*t', '$options': 'i' } }
];

const filter = filters.reduce((a, v) => ({...a, ...v}), {});

console.log(filter);

answered Jul 25, 2022 at 8:52

Robby Cornelissen

98.6k23 gold badges154 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

g_m Over a year ago

I used your help to answer my own question in another thread and to share my solution. stackoverflow.com/questions/73101686/…

Ilijanovic · Accepted Answer · 2022-07-25 09:03:18Z

0

Your result is an pending promise

you need to use an async function and use await:

const query = await this.customerModel.find(findFilters);

Or .then()

this.customerModel.find(findFilters).then(res => {
   console.log(res);
})

answered Jul 25, 2022 at 9:03

Ilijanovic

15k4 gold badges29 silver badges63 bronze badges

4 Comments

g_m Over a year ago

I have the await in the next line return await query.exec();

Ilijanovic Over a year ago

@g_m you dont posted it

g_m Over a year ago

True, since I was focused on the Find and filtering, but yes you are right regarding to the mongoose and the async/await. Thank you

g_m Over a year ago

I put the (almost) complete code in answer to my own question in this thread: stackoverflow.com/questions/73101686/… I will be glad if you have any suggestions for my solution that I shared there...

Collectives™ on Stack Overflow

Javascript convert array to object to use in Find in Mongoose

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related