Milestone Retail 2.2 - Manual (Page 14)

Milestone XProtect Retail 2.2; User’s Manual
www.milestonesys.com Page 14 Managing Queries
8. Save the query.
Using the SQL Interface
To activate the SQL interface select Pane > SQL from the Query Designer menu or click the SQL
Pane icon in the toolbar.
This will add a text box in the bottom left corner of the Query Designer tab showing the SQL for the
query. This SQL text can be altered manually. When you have finished editing this text you can
click anywhere outside the SQL interface pane and the graphical editor will reflect the changes you
have just made.
Editing a Query
To edit an existing query, on the Query tab select the query in the Query list. Then select Edit from
the Query Designer menu. This will open the Query Designer tab.
Edit the query in the Query Designer until it fits your requirements and save it.
See also Creating a Query on page 12 for more information.