Query Block
Purpose:
The query blocks help us get data from the database, so that we can use it in out interface.
The following fields describe the queries coming from collections.
The integration queries contain the Execute input and Value output and a variety of dynamic fields.
Input
Note: in most cases, one of limit, first, or last arguments is required
-
Execute
Sends the query(request), when a true value is provided. When the query returns(response), the output is passed to the value -
Id: Text (String)
Id is a unique key that refers to one record in the database. This input field is used when we want to get further information about a record in the database. -
Limit: Number
When we get a response from a query we might receive a bunch of results. This value is of type number and is used in order to limit the number of results that we receive. -
Offset: Number
When we get a response from a query we might receive a bunch of results. These results arrive in a specific order every time. This value is of type number and is used in order to skip the first n results. -
First: Number
When we get a response from a query we might receive a bunch of results. This value is of type number and is used in order to receive only the first n results. -
After: Text (String)
When we get a response from a query we might receive a bunch of results. This value is of type text, it receives an Id as a value and is used in order to receive only the results that are after the record with this specifc Id. -
Last: Number
When we get a response from a query we might receive a bunch of results. This value is of type number and is used in order to receive only the last n results. -
Before: Text (String)
When we get a response from a query we might receive a bunch of results. This value is of type text, it receives an Id as a value and is used in order to receive only the results that are before the record with this specifc Id. -
Sort[]: List (Array)
When we get a response from a query we might receive a bunch of results. Those results are already ordered according to one of their fields. We have the ability to sort them in any way that we want just by manipulating the sort[] value. -
Filters: Object
When we get a response from a query we might receive a bunch of results. We have the ability to filter them and get only the results that we want. -
Query: Text (String)
We use the query field mainly for searching. It represents a regular expression that returns only the results that have that pattern.
For more information on Filtering, Pagination & Sorting
Output
Value
Outputs when execute is activated. Some of the type of the value can be: