Children – Needing Manual Arranging #child #family #sortdate

After running the query Children-SetOrderByBirthSortDate.sql, there may remain families that need to be manually arranged because one or more of the children has no birth-type fact or has a dominant birth-type fact with no date. This query produces a list of the parents who have such children. Look up and select one of the parents in the Sidebar Index with Family as the Main View and edit as needed.

This query also returns families with a single child; it is helpful in TimeLine and other views and reports to have at least an estimated date of Birth, even just a sort date.


2015-01-23 1st release
2015-01-24 rev to show count of children in family
2015-01-24 rev2 to make standalone, using the WITH syntax with Common Table Expressions for brevity

Discussions & comments from Wikispaces site



19 August 2016 14:16:54

There seems to be something wrong with the script. It begins with WITH statement instead of with a SELECT statement. It may be a valid construction, but if so then I’m not familiar with it. And any case, it fails when run with SQLiteSpy.



19 August 2016 14:19:11

Oops, I see that rev2 changed it to use the WITH syntax with which I’m not familiar. So I guess the syntax is valid. But it doesn’t seem to work with SQLiteSpy.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.