Comment on page
Using the dataexplorer
The data explorer allows to select tables (aka EntityType or 'entity') and view, edit, filter and download their contents, assuming you have the right permissions.
At the top left corner of the data explorer, the name of the currently selected table is shown, as well as the description (if given).
At the top right corner, a dropdown (entity select) is shown which can be used to select the table you wish to display. For admins, a delete button is shown at the right side of the select. Clicking it will allow you to choose if you only want to delete the data or also want to delete the metadata for the currently selected table.

Dataexplorer entity select
In the upper left corner of the data explorer, below the name of the entity, a search box is shown. This search box can be used to search all your data for a certain search term.

Dataexplorer search
Directly below the search box, the currently active attribute filters are shown. They can be edited by clicking on them. The cross trailing can be used to delete the currently used filter(s). Filters can be set from the attribute selection tree which is described below. Using the checkbox in front of each attribute, the visibility of this attribute in the table can be managed. The filter icon can be used to set filters for this specific attribute.

Dataexplorer active filters
In the area with the active filters, you will also find the button to open the filter wizard. This is a popup screen that allows you to add filters for different attributes in one go.

Dataexplorer filter wizard
Any filters you use are stored in the URL as an RSQL query. This allows you to bookmark pages with certain columns and filters selected inside a specific table. For more information on RSQL operators, you can take a look at our RSQL operator documentation.
Click the edit icon and change the chromosome from 7 to 8 and save. Adding a row works the same way, only without the prefilled fields. Now, let's click the red garbage bin icon in front of a line to delete this line from the entity.
TODO: add figure

Dataexplorer tabs
The data explorer consists of multiple modules to view or process the data in different ways. These modules are described below:
The data module shows the data in a table. This table can be sorted by clicking on the headers. If your data contains references to other entities, an icon is shown to expand this reference to show the data from the referenced entity.
Every line starts, depending on your permissions, with some action icons:

Dataexplorer action buttons
- Add row:Using this button, a form will open with input for all the attributes in the entity, allowing you to create a new row.All fields will be validated based on their datatype. For example, "test" is not a valid email address.
- Edit row:Same as the add row button, but with prefilled inputs to allow you to edit a row.
- Inspect row:This button will open a form with a custom made report for this row. With the right permissions, different reports can be created using the FreemarkerTemplate entity.
- Delete row:This button can be used to remove a row from the entity.
Optionally, custom reports can be available for the selected table.
The reports functionality is made for overriding the default instance view or to add an instances tab in the Data-explorer. Overriding the views or adding a tab is possible by creating a new
FreemarkerTemplate
entity with the right name convention. This short tutorial will show you how to achieve this.There are two ways to create your own reports:
- 1.Overriding the default instance view.
- 2.Add one or more instances view tabs.
You will need:
- 1.Create a test group
- 2.Create a user; e.g. Manager
- 3.Assign the user to the group with a manager-role
- 4.Login as Manager
- 5.Import a data set: "Advanced data example" (download), using the "Advanced importer", see the Import guide.
Override the entity view
Steps:
- 1.Go to the Data Explorer.
- 2.Select the "cities" entity via the entity select dropdown.
- 3.The entity view modal is opened when you click on the }\</div>"
- 6.Repeat steps 2 and 3.
- 7.The new view will be:
Add an instances view tab
- 1.Go to the data explorer and select the "cities" entity through the entity select dropdown.
- 2.Let's upload our own template.
- 1.Go to the data explorer and select the FreemarkerTemplate entity.
- 2.Click on thebutton. In the modal you fill in:
Name:
view-Cities-entitiesreport.ftl
Value:
<link rel="stylesheet"
href="//cdnjs.cloudflare.com/ajax/libs/leaflet/0.7.7/leaflet.css"/>
<div id="map" style="width: 600px; height: 400px"></div>
<script>
function showMap() {
var map = L.map('map').setView([38, -80], 4);
L.tileLayer('//api.tiles.mapbox.com/v4/{id}/{z}/{x}/{y}.png?access_token=pk.eyJ1IjoibWFwYm94IiwiYSI6IjZjNmRjNzk3ZmE2MTcwOTEwMGY0MzU3YjUzOWFmNWZhIn0.Y8bhBaUMqFiPrDRW9hieoQ', {
maxZoom: 18,
attribution: 'Map data © <a href="http://openstreetmap.org">OpenStreetMap</a> contributors, ' +
'<a href="http://creativecommons.org/licenses/by-sa/2.0/">CC-BY-SA</a>, ' +
'Imagery © <a href="http://mapbox.com">Mapbox</a>',
id: 'mapbox.streets'
}).addTo(map);
<#list datasetRepository.iterator() as city>
L.marker([${city.get("lat")},${city.get("lng")}]).addTo(map)
.bindPopup("${city.get("cityName")}").openPopup();
</#list>
}
$.getScript("//cdnjs.cloudflare.com/ajax/libs/leaflet/0.7.7/leaflet.js", showMap);
</script>

view-Cities-entitiesreport
- 1.Click on the settings icon1. Check: Modules -> Data -> Reports ->
Yes
2. Set: Reports -> Reports ->test_cities:Cities
- test_citites is the entity name.
- Cities is the template name.