Skip to main content

Features

1. SQL MODE

  • Enables developers to run complex SQL analytical queries on CtrlB

Dataset Selection

Steps To Use
  • Shift from default ‘Query Builder’ tab to ‘SQL’ tab
  • Type in any complex analytical SQL directly & click on ‘Run Query’

2. QUICK MODE

Improve your query speed with quick mode; query only the important fields you want

Dataset Selection

Steps To Use
  • Enable Quick mode toggle
  • Select the important fields from Attribute Side panel at LHS by clicking on the ‘Lightning’ icon next to the fileds
  • Then ‘Run Query’ to experience faster queries

3. Recent Queries

Access past run queries directly from here and avoid typing same queries again

Dataset Selection

4. Saved View

  • If a set of particular query filters are used repeatdly then the user can save the query.
  • User can choose to keep it private or public by enabling the 'Visible to Organization'.

Dataset Selection

5. Stop Query

  • If a particular query is taking longer time then to stop executing current query, click on 'Stop Query' button and execution will stop.
  • Toast 'Query Successfully Stopped' will be shown.
  • User can then change filters and click on 'Run Query' button again to Rerun.

Dataset Selection

6. Log summary column

  • Users can create a log summary in the table by selecting most important attributes and available attribute will be shown (in order of selection).

  • The attributes can be selected from dropdown when clicked on pencil icon beside 'Summary' column.

  • Min 2 attributes must be selected for summary and at max 5 attributes can be selected.

Dataset Selection

7. Interactive Filtering on Histogram

  • Drag on the bar graph to zoom in on a specific time range and view logs related to that period.

Dataset Selection

8. Expandable sidepanel

  • The side panel can be expanded to give you more space to view your logs using the small blue icon at the edge of sidepanel.