* Query for multiple fact types

[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

[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?

[Jane]

I found this in my Plugin list originally written by Chris Searl

ID Repeated Facts.fh_lua

(6.46 KiB) Downloaded 191 times

[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

[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.

[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

[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.

[gsward]

I would like to keep these different dates as some are differences between birth and christening dates!

[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?

[gsward]

Not yet, I expect to test this evening.

Thanks

Graham

[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.

[gsward]

Mike, Duplicate Facts.fh_lua works well for me. It gets me to the individuals I need to investigate.

Thanks,

Graham