> For the complete documentation index, see [llms.txt](https://avbravo-2.gitbook.io/jmoordb/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://avbravo-2.gitbook.io/jmoordb/capitulo-8/introduccion-cap5/consulta-compleja.md).

# Consulta compleja

**Consulta** 

Entre fechas y supervisado = false

```json
db.getCollection('limpieza').find( { $and: [ {fechahorasupervision: {$gte: new Date("2020-08-01T00:00:00.000Z")}}, {fechahorasupervision: {$lte: new Date("2022-12-31T23:59:59.999Z")}} ], supervisado: false })
```

**Queremos consultar por supervisado = true, user.1.iduser=37 y que este entre fechas**

```json
db.getCollection('limpieza').find( { $and: [
    {fechahorasupervision: {$gte: new Date("2020-08-01T00:00:00.000Z")}},
    {fechahorasupervision: {$lte: new Date("2022-12-31T23:59:59.999Z")}}
  ], supervisado: true, 'user.1.iduser':  37 })
```

![](https://1490144122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6bBVlJX-GjApa1%2Fuploads%2FEaKvvTb6K5LD4Eriqdk6%2Fddd.png?alt=media\&token=ef22f483-5f30-435b-b3ff-374a8326a066)

Documento tiene esta esructura

```
// Some code
```

![](https://1490144122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Lc1Wg6bBVlJX-GjApa1%2Fuploads%2FhBlIpi1YVytDdrFK4xSD%2Fff.png?alt=media\&token=5f386dbc-ffb3-49b8-9a1d-2c826e3cedbd)