Database Source

Last update: Edit

1 Introduction

If Database is selected as the data source for a widget then an object or objects shown are retrieved directly from the database with a query. This data source is also supported in offline applications in which case the data will come from the database on the mobile device.

You can filter data shown with the help of database constraints. However, if you want to restrict data not for a single widget, but for several, you may want to apply access rules for entities instead of database constraints. This way you know that the objects will always be constrained by these rules . Access rules will also be applied when executing microflows which saves you from repeating constraints.

2 Properties

2.1 Entity (Path)

The Entity (path) property specifies the target of the database query. If you have a top-level data widget, Entity (path) will get objects of the selected entity directly. If you have a nested data widget, you can also select an entity of a parent data container. In this case objects are retrieved following the association path and the association is parsed as an extra constraint in the database query.

Data Source Example

Show search bar is only available for data grids. You can select if and when the Search bar of the data grid is shown.

Value Description
Never No search bar or search button are ever shown. Effectively disables search.
With button (initially open) An end-user can open and close the search bar using the Search button; the search bar is initially open.
With button (initially closed) The user can open and close the search bar using the search button; the search bar is initially closed.
Always The search bar is always visible and cannot be close, nor is there a search button.

Default value: With button (initially closed)

The Wait for search property is available if Show search bar is set to With button (initially open) or to Always.

When Wait for search is set to Yes, the grid will remain empty of contents the end-user initiates a search. This can be useful if the target entity contains an extremely large set of objects but most mutations only require a subset of the data. Waiting for search will ensure that no database query is performed until the desired subset is specified, thus skipping the initial loading period associated with major data retrievals.

Default value: false

2.4 Constraints

Constraints allow for custom, hard-coded limitations on the data displayed. This constraint will be applied on top of security constraints. For example, if your entity has an access rule that makes it read-only for the user and/or has an XPath constraint, the XPath constraint will be applied first.

Each constraint consists of an Attribute, an Operator, and a Value:

Constraint Example

Multiple constraints will limit the data even more (the logical operator AND). There is no way to use the logical operator OR in constraints, but you can switch to an XPath data source and create an XPath constraint.

3 Read More