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. 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.”
2. Configure Columns Copy Link
Edit Columns: 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.”
3. 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 and sorting.
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”