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:
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 (
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 a 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 each request
Now, you know how to create a query, specify a condition, limit the number of results and enable sorting items.