Query Wizard - Select Columns (Standard Query)

Top  Previous  Next  

 

You have already selected the Subject that you wish to base your Query on and that you wish the Query to be a standard one, however the Subject may contain data Fields that you do not wish to be included in your Query.  The Query Wizard - Select Field form lets you choose which Fields will be included in your Query, and in what order they will be included.

clip0082

SELECTING FIELDS

 

The screen displays a List of the fields that are 'Available' for selection, and a list of Fields that you have already selected.  To select a Field, first highlight it by Clicking on it in the Available list, and then click on the '>' button to move it over to the Selected list. You can also do multiple selections by holding the mouse button down and dragging the mouse over the required fields.

 

You can also use the box immediately above the Field lists to enter part of the Field name that you are wanting to Add/Remove. As you type in this box you will notice that the list of Fields will be filtered based on the what you have typed. This is a useful way of searching for the field you want if there is a large number of Fields in the Subject you are using for this Query.

DESELECTING FIELDS

 

You can deselect any of the Selected Fields, or change their listing or order in the Selected list.  While you can deselect multiple Fields you can only change the order of one field at a time.

 

First highlight the Field/s in the Selected list in the same way that you can highlight fields in the Available list.  Then click on '<',  If you click on '<<' all Field/s will be de-selected and moved back into the Available list.

 

DATA PREVIEW

 

You can also select any fields displayed in either the Available Fields or Selected Fields list and select the Data Preview Icon. This gives options for adding or removing fields from each of the list but it also gives you the option to preview some of the data in the Data Preview screen.

 

 

 

Once you have finished making your selections click on the 'Next >' button to move on to the Query Wizard - Sort Criteria form.

 

 

 


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0