Web based family history software

Question FIND: number of children

  • mac.alter
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 months 3 weeks ago #1 by mac.alter
FIND: number of children was created by mac.alter
How can I find records that have "number of children"?

Mac.alter [update: 23 Nov 2024]
webtrees 2.2.0 | PHP Version 8.3 | mySQL mysqlnd 8.1.28 | MacOS 14.6 .1 (Sonoma)

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

More
3 months 3 weeks ago #2 by Franz Frese
Replied by Franz Frese on topic FIND: number of children
<your-site>/family-list?show=indi&show_all=yes&show_marnm=
sort by last column
=
Lists / families /all / show indis / show all results / sort by last column

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

  • mac.alter
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 months 3 weeks ago #3 by mac.alter
Replied by mac.alter on topic FIND: number of children
Didn't expect to type URL. So, there is specific tree. I see "route=%2Ftree%2FtheKennedys" at end to get to MyPage of that tree. Is that added? 

<your-site/route=%2Ftree%2FtheKennedys>/family-list?show=indi&show_all=yes&show_marnm=
sort by last column

Mac.alter [update: 23 Nov 2024]
webtrees 2.2.0 | PHP Version 8.3 | mySQL mysqlnd 8.1.28 | MacOS 14.6 .1 (Sonoma)

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

More
3 months 3 weeks ago #4 by Franz Frese
Replied by Franz Frese on topic FIND: number of children
so use
Lists / families /all / show indis / show all results / sort by last column

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

More
3 months 3 weeks ago - 3 months 3 weeks ago #5 by drblam
Replied by drblam on topic FIND: number of children

How can I find records that have "number of children"?
I'm confused. Are you looking for a table of all families that includes a column with the number of children currently associated with that family group? If so, then Franz has given you the answer.

OTOH, I thought you question was trying to find all records that include the GEDCOM attribute "NCHI", which can be used to document the number of children you believe that person (or family) had. (It used to be easy to add a source citation in earlier versions of webtrees, but isn't possible anymore.) 

If that's what you're looking for, go to:

    Control Panel --> Manage family trees --> Data fixes --> Search and replace

 Use the search text:

    "1 NCHI"

And choose Record type of either Individuals or Families.
Last edit: 3 months 3 weeks ago by drblam.

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

  • mac.alter
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 months 3 weeks ago #6 by mac.alter
Replied by mac.alter on topic FIND: number of children
I want to find all records with 1 NCHI as it contains more than just a number, I've listed children info there if they were not added as a record. So using Data Fix doesn't give me results desired.  Neither =19.5pxwill using List method. I specifically want to find 1 NCHI  "number of children" records.

Mac.alter [update: 23 Nov 2024]
webtrees 2.2.0 | PHP Version 8.3 | mySQL mysqlnd 8.1.28 | MacOS 14.6 .1 (Sonoma)

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

More
3 months 3 weeks ago #7 by Marky
Replied by Marky on topic FIND: number of children
> I want to find all records with 1 NCHI as it contains more than just a number

So use the data fix method as suggested by drblam.

> I specifically want to find 1 NCHI "number of children" records

That's what you'll get! A list of all individual or family records containing it.

webtrees v2.1.21
PHP v8.3.12

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

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
3 months 3 weeks ago #8 by bertkoor
Replied by bertkoor on topic FIND: number of children
Maybe it's a language thing...
Use the "data fix" module to find what you are looking for, not to actually fix / change anything.
It will show you the matching records.

stamboom.BertKoor.nl runs on webtrees v2.1.20

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

  • mac.alter
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 months 3 weeks ago #9 by mac.alter
Replied by mac.alter on topic FIND: number of children
Seems bit convoluted but that did work.

Mac.alter [update: 23 Nov 2024]
webtrees 2.2.0 | PHP Version 8.3 | mySQL mysqlnd 8.1.28 | MacOS 14.6 .1 (Sonoma)

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

More
3 months 3 weeks ago #10 by drblam
Replied by drblam on topic FIND: number of children

Seems bit convoluted but that did work.
Yes, but....  Think about what type of information you're looking for in your query.  It's so specialized that nobody has created a report for it, so you will need a method to look through the raw GEDCOM to find it, using a search function or raw database query.

In case you haven't noticed, webtrees tries to be very careful about protecting the integrity of your data (i.e., raw GEDCOM, database tables, etc). There are four different search options available in the drop-down menu under the Search icon, and all of them are restricted in various ways to keep you out of trouble. Perhaps the German language webtrees manual has more information about what each search option can and cannot do. Even the function "Edit the raw GEDCOM" parses the data into subfield blocks and doesn't allow you to save your changes if your edits mess of the structure!

You're looking for a specific pattern within the structure of the raw GEDCOM, rather than something inside the contents of a single text field (like a name, etc). You could easily create a syntax error in the GEDCOM file if you are not careful (say, by replacing "1 NCHI" by "0 NCHI", or otherwise modifying the GEDCOM structure) so it makes sense that the "Search and replace" function is hidden from novice users.

I agree that the name may be confusing the first time you use it, but what's the alternative? Adding a second version of the same form called "Seach only" which hides the "replace" button? Renaming the function as "Search, and mabye also replace".

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

More
3 months 3 weeks ago #11 by hermann
Replied by hermann on topic FIND: number of children
@mac.alter: I think you should fix that!

I want to find all records with 1 NCHI as it contains more than just a number, I've listed children info there if they were not added as a record.

The tag NCHI (used in INDI and FAM records) should be followed by an integer number, not free text. The semantic in connection with an INDI record is: The number of children that this person is known to be the parent of (all marriages).
    

Hermann
Designer of the custom module "Extended Family"

webtrees 2.1.21 (all custom modules installed, PHP 8.3.12, MariaDB 10.6) @ ahnen.hartenthaler.eu

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

Powered by Kunena Forum