* Witness reporting

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
gsward
Diamond
Posts: 68
Joined: 11 Mar 2011 14:47
Family Historian: V6

Witness reporting

Post by gsward » 16 Dec 2014 18:35

I have witness on some of my facts both as a linked record to an individual in my database and some as name-only. Currently these are witness to marriages and wills.

How can I report on instances of an individual occurring as a witness in a custom query? Ideally for both types of event. The event it relates to is of course that of another individual.

Thanks.

User avatar
PeterR
Megastar
Posts: 1054
Joined: 10 Jul 2006 16:55
Family Historian: V6.2
Location: Northumberland, UK

Re: Witness reporting

Post by PeterR » 16 Dec 2014 18:48

The Fields available for Witness> and for Witness (name only) are listed in the Columns tab for Fact Queries.
Peter Richmond (researching Richmond, Bulman, Martin, Driscoll, Baxter, Hall, Dales, Tyrer)

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

Re: Witness reporting

Post by tatewise » 16 Dec 2014 19:07

To expand on Peter's answer the following explanation may help.

Witness Individuals have no actual Facts to identify them as Witnesses, because the Facts are linked to the Principles.
So you have to start with a Facts Query that includes all Facts.
In the Columns tab add the Witness tag details as Peter said.
You then apply Row filters, to first exclude Facts without Witnesses, then select only Facts with a desired Label perhaps via a user Prompt, and finally filter by Witness Individual or by Witness Name also via user Prompts.

If you need further help with this then please ask.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

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

Re: Witness reporting

Post by tatewise » 24 Dec 2014 19:45

A snag with the above approach is when there are several Witnesses to one Fact.
Each Witness needs a separate Column for that instance.
e.g.
%FACT._SHAR[1]>NAME[1]% for 1st Witness,
%FACT._SHAR[2]>NAME[1]% for 2nd Witness, and so on...
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
Jane
Site Admin
Posts: 7781
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Witness reporting

Post by Jane » 26 Dec 2014 09:53

I suspect this will be a good one for a plugin. The next week is a bit hectic, but if not one else want's to give it a go, I will take a look in the New Year.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
Jane
Site Admin
Posts: 7781
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Witness reporting

Post by Jane » 27 Dec 2014 12:34

List all Witness Events.fh_lua
(4.34 KiB) Downloaded 155 times
I have attached a quick plugin, you select the list of people (one or more) you want to find Witness events for and it returns a list of all the Facts they are listed against.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

avatar
gsward
Diamond
Posts: 68
Joined: 11 Mar 2011 14:47
Family Historian: V6

Re: Witness reporting

Post by gsward » 27 Dec 2014 15:44

Thank you I can confirm that works for me.

avatar
Jenny143
Gold
Posts: 25
Joined: 06 Oct 2009 13:14
Family Historian: V6

Re: Witness reporting

Post by Jenny143 » 26 Jan 2015 17:24

When I try to run the List all Witness Events Plugin I get the following error message
[string"C:\ProgramData\Calico Pie\family\Historian\...":152:fhOutputResultSetColumn - Invalid arguement (2). No changes have been made to data records.

Have I done something wrong - I have tried deleting and re-installing but get the same message.

Jenny :|

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

Re: Witness reporting

Post by tatewise » 26 Jan 2015 18:23

Jenny, do you have only Name only (_SHAN) Witnesses, because an inspection of the script suggests the Plugin only deals with Linked Individual (_SHAR) Witnesses, and fails when there are none.

What were you hoping the Plugin would list?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Jenny143
Gold
Posts: 25
Joined: 06 Oct 2009 13:14
Family Historian: V6

Re: Witness reporting

Post by Jenny143 » 26 Jan 2015 21:07

Hi Mike,
That explains it. I was hoping to create a list of all name only witnesses. I can create queries for bmd events but my problem lies with trying to find a way of listing all 'extra' people in census households in one list.
Jenny

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

Re: Witness reporting

Post by tatewise » 29 Jan 2015 14:55

Jenny, the attached Plugin Lists all Name Only Witnesses.
Attachments
List Name Only Witnesses.fh_lua
(3.56 KiB) Downloaded 144 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Jenny143
Gold
Posts: 25
Joined: 06 Oct 2009 13:14
Family Historian: V6

Re: Witness reporting

Post by Jenny143 » 29 Jan 2015 20:55

Mike,
Thank you this is absoultely fantastic, exactly what I was looking for.
Very many thanks.
Jenny :D

Post Reply