7. How to build queries

In Workmaster, queries are powerful tools that allow you to retrieve, summarize, and manipulate data from Data Objects. A query is a visually designed item that connects one or more Data Objects in a meaningful way, enabling you to generate useful insights from raw data. For instance, you might want to combine customer names and the types of items they've ordered to analyze purchasing patterns by age group. Such queries can then be used in other parts of the app, like charts and graphs, to visually present the data.

This module covers the creation of two key types of queries:

1. Join Queries:

These queries connect Data Objects based on a shared field, combining related data across different entities.

For more details and step-by-step instructions on creating Join Queries, refer to the Creating Join Queries sections.

2. Union Queries:

These queries merge data from multiple Data Objects (or other queries) without requiring a shared field, allowing you to display similar data from various sources in a unified way.

For detailed steps on how to create Union Queries, check the Creating Union Queries section.

Workmaster’s visual query builder allows you to easily create and manage these queries without writing code, making data retrieval and manipulation simple and accessible.

To reinforce your understanding of building queries in Workmaster, we highly encourage you to complete Exercise 7: Creating and Testing Join and Union Queries.