Function queryDoc

Query document with a query language

The usage of query language for example we have a document looks like the following

    {
    "firstName": "John",
    "lastName": "Doe",
    "age": 28,
    "pets": [
      {"name": "Rexy rex", "kind": "dog", "likes": ["bones", "jumping", "toys"]},
      {"name": "Grenny", "kind": "parrot", "likes": ["green color", "night", "toys"]}
    ]
   }
Copy

1. Query one document from collection

const queryStr = '/* | limit 1'
const resultSet = await queryDoc<Profile>(collection, queryStr)
Copy

2. Query documents with filter

const queryByName = '/[firstname="John"]'
const resultSet = await queryDoc<Profile>(collection, queryByName)
const queryByFirstAndLast = '/[firstName="John"] and [lastName="Doe"]'
const resultSet = await queryDoc<Profile>(collection, queryByName)
Copy

3. Query documents with filter and projection

// only query the firstName and lastName
const queryByName = '/[firstname="John"] | / {firstName, lastName}'
const resultSet = await queryDoc<Profile>(collection, queryByName)
Copy

4. Query documents with filter and aggregate count

// only query the firstName and lastName
const queryByNameAndCount = '/[firstname="John"] | count'
const resultSet = await queryDoc<Profile>(collection, queryByNameAndCount)
Copy