* Witness reporting
Witness reporting
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.
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.
- PeterR
- Megastar
- Posts: 1135
- Joined: 10 Jul 2006 16:55
- Family Historian: V7
- Location: Northumberland, UK
Re: Witness reporting
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)
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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.
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
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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...
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
- Jane
- Site Admin
- Posts: 8507
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Witness reporting
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."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
- Jane
- Site Admin
- Posts: 8507
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Witness reporting
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."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
Re: Witness reporting
Thank you I can confirm that works for me.
Re: Witness reporting
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
[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
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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?
What were you hoping the Plugin would list?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Witness reporting
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
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
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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.
Reason: Attachment deleted as better version is attached later.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Witness reporting
Mike,
Thank you this is absoultely fantastic, exactly what I was looking for.
Very many thanks.
Jenny
Thank you this is absoultely fantastic, exactly what I was looking for.
Very many thanks.
Jenny
-
- Silver
- Posts: 6
- Joined: 12 Aug 2018 18:36
- Family Historian: V6.2
- Location: USA
- Contact:
Re: Witness reporting
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'}
Code: Select all
tblResults.source:set(id)
tblResults.target:set(fhGetRecordId(ptrOwner:Clone()))
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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/.
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
-
- Silver
- Posts: 6
- Joined: 12 Aug 2018 18:36
- Family Historian: V6.2
- Location: USA
- Contact:
Re: Witness reporting
It seems this isn't compatible with v7? I keep getting an error:
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.[string "C:\Program Data\..."]:61: attempt to index a nil value (global 'arg'). No changes have been made to the data records
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.
Reason: Attachment deleted as a better version is in the Plugin Store.
-
- Silver
- Posts: 6
- Joined: 08 Feb 2010 12:07
- Family Historian: V7
Re: Witness reporting
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
Thanks Lesley
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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.
Reason: Attachment deleted as a better version is in the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Witness reporting
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