* 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
Famous
Posts: 114
Joined: 11 Mar 2011 14:47
Family Historian: V7

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: 1119
Joined: 10 Jul 2006 16:55
Family Historian: V7
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: 22096
Joined: 25 May 2010 11:00
Family Historian: V7
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: 22096
Joined: 25 May 2010 11:00
Family Historian: V7
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: 8169
Joined: 01 Nov 2002 15:00
Family Historian: V7
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: 8169
Joined: 01 Nov 2002 15:00
Family Historian: V7
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 254 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
Famous
Posts: 114
Joined: 11 Mar 2011 14:47
Family Historian: V7

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: 22096
Joined: 25 May 2010 11:00
Family Historian: V7
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: 22096
Joined: 25 May 2010 11:00
Family Historian: V7
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 234 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

avatar
obstinatesnooper
Silver
Posts: 6
Joined: 12 Aug 2018 18:36
Family Historian: V6.2
Location: USA
Contact:

Re: Witness reporting

Post by obstinatesnooper » 13 Jul 2021 16:08

Jane wrote:
27 Dec 2014 12:34
List all Witness Events.fh_lua

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.
This is awesome!

I added two columns for the record ids of the record and owner to the plugin output by trial and error (to use unique ids to link data in Excel & Gephi analysis), but I don't understand what ":Clone()" is or if it is needed.

column headings

Code: Select all

	 tblResults.source = {title='Source'}
	 tblResults.target = {title='Target'}
column values

Code: Select all

        tblResults.source:set(id)
        tblResults.target:set(fhGetRecordId(ptrOwner:Clone()))
Searching for "clone()" in the KB brings up only stuff about cloning facts and diagrams, not anything about plugins.

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

Re: Witness reporting

Post by tatewise » 13 Jul 2021 16:27

In the Tools > Plugins window where you Run and Edit... plugins, click the How to Write Plugins button and checkout the help for The Family Historian API > Objects > Item Pointer > Clone.
Alternatively, when editing a plugin script, click Help > Family Historian API to reach the same help pages.

It is important to Clone pointers otherwise any change to the original pointer will also affect the copy pointer.

For general advice see FHUG Knowledge Base https://fhug.org.uk/kb/topic/plugins/writing-plugins/.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
obstinatesnooper
Silver
Posts: 6
Joined: 12 Aug 2018 18:36
Family Historian: V6.2
Location: USA
Contact:

Re: Witness reporting

Post by obstinatesnooper » 18 Jul 2021 15:34

Jane wrote:
27 Dec 2014 12:34
List all Witness Events.fh_lua

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.
It seems this isn't compatible with v7? I keep getting an error:
[string "C:\Program Data\..."]:61: attempt to index a nil value (global 'arg'). No changes have been made to the data records
I looked for it in the plugin store but couldn't find it, so I fiddled with the code a bit and got it to run in v7. Revised attached below, and sorry if this stomps on toes.
List all Witness Events v7.fh_lua
(4.61 KiB) Downloaded 1 time

Post Reply