CRM Analytics Apex QueryBuilder Examples

Build simple or complex SAQL queries using QueryBuilder.

QueryBuilder is the core of the CRM Analytics Apex feature set, so let’s take a closer look.

1. Here’s a simple count query:

Output:

2. Query selecting specific attributes and using aliases.

Output:

3. Query using a filter condition.

Output:

4. Query with a limit statement.

Output:

5. Query with an order statement.

Output:

6. Query with a union statement.

Output:

7. Executing the query to get the result set via Query Builder.

8. Example of grouping by a specific dataset attribute.

Output: