Preview: The Web Data Explorer is provided as a preview feature. Using this feature in a production purpose is not recommended; final implementation could be slightly different.
The Data Explorer provides a web interface to view and query data in your project datastore. Using this tool, you can easily browse among all your entities and search, order, or filter attribute values. It helps you to control data and quickly identify issues at any steps of the development process.
The Data Explorer relies on the
WebAdmin web server component for the configuration and authentication settings.
- configuration: the Data Explorer configuration reuses the
WebAdminweb server settings,
- authentication: access to the Data Explorer is granted when the session user is authenticated and has the "WebAdmin" privilege. When the Data Explorer is accessed through the Data Explorer menu item (see below), an automatic authentication is provided.
L'accès à l'Explorateur de données peut être désactivé à l'aide de la fonction
Opening the Data Explorer
The Data Explorer page is automatically available when the
WebAdmin web server is started.
To connect to the Data Explorer web page:
if you use a 4D application with interface, select Data Explorer... command from:
- the Records menu (in 4D stand-alone)
- the Window menu (in 4D Server)
whether you use a headless 4D application or not, you can open your web browser and enter the following address:
In this context, you will be prompted to enter the access key to open a
WebAdminsession on the server:
Using the Data Explorer
In addition to a comprehensive and customizable view of your data, the Data Explorer allows you to query and order your data.
The Data Explorer supports the following web browsers:
The minimum resolution to use the Data Explorer is 1280x720. Recommended resolution is 1920x1080.
The Data Explorer provides an overall access to the ORDA data model with respect to the ORDA mapping rules.
You can switch to the dark mode display theme using the selector at the bottom of the page:
The page contains several areas:
On the left side are the Dataclasses area and Attributes area, allowing you can select the dataclasses and attributes to display. Attributes are ordered according to the underlying structure creation order. Primary key and indexed attributes have a specific icon. You can filter the list of proposed dataclass names and attribute names using the respective search areas.
The central part contains the Search area and the Data grid (list of entities of the selected dataclass). Each column of the grid represents a datastore attribute.
By default, all entities are displayed. You can filter the displayed entities using the search area. Two query modes are available: Query on attributes (selected by default), and the Advanced query with expression. You select the query mode by clicking on the corresponding button (the X button allows you to reset the query area and thus stop filtering):
The name of the selected dataclass is added as a tab above the data grid. Using these tabs, you can switch between dataclasses that have been already selected. You can remove a referenced dataclass by clicking the "remove" icon at the right of the dataclass name.
You can reduce the number of columns by unchecking attributes in the left side. You can also switch the columns in the data grid using drag and drop. You can click on a column header to sort entities according to its values (when possible).
If an operation requires a long time, a progress bar is displayed. You can stop the running operation at any moment by clicking on the red button:
- On the right side is the Details area: it displays the attribute values of the currently selected entity. All attribute types are displayed, including pictures and objects (expressed in json). You can browse between the entities of the dataclass by clicking the First / Previous / Next / Last links at the bottom of the area.
When the ORDA model or data is modified on the database side (table added, record edited or deleted, etc.), you just need to refresh the Data Explorer page in the browser (using the F5 key, for example).
You can reorder the displayed entity list according to attribute values. All types of attributes can be used for a sort, except picture and object.
- Click on a column header to order entities according to the corresponding attribute values. By default, the sort is ascending. Click twice for a descending sort. A column used to sort entities is displayed with a small icon and its name is in italics.
- You can sort attributes on several levels. For example, you can sort employees by city and then by salary. To do that, hold down the Shift key and click sequentially on each column header to include in the sort order.
Query on attributes
In this mode, you can filter entities by entering values to find (or to exclude) in the areas above the attribute list. You can filter on one or several attributes. The entity list is automatically updated when you type in.
If you enter several attributes, a AND is automatically applied. For example, the following filter displays entities with firstname attribute starting with "flo" AND salary attribute value > 50000:
The X button allows you to remove entered attributes and thus stop filtering.
Different operators and query options are available, depending on the data type of the attribute.
You cannot filter on picture or object attributes.
With numeric, date, and time attributes, the "=" operator is selected by default. However, you can select another operator from the operator list (click on the "=" icon to display the list):
With date attributes, you can enter the date to use through a datepicker widget (click on the date area to display the calendar):
When you click on a boolean attribute area, you can filter on true/false values but also on null/not null values:
- null indicates that the attribute value was not defined
- not null indicates that the attribute value is defined (thus true or false).
Text filters are not diacritic (a = A).
The filter is of the "starts with" type. For example, entering "Jim" will show "Jim" and "Jimmy" values.
You can also use the wildcard character (@) to replace one or more starting characters. Par exemple :
|A filter with||Finds|
|Bel||All values beginning with “Bel”|
|@do||All values containing “do”|
|Bel@do||All values starting with “Bel” and containing “do”|
If you want to create more specific queries, such as "is exactly", you may need to use the advanced queries feature.
Advanced queries with expression
When you select this option, a query area is displayed above the entity list, allowing you to enter any expression to use to filter the contents:
You can enter advanced queries that are not available as attribute queries. For example, if you want to find entities with firstname attribute containing "Jim" but not "Jimmy", you can write:
Vous pouvez utiliser n'importe quelle expression de requête ORDA, comme documenté avec la fonction
query(), avec les limitations ou différences suivantes :
- For security, you cannot execute formulas using
- Placeholders cannot be used; you have to write a queryString with values.
- String values containing space characters must be embedded in double quotes ("").
For example, with the Employee dataclass, you can write:
firstname = "Marie Sophie" AND manager.lastname = "@th"
Right-click in the query area to display the previous valid queries: