Get data with Query Buidler

Query Builder is a UI Widget, helps you manage how data items is retrieve. You can limit number of items, specify condition.

Before creating a query with Query Builder, make sure you've already Connect to your database.

This document will show you:


Create query with Query Builder

Note that Query Builder only available for forms, containers

  1. Choose the element and navigate to (Connect panel)
  2. Under Connect to table > Data Query, choose Create
  3. On the Query Builder modal, choose your Database and Table
  4. You can specify condition, sort or limit items
  5. Click Create to create a new query!


Specify query condition

Query condition is used to set a condition, by comparing a value (to Filter property). For example, created date must be after Jun 10, 2020 (created > 06-10-2020)

To specify query condition, from Query Builder widget:

  1. Expand Filter section, choose a comparing property (or column)
  2. Then expand Condition, choose a condition (e.i (==) equal, (>) greater)
  3. Enter a comparing value, and your condition is setup


Sorting query items

When getting data, you can sort the result items ascending or descending, based on a the comparing property.

To enable sorting, from Query Builder widget:

  1. Expand Filter section, choose a comparing property (or column) if not already selected
  2. Then expand Sort, choose either Ascending or Descending
  3. And you've enabled sorting query items


Limit the number of item results

To limit the number of result items, from Query Builder widget:

  1. Expand Limit section
  2. Enter a limit number under Max items each request
  3. And you've enabled query limiting


Now, you know how to create a query, specify a condition, limit the number of results and enable sorting items.