Use the Oracle Log Analytics User Interface

The Oracle Log Analytics user interface enables you to formulate your Search query.

You can use the following elements of the UI to formulate your Search query:

• Search bar: Your search query is displayed here. You can directly edit the text in this field to further refine your search results.

  The search bar grows or shrinks based on the number of lines added to the query. It can have a maximum of 21 lines and a minimum of 1 line. Some of the custom shortcuts available are:

  • Ctrl + i: Indent every line of text present in the editor. Note that the uppercase I opens the debugger.
  • Ctrl + Enter: Execute the query displayed in the editor
  • Ctrl + Space: Display the auto-complete list of options based on the cursor position
  • Ctrl + Z: Undo the last edit
  • Ctrl + Y: Redo the last edit
  • Ctrl + D: Delete current line

  Note: Do not use the SHIFT key unless specified.

  Position the cursor in the open or closing brackets to view the matching element highlighted. The elements that can be highlighted are ( ) and [ ].

  The search bar supports two different themes, color and gray-scale. You can change the themes dynamically by changing the option in the help pop-up.

• Field: The Field panel is divided into the following sections:

  • The Pinned attributes let you filter log data based on:

    • Log sources, such as database logs, Oracle WebLogic Server logs, and so on.

    • Log entities, which are the actual log file names.

    • Labels, which are tags added to log entries when log entries match specific defined conditions.

    • Upload names of log data uploaded on demand.

    By default, the entities and collection details are available in the Pinned bucket of the Fields panel for filtering. You can pin additional fields to the Pinned bucket depending on your usage. Once pinned, the fields are moved to the Pinned bucket. You can unpin any field and remove it from the Pinned bucket and move it back to the Interesting or Other bucket.

  • Based on your search and queries, Oracle Log Analytics automatically adds fields to the Interesting bucket for your quick reference. You can pin a field that’s available under Interesting bucket. The pinned field then gets moved to the Pinned bucket.

  • You can pin any field in the Other bucket and move it to the Pinned bucket. If you use a field from the Other bucket in your search or query, then it’s moved to the Interesting bucket.

    The selected options are automatically added to the query in the Search bar.

• Visualize: In this pane, you can select how you would prefer to view the search results. In the Group by field, you can decide what metrics to group the results by.

• Save: Use this button to save the search query that is currently in the Search field, to be run at a later time.

• Open: Use this button to view previously saved search queries. You can run these queries and get current results, or you can use these queries to create dashboards.

• New: Use this button to start a new search query.

• Export: Use this button to export the result of the current search query in a file of the Comma-seperated Values(CSV) or JavaScript Object Notation(JSON) format.

• Run: Use this button to run the query which is currently in the Search field.

• Time Selector: Use the Time Selector to specify the time period.

• Visualization Pane: The results of the search query are displayed in this pane. The filtered information in this pane loads when the query in the Search field is run. By clicking on any area in the chart in the visualization pane, you can drill down into the search query and update it.