The Query Builder in Wiresk is a feature design to help users in defining and obtaining data from connected apps in a structured and adaptable manner. You can see it like, a method to “inquire” with your data source about particular questions (queries) and receive precisely the information you require, structured just the way you want.
How It Works Copy Link
Query Builders are typically graphical user interfaces (GUIs) that allow users to select and filter data.
The Query Builder breaks down the process of building queries into intuitive steps, using different tabs and parameters for customization:
Tabs and Parameters Copy Link
1. Related Entities Copy Link
Link related entities in your data source (e.g., Odoo) to the primary entity you’re querying.
Example: If you’re querying “Email Thread,” you can include related records such as: The Contact associated with the Email Thread. The Companies linked to the Email Thread.
2. Configure Filter Copy Link
Narrow down the records being retrieved by specifying conditions.
Example: Retrieve only email threads where the status is “Open” or where the priority is “High.”
3. Configure Grouping Copy Link
Group the retrieved records based on certain fields or attributes.
Example: Group email threads by their assigned user or by company to organize the data.
4. Configure Columns Copy Link
Select the fields or columns of data to include in your query results.
Minimum Columns: At least 1 column must be selected to preview data.
Maximum Columns: Up to 50 columns can be included in the query results.
Error Handling: If no records are found or columns are not configured, you might see the error: “Cannot convert undefined or null to object.”
5. Configure Sorting Copy Link
Organize the retrieved records in a specific order.
Options:
Sort columns in ascending or descending order.
Define which fields to use for sorting (e.g., sort email threads by creation date or priority).
6. Preview Data Copy Link
View a sample of the records your query retrieves before finalizing it.
Default Display: Shows up to 10 records at a time, starting at record 0.
Customization: Adjust the starting record and the number of records displayed as needed.
Requirement: At least 1 column must be selected to enable data preview.
Why Use Query Builder? Copy Link
The Query Builder simplifies data retrieval by allowing users to:
- Customize queries based on specific needs.
- Visualize and validate data through previews.
- Organize data using filters, groupings, and sorting.
- Include relevant information by linking related entities.
Query Builders are a great way for non-technical users to get started with data analysis. They make it easy to access and explore data, and they can help users identify trends and patterns that would otherwise be difficult to see.
Don’t stop here! Copy Link
Explore our User Guide here.
For a complete tutorial on how to create a Flow, see “How to create a Flow in Wiresk”