Use SQL in Elasticsearch to download data from the search index. All fields within Elasticsearch can be accessed using SQL.

🚧

Important Information

You can find the Elasticsearch login credentials in the searchblox.yml file, found in the following file path: `\SearchBloxServer\webapps\ROOT\WEB-INF`

## Viewing Results from Elasticsearch

Using SQL, you can view search results directly from Elasticsearch using the following URL

You can also export the results in CSV format using the following URL

## Basic Queries

Use the following queries for specific search results you need.

**Queries for specific file types**

**Queries for specific URL or filename**

**Queries for specific keywords**

**Results from multiple indices**

**Results with only URLs from indices**

**Query with ORDER BY**

**Query with LIMIT**

**Query with INCLUDE, EXCLUDE** Use exclude ('fieldname') and include ('fieldname') to exclude fields or include fields in display. Partial name of fields can be given along with * character.

## Aggregations

**Using GROUP BY and COUNT** Group by and count together can be used to determine the count of file types in results.

Group by can be also used to determine sentiment in sentiment analysis.

**Query with sum function**

**Queries with min and max functions**

**Queries with statistic functions**

## Beyond SQL features

**Query with IS MISSING, IS NOT MISSING**

**Query to search for multiple terms using IN_TERMS**

**Query to search for a specific term using TERM**

**Special queries related to statistics that can be used in Elasticsearch**