Family Historian User Group

I missed that and will review.

I have a number of fact sentence templates that have an extra period after the PLACE element when additional elements follow.

See example below.
How do eliminate the . after South Dakota

Yes, the Marriage Date & Place will come up null in the results. I added these just to verify results.

Query Type must be set to Family in the General tab. In the Rows tab Add if %FAM.MARR[1]% is null as the filter. In the Columns tab Add Husband %FAM.HUSB[1]>%, Wife %FAM.WIFE[1]>%, Marriage Date %FAM.MARR[1].DATE% and Marriage Place %FAM.MARR[1].PLAC>%. This will allow you to verify results are as d...

Thanks

I wish to display the "Starting Person" in one of the Columns of the Result Set of a Query.

Is there an expression that does that? I know that would result in a single name repeated a number of times.

Below is a plugin that tatewise helped me with --[[ @Title: Cemetery Summary Report @Author: Gary Carson @LastUpdated: July 2017 @Description: Counts and Lists All Burial Places in the File ]] tblCemeteries = {} -- Define array for Burial Places tblLatLongNum = {} -- Define array for Lat/Longitude t...

The suggestions only returned blood relationships. I am looking for a query result similar to

Is there an expression that show indirect relationship(s) that could be used in a Query?

Something that is similar to indirect relationship(s) shown in the singular "How Related" Tool.

I learned something new. How to delete cell contents as you suggested. I highlighted the cells in the query>Edit>Delete.

I did successfully used a query to capture all instances. Am able to go thru individually and delete. As I'm not adept at writing a plugin, I can manually delete.

I understand and found where to do that. Next question. I have a large number of these, how con I do this en masse?

I am in the process of reviewing and updating Alternate Names ( %INDI.NAME[2]% ). Once I delete an entry, the result in a query and in a Family Group Sheet and an Individual Summary report shows as [unnamed person] . The Property Box for the updated person is blank. Sources for the deleted Alternate...

That last criteria worked exactly as desired. Again, a special thanks.

Thanks for everyone's patience.

I think I got off track. Blood relation is more correct; not just direct ancestors. My error in creating this confusion.

=IsTrue(IsAncestorOf(%INDI%,["Starting Person"]) and IsAncestorOf(["Second Person"],)) returned no results. I guess I am just not getting correct expression.

Using Add if =IsTrue(IsAncestorOf(["Starting Person"],%INDI%) and IsAncestorOf(["Second Person"],)) is true returns only descendants of Starting Person . Am trying to check if relative of Starting Person is also relatives of Second Person . What I want to eliminate is Target pers...

Going back to the base query I am using contains the following Row selection criteria: Add if spouse of [“Starting Person”]. Include original individual Add if an ancestor of anyone in the current result set. Add if an descendant of anyone in the current result set. Add if a spouse of anyone in curr...

I agree on the learning experience. The last one you took me on helped.

I am looking for a person that is a direct ancestor of person A and is a direct ancestor of person B. Hopefully I format the function you provided correctly.

I am trying to develop a query to find only common ancestors between two persons (most specifically myself and my wife). For example Jane Doe is my 3rd cousin 4 times removed and she is also my wife’s 10th cousin twice removed. The base query I am using contains the following Row selection criteria:...

Great help. Thanks

I am having trouble to nest expression to achieve desired result. Help/hint please.

When I insert expression you corrected for me, males are also listed with surname.