Sample Data

Overview

If you select the “Load Sample Data” box, it will create a sample database and reports.

IMPORTANT : If you load the Sample Data, you will need to restart Tomcat in order to pick up sample data.

../../_images/tomcat-restart.png

Dashboard

The sample reports are available on the Dashboard

../../_images/sample-dashboard.png

Sample Database

The sample database, beedatabase, is taken from the QFieldCloud Simple Bee Project:

beedatabase=# \dt
             List of relations
 Schema |      Name       | Type  | Owner
--------+-----------------+-------+--------
 public | apiary          | table | admin1
 public | fields          | table | admin1
 public | spatial_ref_sys | table | jrv
(3 rows)

Sample Data Source

The included sample Data Source is a JNDI connection to the beedatabase:

../../_images/sample-data-source.png

Sample Reports

Three Sample Reports are created

  • Simple Bee Report - this is a basic chart report

../../_images/simple-bee-report.png
  • LOV Parameter - This is a basic report using a single LOV (List of Values) Parameter

../../_images/lov-report-0.png
  • Query Parameter - This is a basic report using two Query Parameters

../../_images/query-report-3.png

Sample Schedules

A sample Schedule is created for each report.

Note: These Schedules, do not have email activated. You can edit them to include email delivery to test email functionality.

../../_images/sample-schedule.png

Sample Parameters

Sample Parameters are include for the LOV Parameter and Query Parameter reports

../../_images/sample-parameter.png

Delete Sample Data

To delete the sample data:

  1. Delete Sample Schedules

  2. Delete Sample Reports

  3. Delete Sample Data Sources

  4. Drop beedatabase