> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Drillthrough Query

> Reference for the `DTQuery` query type in a DEE order, used to run a drillthrough extraction with `pivotId`, `locations`, `measures`, and pagination through `firstResult` and `maxResults`.

## JSON structure

```json theme={"languages":{"custom":["/engine/python-sdk/0.9/languages/pycon.tmLanguage.json"]}}
"queries" : [
  {
    "@type": "DTQuery",
    "pivotId": "",
    "context": {
      "key": "value"
    },
    "locations": [
      "a|b|c|d",
      "x|y|z"
    ], 
    "measures": [
      "measure1",
      "measure2"
    ], 
    "isFormatted": true, 
    "firstResult": 0,
    "maxResults": 1000
  }
]
```

## Property details

| Property    | Values                              | Default Value |
| ----------- | ----------------------------------- | ------------- |
| pivotId     | Name of Cube                        |               |
| context     | Map - Context values                |               |
| locations   | List of String locations            |               |
| measures    | List of String - Measure names      |               |
| isFormatted | Boolean                             | True          |
| firstResult | Integer - index of first result     |               |
| maxResults  | Integer - Maximum number of results |               |