*Weird Results in Query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Gowermick
Megastar
Posts: 546
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Weird Results in Query

Postby Gowermick » 08 Oct 2018 10:39

I have created a query to list all marriages in a specific location (Warrington), which seems to work quite well, Except for the rogue entry in the result set

George Hatton, is listed, with a marriage place of Toxteth, despite his marriage record being empty.
(His marriage is deduced from from census and GRO Registration of children, so may not have taken place)

His wife's first marriage took place in Toxteth, but why is this showing against George?

the data reference is as follows:

%INDI.~SPOU[1]>FAMS[1]>MARR[1].PLAC:SHORT%

Which to me, seems to indicate place of First Marriage of First Spouse (hence Toxteth), but how can I change this to refer to place of George's first marriage?
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.0.5(x64), Firefox 61.0.1(64Bit) & Thunderbird 52.9.1
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 14439
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Weird Results in Query

Postby tatewise » 08 Oct 2018 11:04

Yes, %INDI.~SPOU[1]>FAMS[1]>MARR[1].PLAC:SHORT% refers to his 1st Wife's 1st Family record.

Use %INDI.FAMS[1]>MARR[1].PLAC:SHORT% to obtain his 1st Family record.
Use %INDI.FAMS[2]>MARR[1].PLAC:SHORT% to obtain the 2nd Family record, and so on for largest partnerships in your data.
But this technique needs a Column per Family instance.

That is all based on an Individual Query but may be much easier using a Fact Query with a Marriage Label filter.
See Knowledge Base > Query:Fact ~ All Facts Filter by Date, Label, or Text for guidance.
Mike Tate ~ researching the Tate and Scott family history.

Gowermick
Megastar
Posts: 546
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Weird Results in Query

Postby Gowermick » 08 Oct 2018 11:55

Thanks Mike,
Thought it was something simple like that. :D
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.0.5(x64), Firefox 61.0.1(64Bit) & Thunderbird 52.9.1
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com


Return to “General Usage”

Who is online

Users browsing this forum: No registered users and 19 guests