Performing a group by query, Drilling down a group by query – Milestone Retail 2.2 User Manual
Page 9

Milestone XProtect Retail 2.2; User’s Manual
www.milestonesys.com
Page 9
How to Investigate
will not trigger any action. (Please see Retail Application Settings on page 16 for instructions on
how to connect to the surveillance system.)
Performing a Group By Query
Performing group by queries will present you with a window like this:
When performing a group by query each line in the table represents a set of transactions. In the
example above each line in the table represents the void items made by each employee.
The Number_Of_Items column in the table shows the number of void items made by the specific
employee and the last column gives a graphical representation of the number of void items.
When clicking on a line in the group by table each transaction contained in the group will be shown
in a drill down table.
Drilling Down a Group By Query
When you drill down into an aggregated (group by) query result, the transactions found in the
group by query are presented like this: