Access Database from Page

There are two ways to access the database from a page created using the page designer.

• Integrating with Microflow.

• Using Local database only for mobile application

Access Database from Page using Microflow. Microflow provides a database node for accessing data from the database. You can configure the connection type and the command for interacting with DB like insert, update, select or delete data.

After preparing Microflow, Integrate Page with Microflow. Read the steps from Page Integration with Microflow. Once the page is integrated, it can interact with the database through microflow.

Access Database from Page using Local Database option The following example shows how to query data from the local database to show on the screen.

First, create the table on the local database and prepare data. Read the steps to create a table from the Local database. (You can link the local database to database server to sync the data from server to local database)

Go to the page where you want to display this data. Select PageContent level and then configure the action to query data as shown in the image below.

Now go to the element on the page which displays this dataset. Click to open Connect to Data Panel on the parent object. Select Datasource as Database and choose the table that you configured on the action flow before.

Click to open Connect to Data Panel on the child object. Select Datasource Database, enable Data from a parent, and select the appropriate Data field.

Save the page and use Play me to see the results.