Query Builder is a UI Widget, helps you manage how data items are retrieved. You can limit the number of items, specify conditions.
Before creating a query with Query Builder, make sure you've already Connect to your database.
This document will show you:
Query condition is used to set a condition, by comparing a value (to
Filter property). For example, the
created date must be after Jun 10, 2020 (
To specify query condition, from Query Builder widget:
Filtersection, choose a comparing property (or column)
Condition, choose a condition (e.i
When getting data, you can sort the result items
descending, based on the comparing property.
To enable sorting, from Query Builder widget:
Filtersection, choose a comparing property (or column) if not already selected
Sort, choose either
To limit the number of result items, from Query Builder widget:
Max items for each request
Now, you know how to create a query, specify a condition, limit the number of results and enable sorting items.
We've learned that growing a successful business is hard, your idea needs to be flexible to evolve while lacking resources.
Our goals focus on providing a set of tools, make it easier to change, help you save time and money to evolve your business