# Query Options

Here are some of the most common keys you can pass in the struct of options to control how the query is executed. Please check the [API Docs](http://apidocs.ortussolutions.com/cfcouchbase/2.0.0) for the full list.

| Option        | Description                                                                                                                                                                                                                    |
| ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `sortOrder`   | Specifies the direction to sort the results based on the map function's "key" value. Valid values are ASC and DESC.                                                                                                            |
| `limit`       | Number of records to return                                                                                                                                                                                                    |
| `offset`      | Number of records to skip when returning                                                                                                                                                                                       |
| `reduce`      | Flag to control whether the reduce portion of the view is run. If false, only the results of the map function are returned.                                                                                                    |
| `includeDocs` | Specifies whether or not to include the entire document in the results or just the key names. Default is false.                                                                                                                |
| `startkey`    | Specify the start of a range of keys to return.                                                                                                                                                                                |
| `endkey`      | Specify the end of a range of keys to return.                                                                                                                                                                                  |
| `group`       | Flag to control whether the results of the reduce function are grouped.                                                                                                                                                        |
| `keys`        | An array of keys to return. For complex keys, pass each key as an array.                                                                                                                                                       |
| `stale`       | Specifies if stale data can be returned with the view. Possible values are: `OK` - (default)stale data is ok, `FALSE` - force index of view, and `UPDATE_AFTER` potentially returns stale data, but starts an asynch re-index. |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://cfcouchbase.ortusbooks.com/usage/executing-queries/query-options.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.