* Query not picking up all events

Homeless Posts from the old forum system
Locked
avatar
juliawalsh
Newbie
Posts: 4
Joined: 01 Feb 2006 14:09
Family Historian: None

Query not picking up all events

Post by juliawalsh » 01 Feb 2006 14:37

Hello all,

I'm one of the the original FH users, although I have to confess to moving to another program, some years ago due to some early niggles. I have recently been  checking out the latest upgrade, and have been quite impressed. However I have hit a big stumbling block today.

I'm experimenting with the query functions, and have downloaded the census record checklist one from the query store, as it seemed exactly what I was looking for. My only modification has been to include my custom census tags, as I have one for each year.

I'm using a gedcom imported from Genbox, which seems to have transferred without too many issues.

However after printing out my 28 page report, it became obvious that a lot of census places were not being included in the result set. The strange thing is that for people for who I know I have a full set of census records the result set is only showing some of them. Looking at the record window for such individuals, there seems no apparent reason why this should be, all the census places are showing in the events list. If I produce an narrative report for one of these individuals, all the census events are included (and look identical to previous/later years that the query has picked up..)

I can see no obvious pattern to the ones that are not being picked up, random years, random places, but there must be a reason for it

Any idea what is happening?

Julia[frown]

ID:1321

avatar
RSellens
Famous
Posts: 172
Joined: 07 Aug 2005 17:25
Family Historian: V6.2

Query not picking up all events

Post by RSellens » 01 Feb 2006 16:51

Hi Julia,
I am a little bit confused by what you are saying. Do you mean that you have defined custom events for the cenus years, and its the place attribute of the custom event thats not appearing in the result set ?

Richard

User avatar
Jane
Site Admin
Posts: 8441
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Query not picking up all events

Post by Jane » 01 Feb 2006 16:51

Can you post the query you are using and a screen grab of one of the records which is not displaying.

avatar
juliawalsh
Newbie
Posts: 4
Joined: 01 Feb 2006 14:09
Family Historian: None

Query not picking up all events

Post by juliawalsh » 01 Feb 2006 17:36

Thanks for replying. Query and screen dump uploaded via the link below - hope I got that right!

Julia

User avatar
Jane
Site Admin
Posts: 8441
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Query not picking up all events

Post by Jane » 01 Feb 2006 17:40

Nearly you did not press the insert button to add them to the thread.

http://www.fhug.org.uk/images/uploads/J ... klist1.fhq

I could not find the screen dump, just two copies of the query.

avatar
juliawalsh
Newbie
Posts: 4
Joined: 01 Feb 2006 14:09
Family Historian: None

Query not picking up all events

Post by juliawalsh » 01 Feb 2006 18:38

Fingers crossed..


Image

avatar
TimTreeby
Famous
Posts: 168
Joined: 12 Sep 2003 14:56
Family Historian: V6.2
Location: Ogwell, Devon
Contact:

Query not picking up all events

Post by TimTreeby » 02 Feb 2006 01:02

Julia,
It looks to me as though, you have it defined as a Custom Attribute, whereas you are asking Query to show an Event (Indi.Event) rather than an Attribute (Indi.Attr).

Check that you don't have them defined as both a Custom Attribute and Custom Event.

Tim

avatar
juliawalsh
Newbie
Posts: 4
Joined: 01 Feb 2006 14:09
Family Historian: None

Query not picking up all events

Post by juliawalsh » 02 Feb 2006 07:46

Thanks so much, you were exactly right...

It would be interesting to know
a) how you could tell that

b) why it should have imported/exported like that when thay appear as identically set up events in the other program.

It might possibly help me avoid other issues in the future.[smile]

Thank you again

Julia

User avatar
Jane
Site Admin
Posts: 8441
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Query not picking up all events

Post by Jane » 02 Feb 2006 08:24

I am guessing the problem was in the alternate program.

When V3 eventually turns up, it allows indexing events by date so removes the need for custom census events as you can query etc based on the year of the census.

avatar
TimTreeby
Famous
Posts: 168
Joined: 12 Sep 2003 14:56
Family Historian: V6.2
Location: Ogwell, Devon
Contact:

Query not picking up all events

Post by TimTreeby » 02 Feb 2006 12:32

Not sure why imported diferently but I could tell it was different because i also have my Census details set up as a Custom Event one for each year and it looks different. See screen shot

Image

Compare this to your screen shot which is set up as an attribute.

Locked