Query library

The Query Library lets you store, reuse and share Data Queries for all Data Sources in a workspace. You can create and run queries in the Query Library, and call them from any Lowcoder app. This helps you to organize and pre-define important queries for colleagues that work with you on Apps for example.

The main function of the Query Library is to create and manage reusable Queries with Versioning.

1) Create a new query

1. Click + New and select a data source. You can rename the query on demand.

Overview of Data Queries and Action Buttons to create new Data Queries

Write code and click ▶ Run to get results. The results will display in the bottom pane of the window.

You can create Data Queries for example as SQL Script for Databases

If available based on the Datasource, helping Metadata will get displayed on the right side to create Queries faster.

Input parameters

There are cases where you want to pass dynamic parameters to a query. Lowcoder supports that by introducing input configuration of a query.

Click Add in the Inputs tab in the right upper pane to add input parameters.

With the template notation {{}}, you can use the dynamic Input parameters in the Query. To test the Input Parameter, you can set test values that are directly used in the Query.

Using Input Parameters for dynamic Queries.

You can only reference variables instead of writing JavaScript code in {{}}.

To edit the name and description of the input variables, click ... and select Edit or directly click the title of the variable.

2) Publish Queries

When you finish writing a version of the query, you can publish it. Click ··· > Publish.

Queries need to get published to be usable in Apps

History versions of Queries

To view and restore the history versions of a Query, go to ··· > History version.

You can restore your current draft to a history version by selecting the target version from the history version list and clicking Restore this version. Click Exit to return to edit mode.

Version management of Data Queries

Queries may be updated on demand. You can make an adjustment to a query to a newer version and at the same time maintain the older version. Such version management is achievable in the query library. Click ··· in the top right corner to publish different versions of queries, and you can view and restore history versions.

The Query Library automatically suggests an Up-Versioning Format to choose from, (Minor to Major Version Change) so you can use semantic versioning (also known as SemVer) to name your version.

Semantiv Versioning to Data Queries

3) Using Data Queries from Query Library

In an app or module, Click + New in the Query editor in the bottom pane, then select Import from Query Library.

Select a query from the library from the dropdown list, choose your desired version and pass in the corresponding input parameters.

4) Export and Import of Queries

Export of Data Queries

You can export a Query as a JSON Definition file. This helps to use a Query across different Lowcocer installations for example, or simply as a Backup.

Be aware, that the connected Datasource of a Query may have different security credentials at different installation locations.

With "Export to JSON" you can backup a query or store it externally to use it in other Lowcoder Installations.

Import Queries

Based on the JSON Definition file, you can import Queries into Lowcoder. On the Query Library Overview Screen, you can use the Button "Import from File"

Import Data Queries from a JSON Definition File.

Permissions

Workspace Admin and members of Developers group have access to the Query Library and have read and write permissions to all queries in the library.