Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

How to find individuals without sources? 2 weeks 5 days ago #1

  • TheDutchJewel
  • TheDutchJewel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 46
I have a tree with about 25,000 individuals, and I want to add resources to the facts of all individuals.

I've added resources for about 5,000 individuals, but the more individuals have resources, the harder it is to find individuals without sources.

Is there an easy way to find/filter individuals without resources?

PS: I'm not looking for the report of missing data, but for the individuals with data but without sources.
webtrees v2.x with modules (Fan & Pedigree chart by MagicSunday | Rural Theme | Tree View Full Screen | ⚶ Vesta Custom Modules)
webtrees v1.7.17 with Fancy Treeview & PDF module for nice tree view and report

Please Log in or Create an account to join the conversation.

How to find individuals without sources? 2 weeks 5 days ago #2

  • eh215
  • eh215's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 217
There is no report which provides this specific information.

The current reporting framework is very old and outmoded and I believe major changes are on the roadmap in the future so it is not likely that anyone will put the effort into creating a new report until then.

If you are comfortable running simple SQL queries against your database, you can rather easily find those that are missing data, but you'd have to copy-paste the result into your web browser 1 line at a time to actually view & edit the individual.
SELECT  distinct i_id
     FROM wt_individuals
	 where i_id not in
	    (select l_from from wt_link
		     where l_type = 'SOUR')

It is a bit cumbersome but it has worked for me; I'm sure there is a more elegant solution
webtrees 2.0.10 at behunt.net/ft
PHP 7.4.8, MySQL 5.7.23-23

Please Log in or Create an account to join the conversation.

How to find individuals without sources? 2 weeks 5 days ago #3

  • TheDutchJewel
  • TheDutchJewel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 46
Thanks eh215, it works!

But a solution within webtrees is more user-friendly. Seems like a basic function for a genealogy program.
webtrees v2.x with modules (Fan & Pedigree chart by MagicSunday | Rural Theme | Tree View Full Screen | ⚶ Vesta Custom Modules)
webtrees v1.7.17 with Fancy Treeview & PDF module for nice tree view and report

Please Log in or Create an account to join the conversation.

How to find individuals without sources? 1 week 4 days ago #4

  • TheDutchJewel
  • TheDutchJewel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 46
Any ideas how to get this ones:
1. list of all individuals born in 1920 without BIRT source
2. list of all families married in 1945 without MARR source
3. list of all individuals died in 1970 without DEAT source
webtrees v2.x with modules (Fan & Pedigree chart by MagicSunday | Rural Theme | Tree View Full Screen | ⚶ Vesta Custom Modules)
webtrees v1.7.17 with Fancy Treeview & PDF module for nice tree view and report

Please Log in or Create an account to join the conversation.

Last edit: by TheDutchJewel.
  • Page:
  • 1
Powered by Kunena Forum