Running Queries in the Web Console

The standard SQL is a declarative language that allows you to obtain the data you want without having to specify the detailed process of data processing. However, the standard SQL has many constraints on processing unstructured data, as well as the drawback that the description of the streaming process is not natural.

Logpresso has inherited the design philosophy of Unix-based operating systems that maximize simplicity, cohesiveness, reusability, and flexibility. One command performs the smallest and the simplest task, but combining multiple commands helps effectively process complex and unstructured data.

The following sections describe how to use queries in the Logpresso web console and the basic structure of Logpresso query.

Query Menu Path by Product

You can use queries in the Logpresso web console. There are many interfaces where you can input query string, but a separate interface for running queries is also provided. The query menu by product suite is as follows:

  • ENT, STD: Query or Query > Query
  • MAE, SNR: Analysis > Query

Executing a Query

To execute a query, input the query string in the input box and click Run. The query string may be a short statement using a single command or may consist of multiple commands where data is passed from one to the next using pipes (|).

Query Keyboard Shortcuts

Query input box supports following keyboards shortcuts.

Query Keyboard Shortcuts

FunctionKeyboard shortcut
Executing a queryCtrl+Enter or Shift+Enter
Viewing the command list and helpCtrl+Space
Automatic alignment and indentation of queryCtrl+Shift+F

For viewing the command list or help (Ctrl+Space), the operation varies depending on whether you input a command.

  • If you press the shortcut keys without providing a command, you can see the command list appears.
  • If you press the shortcut keys after providing a command, you can see a list of options available appears.

Automatic alignment and indentation of query commands help the user understand long query commands written across multiple lines by automatically applying indentations and line breaks. This shortcut is only supported by MAE and SNR.