View Data in the Datastore

Show datastore values and make simple changes to the datastore.

  1. From the Build menu, click Content.

  2. Select the Datastores tab.

  3. Click View Data for the datastore.

    Content Items View

    Description

    Card

    Hover over the datastore card and click View Data, or select the datastore and then from the Actions menu, click View Data.

    List

    Click View Data for the datastore.

  4. Use the menu to tune the display.

Menu

Action

Description

Insert Data

Click to insert a record.

The datastore accepts all UTF-8 characters.

Export Data

Click to export the datastore to a local CSV file.

Select the records to export if you don't want to export the whole datastore.

Refresh Click to refresh the view of the datastore.

Filter Click to filter the display of records. Use the Filter.

Column Settings Click to show or hide columns of data. This is particularly useful when the datastore has lots of columns.

These menu items are not always on display.

Menu

Action

Description

Delete Records

Select the records to delete then click the Delete Records icon.

Update Record

Click a datastore cell value to make it editable. When finished editing, click the Update Record icon.

Sort

Sort the datastore by any column, values ascending or descending, using the up and down arrows to the right of the column header. Whenever you sort the datastore, your view returns to page one.

Filter

Follow these guidelines when building query conditions:

  • Click Add Node to begin.

  • Select from the standard operators, such as equal to, not equal to, starts with, and doesn't end with.

    For string and audio columns, is empty, and is not empty are available.

  • Create complex queries with nodes and groups.

  • Click Preview to ensure the right records are matched.

Note:

While using preview, click the column settings icon to show or hide columns in the datastore.

Maximum Number of Records Returned

Studio fetches at most 100,000 records to view data.

When you open the datastore, Studio fetches the most recent 100,000 records.

When you change the sort order on any column (except _timestamp), Studio sorts on the most recent 100,000 records. If you change the sort order on the _timestamp column to ascending, Studio fetches the oldest 100,000 records from the datastore.

If you filter the datastore and the datastore has more than 100,000 records, Studio fetches the records according to the query filter as follows:

  • Where the datastore is the system log, and the operator is AND, Studio fetches 100,000 records according to _task_id and contextual filters at the top level. Studio applies any additional filters in the query and all filters inside groups to these fetched records.

  • Where the datastore is the system log, and the operator is OR, Studio fetches the most recent 100,000 records for the _task_id. Studio applies any additional filters in the query to these fetched records.

  • Where the datastore is other than the system log, and the operator is AND, Studio fetches 100,000 records according to the contextual filters at the top level. Studio applies any additional filters in the query and all filters inside groups to these fetched records.

  • Where the datastore is other than the system log, and the operator is OR, Studio fetches the most recent 100,000 records. Studio applies any additional filters in the query to these fetched records.

The contextual filters are as follows.

  • _task_id

  • _uuid

  • _timestamp

  • _id