Mongo query to filter with an array specific index based on parameters

Question

I have a few documents in a mongoDB that have the following structure

In a API web application that I am developing with spring boot I have to code the following query. I can receive a voltageLevelCode to filter register that will contains this voltage level code in the array (That it is easy) but the problem is that i can also receive a voltageLevelCode and a Type, so in this case I have to filter documents that will contains this voltage level code in the array and also WITHIN this voltage level code filter the ones that contains this type (But remember, the type within the voltage level) I have been trying to write the query but I dont know how to dynamically set the index to filter the types within this voltage level. Something like:

{"voltageLevel.<TheIndexByTheDefinenVoltageLevelCode>.types" : "X" }

Example:

public List<MyClassRepresenting> findByFilter(String type,String voltageLevelCode);

{$and: [{'voltageLevel.voltageLevelCode' : ?1 },{'voltageLevel.<HowTogetIndexForSelectingVoltageLevelCode>.types' : ?2}]}

In this case depending on the tensionLevel received the type parameter must filter according to types within this tensionLevel

Same happens to me with another query. In SQL the equivalent is the SELECT within another SELECT to select the sub registers but no idea about how to do it in mongo.

See the manual on Query an Array.

prasad_
– prasad_

2021-04-27 08:36:35 +00:00
Commented Apr 27, 2021 at 8:36 — prasad_
– prasad_, Commented Apr 27, 2021 at 8:36

GeertPt · Accepted Answer · 2021-04-27 08:38:30Z

1

When asking a question on stackoverflow, it's always interesting to include what you already tried.

I think what you need is a simple $elemMatch:

db.mycoll.find(
  { voltageLevel: { $elemMatch: { voltageLevelCode: "MT", types: "E" } } }
)

answered Apr 27, 2021 at 8:38

GeertPt

18k3 gold badges44 silver badges67 bronze badges

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

3 Comments

Gabriel García Garrido Over a year ago

No because the voltageLevelCode is another parameter. I will change that with an example. I am usisng spring boot, let me edit the question

Gabriel García Garrido Over a year ago

Check now the example, I think what you have show me it is what I am looking for, i am going to test it and if it work i will give you the points. Thanks!!!

Gabriel García Garrido Over a year ago

Yes it was was i was looking for! thanks and sorry because of not adding an example

Collectives™ on Stack Overflow

Mongo query to filter with an array specific index based on parameters

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related