Lucent Technologies Centrevu Explorer Ii Version 1.0 User Guide

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-5
3. From the Splash Screen Frame, select the Session and License Details link. 
(See the “Setting Up CentreVu Explorer II” section in Chapter 1, “Introduction” 
for details.) The following information displays:
4. Select the Use Java Plug-in check box.
5. Press the Save Settings button.
6. From the Navigation frame, select the Custom Query Builder option to launch 
the Custom Query Builder program. See the “Accessing Customer Query 
Builder” section for more details. One of two possible conditions occur:
lIf the Java plug-in is installed, the Custom Query Builder program 
displays. You can proceed to the “Accessing Customer Query Builder” 
section in this chapter.
Select Use Java Plug-inPress Save Settings 
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-6
lIf your screen display is blank after you try to launch the Custom Query 
Builder program, then the Java plug-in needs to be installed on your 
computer. Go to the next section: “Installing the Java Plug-in On Your PC.”
Installing the Java Plug-in On Your PC5
If your frame for Custom Query Builder comes up blank, you need to install the 
Java plug-in on your computer. The Java plug-in setup utility is loaded on the server 
when Centrevu Explorer II is installed. For more information, see your System 
Administrator. The following message automatically displays and prompts you to 
install Java Plug-in 1.1.1:
1. Press Ye s.  
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-7
The following information displays:
2. From the Locale drop-down box, select the language (for example, U.S. 
English). 
3. From the Region drop-down box, select the region (for example, USA).
4. Select (by highlighting) the Available Locations site you want to download the 
Java Plug-in from. 
5. Press the Install button.  
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-8
The following information displays:
When the downloading is complete, the following information displays:
6. To accept the licensing agreement, press Ye s.  
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-9
The Choose Destination Location screen displays:
7. Use the Browse button to select the destination folder where you want to install 
the Java Plug-in. The default destination is recommended.
8. Press Next to continue.  
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-10
The following screen displays:
When the Java plug-in is setup, you can access Custom Query Builder 
application. 
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-11
Accessing Custom Query Builder5
To access Custom Query Builder, select Custom Query Builder from the 
navigation frame. The following screen displays:
The Query Builder applet does the following:
lEnables you to name/rename queries.
lEnables you to use standard Windows controls when selecting items. This 
includes using Shift and Control to select multiple items, and drag and drop.
lEnables you to order items in display.
lEnables you to “hard code” query criteria.
Select Custom Query Builder 
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-12
Setting Up User-Defined Queries5
From the Navigation frame, select “User Defined Queries” to see a list of custom 
queries. Any time a custom query is created and saved, it appears in this list for 
future use. Because the Navigation frame is always available on the CentreVu 
Explorer II screen, users can access these custom reports immediately, no matter 
where they are in the application.
Once a User-Defined Query is selected in Custom Query Builder, its elements are 
defined in the Search Criteria frame on the right. 
In the following example, the elements are defined in the Search Criteria frame on 
the right.The variables for the Caller On Hold query are Caller on Hold Time and  
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-13
Answering Agent.This query will return results where the on-hold time was greater 
than or equal to 222 seconds and the answering agent was 660 in ACD #1. 
						

							   CentreVu Explorer II Version 1.0 User Guide
Custom Query Builder
Using Custom Query Builder5-14
Building Queries5
The two-column format is familiar to most Windows users and lets users create 
custom queries using any or all of the available External Call History data elements 
in the CentreVu Explorer II database. Queries can be built for multiple ACDs or for 
individual sites.
To build a query and start using Query Builder, do the following:
1. Select Custom Query Builder from the Navigator frame, the Custom Query 
Builder frame displays:
2. In the Query Name text box, enter the name of the query you want to create.
3. In the Data Filter drop-down menu, select Segment Data or Call Data. See 
Chapter 3, “Explorer Classic,” for an explanation of Segment versus Call Data.