Page 1 of 1
Query for multiple fact types
Posted: 06 Jul 2017 20:39
by gsward
Some of my individuals have multiple facts of the same type. How could I identify them by modifying say the All Facts Standard Query by adding an additional column?
I only want to show those individuals with multiple facts of the same type.
Thanks,
Graham
Re: Query for multiple fact types
Posted: 06 Jul 2017 21:45
by tatewise
Don't add Columns, but use a Row filter.
You need to only add rows where the Owner of current Fact has a similar Fact with a 2nd instance.
I will look at the Expression details tomorrow.
Why do you need to find these Individuals?
Re: Query for multiple fact types
Posted: 07 Jul 2017 07:09
by Jane
I found this in my Plugin list originally written by Chris Searl
Re: Query for multiple fact types
Posted: 07 Jul 2017 07:35
by gsward
Thanks I will give the plug in a try. I have merged some individuals from another file and a few have multiple facts the same e.g births with different sources but I need to review as some should be combined or transferred to a christening.
I will look out for Mike's "Row" tip too.
Thanks
Graham
Re: Query for multiple fact types
Posted: 07 Jul 2017 09:38
by tatewise
Unfortunately, the Query Row filter is not feasible.
Also, that ID Repeated Facts Plugin does not work correctly and lists many non-duplicated facts.
Try the attached Duplicated Facts Plugin. It is a bit rough round the edges but seems to do the job.
Re: Query for multiple fact types
Posted: 07 Jul 2017 10:04
by David Potter
Hi Mike
I thought I would give that Plug-In a try too. The Plug-In does find multiple Facts of the same Type but ignores the date for the these facts, therefore they are not actually true Duplicates.
Can that be solved?
Thanks
Re: Query for multiple fact types
Posted: 07 Jul 2017 10:57
by tatewise
David, if you mean my Duplicated Facts Plugin, then that is deliberate, because Graham is looking for Facts that did not Merge when importing another Gedcom, so the Dates might not be identical.
I have another Plugin that checks for fully duplicated Facts and relies on them being adjacent as they have the same Date.
It also checks that other fields are identical: Place, Address, Age, Cause, Note, 1st Citation, Entry Date & Assessment, but those are not all the possible subsidiary fields and citations.
That can easily be edited to omit or add the checks for whatever fields you like.
So it depends on your definition of true duplicates.
Re: Query for multiple fact types
Posted: 07 Jul 2017 11:18
by gsward
I would like to keep these different dates as some are differences between birth and christening dates!
Re: Query for multiple fact types
Posted: 07 Jul 2017 11:40
by tatewise
Graham, you can keep whatever you want.
Are you using the Duplicated Facts Plugin Version 0.1 Date 07 Jul 2017 that I posted first?
Re: Query for multiple fact types
Posted: 07 Jul 2017 13:29
by gsward
Not yet, I expect to test this evening.
Thanks
Graham
Re: Query for multiple fact types
Posted: 07 Jul 2017 13:33
by David Potter
Hi Mike
Yes - of course depends on your definition. No worries Plug-In's are out of my depth. Still getting used to using/editing queries.
Thanks for the reply.
Re: Query for multiple fact types
Posted: 07 Jul 2017 17:29
by gsward
Mike, Duplicate Facts.fh_lua works well for me. It gets me to the individuals I need to investigate.
Thanks,
Graham