- Posts: 339
Question FIND: number of children
- mac.alter
- Topic Author
- Offline
- Senior Member
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.
- Franz Frese
- Offline
- Elite Member
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
- Posts: 339
<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.
- Franz Frese
- Offline
- Elite Member
Lists / families /all / show indis / show all results / sort by last column
Please Log in or Create an account to join the conversation.
- drblam
- Offline
- Junior Member
- Posts: 186
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.How can I find records that have "number of children"?
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.
Please Log in or Create an account to join the conversation.
- mac.alter
- Topic Author
- Offline
- Senior Member
- Posts: 339
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.
- Marky
- Offline
- Junior Member
- Posts: 104
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
- Greetings from Utrecht, Holland
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
- Posts: 339
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.
- drblam
- Offline
- Junior Member
- Posts: 186
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.Seems bit convoluted but that did work.
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.
- hermann
- Offline
- Elite Member
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).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.
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.