Query Manager

(See the program Help file for more information.)

This manager allows you to query the data you have stored in your various GenBases. You can query against one or a Group of GenBases.

There are 21 official queries provided (as at version 3.05). You can write your own queries and base them on the official ones. The official queries are prefixed with the word GENP. For example, GENP_Indiv.

You can vary the logical tests and vary the fields that get displayed. The display then can be output to various formats such as Excel and HTML.

There is no need to learn specialised computer science query languages as the Query Manager hides all that complexity from you.

 

You can make your own queries based on the standard GENP ones. For example, choose GENP_IndivBirthPlace and then create IndivBirthPlace.

To do this click on GENP_IndivBirthPlace in the 'Available Queries' box.

Type the name IndivBirthPlace in the 'New Query' edit box.

Click the 'Save New' button.

 

You can not delete a standard GENP query. You can not save a new query commencing with the word "GENP".

The Search Fields are logically grouped together. For example, the EarlyDate and BirthDate are in the Indiv group.

To get correct results in the Grid you need to ensure that:-

There is at least one Search Field from a group represented in the Exported Fields list. For example, if the Exported Fields have fields from the Indiv and Name groups then there must be at least one Search Field from the Indiv group and at least one Search Field from the Name group.

 

Combinations of groups of Fields. You can combine Indiv and Media fields. You can combine Indiv and Name fields. You can combine Indiv and Place fields.

Query Manager

In this query GENP_IndivPlace there are 6 rows of output. This query has been run against the Keipert GenBase. Although there are 6 rows of output it pertains to only 5 people. Note - Jane Jones has two sets of places associated with her - the highlighted row and the 1st row.

 

 

Running a standard query

 

We are going to run the standard query GENP_Indiv. This query provides some basic details on the individual.

Choose menu General then menu item Query Manager.

From the Available tabsheet either click or use the down arrow to navigate to the row "GENP_Indiv". On the right hand side you will see the Description of this standard query.

Look at the Search tabsheet. The default GenBase selected is Keipert. You can change this by clicking on the More button and choosing another GenBase. We will leave the fields in the Fields tabsheet and the captions in the Captions tabsheet alone.

Click on the Grid tabsheet. The listing is now generated as a grid of data. There are 7 columns in the grid. From the left is RecNum (record number) then the Indiv (individual's name) etc. At the base of the grid is the number of Rows. You can click on the Report button (at the base of the grid) to export your data in various ways. Note that the Lists button is disabled. This means that you can not create a list from the grid data.

If you want you can change a search on a GenBase to that of a search on a Group. Go back to the Search tabsheet. Click the More button against the Group and choose Group DemoAll from the Group List dialog. Now click on the Grid tabsheet. Note that there are many more rows as individuals from each GenBase in the Group are now included.

 

Output individuals to a list

 

It is possible to output individuals to a list from a query.

To do this requires certain fields to be present in the Grid. What fields are required?

You need to ensure that the following 5 fields are in the list of Exported Fields on the Fields tabsheet:

Name [or variations]

RecNum (Record Number)

Sex

GenBase

GID (GENP Identifier).

 

Then you will be able to make a List. These 5 fields are the ones you see in any list in the List Manager.

There is some variation in the choice of the Name field. You can choose one of the following:

Name

Indiv

IndivSurname

SortSurname.

 

How do you know that the correct fields have been chosen?

Look at the Fields tabsheet. There should be a green tick against the question "Can I create a List from these Exported Fields?".

The standard query "GENP_IndivName" has the corect fields in its Exported Fields list. The following graphic shows the Exported Fields from the standard query "GENP_IndivName".

Query Manager - exported fields

Note that the field Indiv (highlighted) has been chosen as the name variation.

The other indication that you have chosen the correct fields is that on the Grid the Lists button is enabled.

If you click the Lists button the individuals in the Grid are output to the default list for the Query Manager.

If you click the Lists More button you will see the List Manager. At the bottom of the List Manager you can choose to either Replace the items in an existing list or Add to the items in an existing list. Before adding you can create a New List.

 

Order Tabsheet

 

Introduced in version 3.05 is ordering of output data. There is a new tabsheet named Order to assist you in placing an order on the output data. You can choose to order data in ascending or descending order.

Ordering of data is optional.

When you edit the Order By fields ensure that after you have changed the sort order that the change has been made.

When you edit the sort order a small down arrow appears. This means you are still editing. Click in the field name column or another row for the editing to be completed.

 

Ordering is only enacted when the Order By checkbox is checked. You can quickly switch from ordering to no ordering by unchecking this checkbox.

The Order By checkbox is automatically checked when you add the first Order by field. The Order By checkbox is automatically unchecked when you delete the last Order By field.

A common use of ordering is to order the output on Record Number (RecNum). If you do this in ascending order then the output would be like record 1 followed by record 2 then record 3. If you do this in descending order then the output would be like record 3 followed by record 2 then record 1.

(2009)

Share |