Page Comparison

Introduction

Index Search is primarily used in Drillthrough and Spreadsheet.

Drillthrough

Index search in Drillthrough allows users to make complex queries to a Fact Query via the use of the Elastic Search Query (DSL Query String) feature.

Click here for details about the Elasticsearch query syntax.

...

It will show the raw query result in the drillthrough grid.

1. Select an Index Group and any corresponding Factquery (or Factqueries) name to view data from the Factquery.

       Image Modified

       2. We  can also select multiple Factqueries in order to query from them. The result of selecting multiple Factqueries will be a union of the data in both the Factqueries in the Drillthrough. However, if both the Factqueries have different schema then the data of the other Factquery will show up             blankup blank.

       3. User can then filter by a selected date with various date options. Please note that the Default date option corresponds to the Date specified in Global settings. It may not work if your fact query doesn't have the same Date as the Default Date in Global settings.

        4. The DrillThrough has a helper dialog which can help you build complex queries which can be accessed with the help of the Grid Image Modified icon on the bottom right hand side of the Indexsearch Configuration Dialog. With this dialog users can generate a query sent to Elastic search to further                 drill further drill down their searches.

         Image Modified

         The corresponding query for the above selected options will look like the one below:

          Image Modified

          Users can also modify their queries to get the appropriate result. For e.g. instead of an OR clause can be used in case of an AND clause below.

          Image Modified

          Please note that a wrong query may result in an incorrect or no results in the DrillThrough.

          Also dates need to be input in a standard format of yyyy-MM-ddThh:mm:ss (the same format with which dates are stored in ElasticSearch) for the Query String search to work properly otherwise the DrillThrough will return an incorrect result. Below is an example of a date search. This                  This does also mean that if eMite is set in a timezone other than UTC the Date search has a higher chances of failing.

...