* Witness reporting

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
gsward
Famous
Posts: 146
Joined: 11 Mar 2011 14:47
Family Historian: V7

Witness reporting

Post by gsward »

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: 1135
Joined: 10 Jul 2006 16:55
Family Historian: V7
Location: Northumberland, UK

Re: Witness reporting

Post by PeterR »

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: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

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: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

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: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: Witness reporting

Post by Jane »

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: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: Witness reporting

Post by Jane »

List all Witness Events.fh_lua
(4.34 KiB) Downloaded 376 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: 146
Joined: 11 Mar 2011 14:47
Family Historian: V7

Re: Witness reporting

Post by gsward »

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 »

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: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

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 »

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: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

Jenny, the attached Plugin Lists all Name Only Witnesses.
Last edited by tatewise on 18 Feb 2023 11:30, edited 1 time in total.
Reason: Attachment deleted as better version is attached later.
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 »

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 »

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: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

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 »

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.
Last edited by tatewise on 23 Feb 2023 16:33, edited 1 time in total.
Reason: Attachment deleted as a better version is in the Plugin Store.
avatar
Lovelyclemmy
Silver
Posts: 6
Joined: 08 Feb 2010 12:07
Family Historian: V7

Re: Witness reporting

Post by Lovelyclemmy »

The List Name Only Witnesses plug-in seems to have the same problem as the List All Witnesses Events had before updated for v7. Is there a v7 available of the Name Only plug-in?
Thanks Lesley
User avatar
tatewise
Megastar
Posts: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

Yes, try the Attachment.
Last edited by tatewise on 20 Feb 2023 11:18, edited 1 time in total.
Reason: Attachment deleted as a better version is in the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
tatewise
Megastar
Posts: 28335
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Witness reporting

Post by tatewise »

A List Fact Witness Details plugin is in the Plugin Store and combines the features of the plugins attached to this thread, and which will shortly be deleted.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Post Reply