FAMILY-HISTORIAN-USERS-L Archives

Archiver > FAMILY-HISTORIAN-USERS > 2002-09 > 1031482212


From: "David W Pacey" <>
Subject: RE: [FHU] Re: Query Data Missing
Date: Sun, 8 Sep 2002 11:50:12 +0100
In-Reply-To: <HPEDJEBNFLMCIJNMIKAMAEMKCPAA.john.hanson@one-name.org>


After re visiting this problem, I have now managed to get al the data
into the results window by adding multiple instances of each field on
the columns tab, much the same as Simon advised with the expressions and
changing them to INDI.CENS[2].PLAC, INDI.CENS[3].PLAC etc etc. But this
is very untidy, and if I query on 1851, it returns one record for each
person with an entry for 1851, along with those persons entries for
every succeeding census. If I query on 1901, it returns one foe each
person with an event for 1901, along with all their precedeing events.
Whilst this does work and return the correct data, it is not what I
really wanted.

Hope this helps anyone else with similar problems.

Regards,

Dave Pacey

-----Original Message-----
From: John Hanson [mailto:]
Sent: 07 September 2002 22:09
To:
Subject: RE: [FHU] Re: Query Data Missing


Dave

The easiest way around your problem is to create a custom event for each
census. Thus you have an event for the "1841 Census", "1851 Census" and
so on. You can then run the query solely against the 1901 census.

Also makes it easier to check which censuses you have missing for
anyone.

Regards
John Hanson
Member of the Society of Genealogists (www.sog.org.uk)
Member of the Guild of One Name Studies (www.one-name.org)

-----Original Message-----
From: David W Pacey [mailto:]
Sent: 07 September 2002 19:24
To:
Subject: RE: [FHU] Re: Query Data Missing


Simon, the query below does work, as you say, I run the query, it now
returns the names of the 98 people I now have with a 1901 Census Event,
BUT, if the 1901 census event is not the first event, the query window
is filled with the details of the first event. i.e. 1851 in my case.
This is not what I want, nor what I expect. If I run a query on 1901, I
want every column to be filled with the details for 1901, not Joe Bloggs
has an event in 1901, the place ref is HO107/ blah blah blah, I need it
to tell me that Joe Bloggs in 1901 was at RG13/ blah blah blah.

Have I missed something Else Simon ?

Dave Pacey

-----Original Message-----
From: Simon Orde [mailto:]
Sent: 06 September 2002 11:07
To:
Subject: [FHU] Re: Query Data Missing


Dave Pacey wrote:

>> I have now entered 44 Events for the 1901 census, and only 22 of them
show up in a query based on CENS_DATE

Dave used the following filter to find Individual records which have a
1901 census entry:

Add if %INDI.CENS.DATE% contains text ["Which Year?"].

If you click on this filter and look at the expression in the field at
the bottom of the filter window, you will see that the expression is
shown as %INDI.CENS[1].DATE%. This is because if you don't specify the
instance for a given tag, Family Historian assumes you want the first
instance. And this is why the query doesn't give you what you want,
Dave. It is looking for Individual records where the FIRST census entry
only contains the year you specify. But what you're after is an
individual record where ANY census record contains the year you specify.

To get the result you want, you need to decide what the maximum no. of
census entries anyone could have (let's assume that this is 6), and
change your filter list to specify all of them: e.g.

Add if %INDI.CENS.DATE% contains text ["Which Year?"].
Add if %INDI.CENS[2].DATE% contains text ["Which Year?"].
Add if %INDI.CENS[3].DATE% contains text ["Which Year?"].
Add if %INDI.CENS[4].DATE% contains text ["Which Year?"].
Add if %INDI.CENS[5].DATE% contains text ["Which Year?"].
Add if %INDI.CENS[6].DATE% contains text ["Which Year?"].

Its very important that you use exactly the same parameter label (in
this case "Which Year?") each time, so that you only have to type in the
year once, when you run the query.

Incidentally, its quite easy add the same filter 6 times. You select
the first filter, change the expression to show the right instance
value, and then click 'Add'. Change the instance value again and click
'Add' again. You don't have to retype any of the other details.

Although this works, it is not very elegant. I have added the following
to the Wish List: you should be able to specify a 'wildcard' instance so
that you can check ALL occurrences of census entries in one line
(alternatively, perhaps, if you don't specify an instance value, this is
interpreted as 'any instance' - at least in filter expressions).

Incidentally, don't assume that census entries (or any other event
entries) are in date order. e.g. if a person has a census entry for the
1881 census and one for the 1901 census, they are not necessarily stored
in that order. The 'first instance' means the first, as ordered within
the record - not the first in date order. There is already a wish-list
item relating to storing of events in date order, but at present you
have to order them manually yourself if you want them to be kept in date
order (the order that you see events in the Events tab of the Property
Dialog is different - by default they are displayed here in date order,
but you choose other orders to display them in, by clicking on any of
the column headings).

Simon Orde
List Administrator and Family Historian designer

______________________________


==============================
To join Ancestry.com and access our 1.2 billion online genealogy
records, go
to: http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237

This thread: