Structure
There are four different parts of a cbQL:
• SELECT keyword and projection (optional). When viewing additional information about a group of tracker items, it is possible to add aggregation functions and filters or their alias names.
• WHERE keyword and a condition list. The WHERE keyword is required if the cbQL contains SELECT keyword.
• GROUP BY keyword and a field or an alias list (optional). It allows to make groups from the result of the conditions based on the definition after the GROUP BY keyword.
• ORDER BY keyword and a field list and direction (optional). If you order the result, you can add the necessary fields and the direction of the order.
SELECT assignedTo as 'Assigned to' WHERE storyPoints > 2 GROUP BY assignedTo ORDER BY summary DESC