Quote from Chad Kurszewski on 2025-01-07, 5:38 pm

Quote from kevync on 2025-01-07, 5:17 pm

Excluding spouses of is relatively easy

I assume you mean in SQL. That I understand.  My question was if there's a way to do that in RM without SQL, based on someone's (much) earlier comment, "My feeling is that one should always create a group that meets the criteria and then color code using the group."

Quote from kevync on 2025-01-07, 5:46 pm

Any group can be colored based on those in the group

see screenshot

as for RM10 Criteria (You can combine criteria)--- now while the criteria is advanced it may not have everything  your are looking for.

https://help.rootsmagic.com/RM10/person-search--(advanced).html?q=advanced+search

https://help.rootsmagic.com/RM10/search-rules.html (you can also use 2 different groups for example)

Quote from Chad Kurszewski on 2025-01-07, 5:46 pm

Quote from kevync on 2025-01-07, 5:29 pm

alternately you could use the built in RM descendant tool

Okay, sure, if you knew the entire list of ancestors to then do the direct descendants.  I was hoping to select one great grandparent, then have the search/group thing do ancestors and descendants, but that includes spouses.

One of my great grandparents I have identified 86 direct ancestors.  I'd have to select all 86 of those ancestors and then have to select all direct descendants.  Assuming I've identified 86 ancestors of each of my 8 great grandparents, that's 688 ancestors I'd have to select and then do descendants of each.  I'd rather not do that manually.

Are you aware of how I can:  For one grandparent, select all ancestors, then select all descendants of those ancestors, without doing that manually?  If I do the "all ancestors and descendants" in RM for that one great grandparent, it selects spouses too.

Quote from kevync on 2025-01-07, 5:53 pm

here is a on some of what advance groups can do couple video https://www.youtube.com/watch?v=NOw-LSx69Q0 --- once group is  created then you can  assign color set(s) to those group(s).  Sorry maybe I am misunderstanding or I assume you knew all that.

 

 

 

Quote from Chad Kurszewski on 2025-01-07, 6:04 pm

I think maybe you are misunderstanding me.  Sorry if I'm not being clear enough.

Let's just put aside SQL for this and talk RM groups/searches.  I have 8 great grandparents.  Let's just work with one of them.  For one great grandparent, I want to select/group all of their ancestors, and for all of those ancestors, I want to select all of their direct descendants (excluding spouses).  Can you show/describe a single RM group/search to perform that?

I understand that I can create a group of ancestors.  I understand that I can create a group of descendants of a single person.  But, for that one great grandparent, I have 86 ancestors.  How do I easily select/group all of the direct descendants of those 86 people into one group?

RM has the 'ancestors and descendants' option for searches, but it includes spouses.

Quote from Tom Holden on 2025-01-07, 6:12 pm

@we9v

I can't think well in SQL, but in other pseudocode:

Maybe you should consider a higher level language to do some of that processing. @richardotter has a good site with guidance and scripts using Python.

Quote from Chad Kurszewski on 2025-01-07, 6:29 pm

I'm hoping that @thejerrybryan comes through after his "In that case, I think it's pretty easy" comment.

Or as a backup, maybe @kevync will show me how to select all direct descendants of a single great grandparent's ancestor's line without selecting spouses with RM's advanced search/grouping tool, such that I can have 8 groups, one for each great grandparent, and then color code each group.  Unfortunately, this give no preference to closer cousins for color coding when both parents are related to me.

Or a backup to the backup is to just modify the original post's SQL scripts to do this, again without preference for colors when both parents are related to me.

Quote from kevync on 2025-01-07, 7:53 pm

well I am not sure removing spouses would work in RM  at least not in a practical way for that many generations.

I am made a slight mod to the script I was working on last night - its not a recursive query which  would be the ideal way to do (then when you ran you it could prompt you for starting person and create/update a group "A&D NoSpouses of Harry Smith) .  The script I wrote could be easily adapted to create a groups in RM just not recursive.  To run you would need to set relationships to each grandparent or which ever ancestor you choose before running.  Its filtered to remove spouse of cousins, aunts, uncles, and descendants (though I have not tested to confirm it works as intended as my home person is my grandson and he would not have any).

 

Quote from thejerrybryan on 2025-01-07, 9:39 pm

Quote from Chad Kurszewski on 2025-01-07, 5:08 pm

If anyone knows how to unselect spouses in group/search "decendants", I'd love to hear how.

I think you are talking about unselecting spouses in RM rather than unselecting spouses in SQLite.  You can pretty much do anything like this in SQLite.

In RM, if you are talking about unselecting spouses from the descendants of a single ancestral couple, then it's trivial. The needed option does exist.

In RM, if you are talking about unselecting spouses from all ancestral couples, then it's not possible (or else you have to go to each ancestral couple, one at a time.) The needed option does not exist. To get to something close to this option, you have to ask first for ancestors and then there is an option to add descendants of those ancestors. It's this descendant option that's missing the additional option of unselecting spouses.