MongoDB: how to compose a select query on two parameters of a multidimensional array?

Question

MongoDB

There is a collection:
{name: 'Name 1', params: [{id : 'Sale', value : 'No'}, {id: 'Warranty', value: 'Yes'}]}
{name: 'Name 2' , params: [{id : 'Sale', value : 'Yes'}, {id: 'Warranty', value: 'No'}]}
{name: 'Name 3', params: [{id : 'Sale' , value : 'Yes'}, {id: 'Warranty', value: 'Yes'}]}
{name: 'Name 4', params: [{id : 'Sale', value : 'No'}, {id : 'Guarantee', value: 'Yes'}]}
How can I make a query so that I can select for example everything, where Sale = Yes
Do this {'$and' : [{'params.id' : 'Sale'}, {'params.value' : 'Yes'}]}
But the selection also includes those records where Sale = No, and Warranty = Yes
PS: Params nesting can be any

Answer 1

{ params: { $elemMatch: { id : "Распродажа", value : "Да" } } }

Here with explanations