* Census flag query question

Older V3 Queries please post for any version in the General Forum
Locked
avatar
hls99cat
Silver
Posts: 8
Joined: 16 Jun 2010 22:42
Family Historian: None

Census flag query question

Post by hls99cat » 10 Oct 2012 21:51

Hello! I followed your tutorial to apply a 1911 flag using a custom query, and it all seemed to go swimmingly. Until I opened the diagrams and the flags seem to have been applied to parents and husbands of the named people, even if they were not in the census or dead well before 1911. I cleared ALL 1911 flags before I started.

Any ideas please - I would be very grateful! Thanks

ID:6520

User avatar
tatewise
Megastar
Posts: 24181
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Census flag query question

Post by tatewise » 10 Oct 2012 22:12

It may be possible that your Custom Query did not use quite the correct filter on the Rows tab.
Can you please post here your Rows tab parameters.

Perhaps you did not enter the [year=1911] special index correctly.

Also check that no Census Event exists with a date in 1911 for the problem parent & husband Individuals.
Check the All tab of these Individuals and confirm that they have the 1911 Census Flag.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
hls99cat
Silver
Posts: 8
Joined: 16 Jun 2010 22:42
Family Historian: None

Census flag query question

Post by hls99cat » 11 Oct 2012 11:22

Hello tatewise and thank you for your reply.

General Tab.
Condition: Exclude if
Expression: INDI.CENS[1]
Operator: is null

Relations tab.
condition: Exclude if
Relation: ancestor
Max generations: (is blank)
of: This individual

List tab
exclude if....the rest is blank.

avatar
hls99cat
Silver
Posts: 8
Joined: 16 Jun 2010 22:42
Family Historian: None

Census flag query question

Post by hls99cat » 11 Oct 2012 11:41

GOT IT!!! Thank you - although that was the second time I had run the query, I must have forgotten to do the year=1911 bit after indi - thanks!!

Locked