- Index or Collection Used
The index or the collection that was used by the query.
- Results Retrieval Time
The time it took to retrieve the results.
include timings() to your RQL to display additional timing details in the results.
Learn more in Include Query Timings.
- Delete Documents
Click to delete all documents that match the query.
Click to view query statistics, including -
- Number of results
- Results status
- Query duration
- The index used by this query.
Either the index that was explicitly used by the query, or the internal RavenDB index that is
used for collection queries.
- An ETag representing the current state of the index used by the query.
(The ETag value changes with every change made to the documents)
Export Results as CSV File
- Click to store all query results columns in a CSV file.
- Click the drop-down and select "Export visible columns only"
to store only the columns that are currently displayed.
Click to open the Display drop-down dialog, where you can select which columns
to display and add custom columns. (See Select Visible Columns below).
- Toggle Expanded/Collapsed View
Click to expand or collapse the results view.
Select Visible Columns
To modify the displayed result columns, open the Display drop-down dialog from the Query Results view.
Custom result columns can be added, edited and removed.
- A query results column
- A custom results column
Display Dialog - Actions
Changes made in the Display dialog will take effect only when the Apply button is clicked.
- Display/Hide all columns
Check or uncheck to display or hide all columns.
- Display/Hide column
Check or uncheck to display or hide this column.
- Relocate Column
Click and drag to relocate the column.
- Edit Custom Column
Click to edit the custom column's field and alias (see Add Custom Column below).
- Remove Custom Column
Click to remove the custom column.
Add Custom Column
- a. Identify a results field that will be displayed in the custom column.
- b. Give the custom column an alias that will be displayed as the column's title.
- c. Click to add the new column and close the custom column dialog.
- d. Click to close the custom column dialog without adding the new column.
- Reset to default
Reset result columns to their original state (determined by the query).
Close the Display dialog without applying your changes.
Apply your changes and close the Display dialog.
Click for a preview of the retrieved item.
Click the ID to open this document in the Document View,
Hover over the ID to display it in text format and optionally copy it to the clipboard.
Multiple Records Result
Hover over the brackets to display the retrieved records and optionally copy them to the clipboard.
Hover over the text to display and optionally copy it to the clipboard.