DAS Data Explorer

Data Explorer is the single-point of user interactions, which allows you to carry out different operations related to data analytics. Data Explorer allows you to search and view tables in the Data Access Layer (DAL) of WSO2 DAS, and browse their records. You can authorize and restrict users on the functions that they carry out using the Data Explorer, by setting permissions on the user roles assigned to them as shown below.

For instructions on setting the following permissions, see Adding and Managing Users and Roles.

Viewing records of a table

Follow the steps below to view records of existing tables using the message console.

  1. Select the Table Name of which you want to view records.
  2. Click Search. You view the all records of the selected table as shown below.

Searching for records of a table

You can browse existing tables in the WSO2 DAS and search for records by filtering them based on a date range or by filtering them using a query as explained below

Searching by a date range

Follow the steps below to search for records of an existing table based on a particular date range.

  1. Select the Table Name of which you want to search and view records.
  2. Select By Date Range for Search.
  3. Enter the From and To dates to define the date range within which you want to search the records.

Searching by a primary key

Follow the steps below to search for records of an existing table using primary keys.

  1. Select the Table Name of which you want to search and view records.
  2. Select By Primary Key for Search.
  3. Enter the values of the primary keys defined when you persisted the event stream, of which you want to search the records.
  4. Click Search. You view the filtered records of the selected table as shown below.

Searching by a query

Follow the steps below to search for records of an existing table using an Apache Lucene query.

  1. Select the Table Name of which you want to search and view records.
  2. Select By Query for Search.
  3. Enter the Apache Lucene query which defines the search criteria based on which you want to search the records for Search Query.
  4. Click Search. You view the filtered records of the selected table as shown below.