*Query to Identify Totally Unlinked Individuals

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
rfj1001
Famous
Posts: 173
Joined: 14 Dec 2003 18:11
Family Historian: V6.2
Location: Dorset, England
Contact:

Query to Identify Totally Unlinked Individuals

Postby rfj1001 » 27 Jul 2018 09:46

I was tidying up my database and randomly came across a couple of individuals that had neither links to others nor useful info in their own record to identify them. I guess there'll be many more built up over the years.

So I've been trying to customise the No Family as Child query that I downloaded this morning from the FHUG website but can't get the logic to work.

I'm trying to end up with a record set that :

excludes if there are partner(s)
/and/ exclude if there are parent(s)
/and/ exclude if there are children
... /and,/ possibly, exclude if there are attached siblings.

Can SKS help point me in the right direction

Many thanks

Rob

User avatar
Jane
Site Admin
Posts: 7630
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Query to Identify Totally Unlinked Individuals

Postby Jane » 27 Jul 2018 09:48

Have you tried just running the Search For Orphans standard query? It shows everyone, but if you sort by pool number, the orphans and small clusters of people will have different pool numbers.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

rfj1001
Famous
Posts: 173
Joined: 14 Dec 2003 18:11
Family Historian: V6.2
Location: Dorset, England
Contact:

Re: Query to Identify Totally Unlinked Individuals

Postby rfj1001 » 27 Jul 2018 10:58

Hi Jane,

Thanks for the reply. I tried that query and if I search the pool numbers for a single line entry then I've got a potential orphan. I can then check manually whether there is anything in the persons record to suggest it should be kept or deleted. So, on an individual basis that works :)

/Unfortunately/, as you mention in your post, the query displays everyone which gives just over 11,000 entries for me to check - so still too big a task.

I'm wondering if the FH query language is such that a modification to the standard query I used could identify pool numbers with only one line entry. Just a thought, but beyond my expertise I'm afraid

User avatar
tatewise
Megastar
Posts: 16035
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Query to Identify Totally Unlinked Individuals

Postby tatewise » 27 Jul 2018 11:05

Try the attached Search For Orphans 2 that excludes all Individuals with any Spouse or Parent family links.
Attachments
Search For Orphans 2.fhq
(1.01 KiB) Downloaded 38 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Gowermick
Megastar
Posts: 718
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Query to Identify Totally Unlinked Individuals

Postby Gowermick » 27 Jul 2018 11:46

rfj1001 wrote:Hi Jane,

/Unfortunately/, as you mention in your post, the query displays everyone which gives just over 11,000 entries for me to check - so still too big a task.

I'm wondering if the FH query language is such that a modification to the standard query I used could identify pool numbers with only one line entry. Just a thought, but beyond my expertise I'm afraid

If you click on the heading for Pool number, they sort is ascending order. If, however, you Alt-Click, they sort in descending order, so the main unrelated ones appear at the top. Whilst the top ones won’t all be single line entries, you can quickly scroll down to identify the ones you wish to delete.

By coincidence, I went throught this exercise this morning, and it only took about 10 minutes to remove a few hundred unrelated individuals :D ( my tree contains about 17,000 individuals)
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

brianlummis
Famous
Posts: 172
Joined: 18 Dec 2014 11:06
Family Historian: V6.2
Location: Suffolk, England

Re: Query to Identify Totally Unlinked Individuals

Postby brianlummis » 27 Jul 2018 11:51

Mike (Tatewise)

Thought I would try this query and was surprised to find that I had over 500 orphans in my project of just over 5000 individuals. Having wondered how I had accumulated so many I then realised that if I then filtered out those that were entered as part of a census the numbers dropped to just over 200 and then filtered again for witnesses, the list came down to 20 names.

The OP might find it useful to do something similar, and, depending on want he wants to achieve, his list might drop dramatically or at least he will know how he has so many orphans.

Brian

User avatar
tatewise
Megastar
Posts: 16035
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Query to Identify Totally Unlinked Individuals

Postby tatewise » 27 Jul 2018 12:07

Brian, it would be quite easy to amend the Query to exclude Witnesses by using:
Exclude unless %INDI.~SHAR[1]>% is null

To exclude those who are part of a Census then use such as:
Exclude unless %INDI.CENS[1].SOUR[1]>% is null
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

brianlummis
Famous
Posts: 172
Joined: 18 Dec 2014 11:06
Family Historian: V6.2
Location: Suffolk, England

Re: Query to Identify Totally Unlinked Individuals

Postby brianlummis » 27 Jul 2018 12:13

Exactly how I did it :D

Sorry I should have posted those amendments myself.

Brian

rfj1001
Famous
Posts: 173
Joined: 14 Dec 2003 18:11
Family Historian: V6.2
Location: Dorset, England
Contact:

Re: Query to Identify Totally Unlinked Individuals

Postby rfj1001 » 27 Jul 2018 13:24

Thanks All for the contributions.

Mike, your query - particularly with the life dates column, was all I needed :). It gave me a list of c40 people.

Most of those entries were for peoples where I just have a burial record. I haven't yet been able to establish parentage for them but given they come from records of very small parishes where my ancestors lived its probable they are related in some way - so I need to keep these.

That just left me with 4 - 3 orphans to be deleted and 1 executor of a will who will be related to the deceased, but no info yet as to how.

Problem solved :)

Tx again to all.


Return to “General Usage”

Who is online

Users browsing this forum: ColeValleyGirl, Google [Bot] and 9 guests