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.

Children-NeedingManualArranging-2.sql

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