Milestone Retail 2.2 - Manual (Page 12)

Milestone XProtect Retail 2.2; User’s Manual
www.milestonesys.com Page 12 Managing Queries
Managing Queries
The management of a store can identify and minimize fraud and shrinkage by using the Milestone
XProtect Retail application. As the main sources of the shrinkage or fraud are eliminated, new kinds
of fraud and shrinkage may emerge, or it can be relevant to investigate other kinds of already
existing shrinkage or fraud. This is why you can create or edit queries in the Milestone XProtect
Retail application.
Creating a Query
1. From the Query Designer menu select New to create a new query. This will open the Query
Designer.
The Query Designer offers two ways to edit queries: the SQL interface or the graphical
interface. The SQL view is a simple text editor where the SQL text can be entered. The
graphical interface resembles the one known in Microsoft Access. Both interfaces are equal
and can be used when editing a query and any changes will automatically be reflected in
both interfaces. This step-by-step description uses the graphical interface options. See
Using the SQL Interface on page 14 for a short description of this method.
Example only. When creating a new query the Query Designer is empty. The SQL interface
pane is by default not displayed. The drill down information pane is only enabled when editing
a group by query.
2. Enter the name of the new query in the Query name text box. Use a name that describes
the functionality of the query. The name must be unique.
3. Limit the result set returned from the database to the Milestone XProtect Retail application
by entering an integer in Number of results field or set it to All. Since the dataset in the