Page 1 of 1

Query for Certain People

Posted: 16 Nov 2011 20:58
by marilyn57
Just wondered if anyone could explain if there is any way to do a query to list the direct ancestors of a person, together with their siblings and the spouses of just ancestors and their siblings. My tree is so big now but just want to have a diagram containing these people.

I know there is a split tree option but I am not sure about that and just wondered if there was any easier solution. I am still having trouble grasping certain queries.

I would be grateful for any help, thanks

Marilyn

ID:5568

Query for Certain People

Posted: 16 Nov 2011 22:43
by PeterR
If you specify an All Relatives diagram and use the Diagram Option to specify Generations Up = All and Generations Down = 1, the diagram should show only ancestors and siblings of ancestors and their spouses.

Query for Certain People

Posted: 17 Nov 2011 09:42
by tatewise
Peter's suggestion is almost there.
Under Generations Down: 1 you also need to set ...counting down from each ancestor instead of the default root.

Query for Certain People

Posted: 17 Nov 2011 16:56
by marilyn57
Thanks for your replies, that shows me how to do a diagram which is great, but Sorry I didn`t explain it properly, I am looking to get my tree printed but I only want my direct ancestors, plus their siblings and spouses. I do not want any generations down from them which are on my original tree. I think maybe I am looking to do a query for those people and then save it as another gedcom file to send off for printing.

Hope this makes sense, is there an easy way to do this using a query then the split tree helper.

Thanks again

Marilyn

Query for Certain People

Posted: 17 Nov 2011 17:43
by PeterR
The same principle can be achieved using a Query.  The following Row Filters should produce the desired result:
Image
The third filter excludes any descendants of the Starting Person and their spouses.
The fourth filter excludes siblings of the Starting Person and their spouses; this filter should be omitted if this is not what is wanted.

Query for Certain People

Posted: 18 Nov 2011 16:12
by marilyn57
Thanks Peter, I will have a try with that.

Marilyn [smile]

Query for Certain People

Posted: 18 Nov 2011 19:16
by marilyn57
I cant do this, cant even think where to start. Is there any chance of talking me through the query step by step. I love this programme but just cannot get the hang of queries at all.

Sorry to be a pain.

Marilyn[confused]

Query for Certain People

Posted: 18 Nov 2011 21:56
by tatewise
Have a look at the Knowledge Base article on Creating a Query at
http://www.fhug.org.uk/wiki/doku.php?id ... ng_a_query
Then when you get stuck at a particular stage, we can give more advice.

Query for Certain People

Posted: 18 Dec 2011 20:55
by Marilyn
Hi, sorry about this but I have managed to make some types of query so I can sort of do this, but I just dont know where to start with this one, should I be looking for generation or ancestor etc., in the fields, so that I can get to the expression that you mention. I am thinking that maybe I will have to give up on this unless I can be talked through it step by step by some very kind person and just go through every individual and delete them if I dont want them.

Any offers of help would be very much appreciated.

Thank you

[confused]

Query for Certain People

Posted: 19 Dec 2011 07:57
by Jane
Peter has already give you all the lines for the Rows tab, what can't you work out how to enter?

Query for Certain People

Posted: 19 Dec 2011 12:17
by tatewise
Marilyn,
You said earlier you want a diagram to send off for printing.
I am still sure that the original suggestion of setting the Diagram Options of Generations Down: 1 and ...counting down from each ancestor will do what you want.

See the related General topic thread Print family tree at
http://www.fhug.org.uk/cgi-bin/index.cg ... y&num=5587
This talks about how to use specialist printers who work from your Project plus an FH Chart, or alternatively using PDF files saved from your diagram.
I both cases it does not matter how much is in your full database tree, it is what is in the Diagram/Chart/PDF that matters.

Query for Certain People

Posted: 19 Dec 2011 19:05
by Marilyn
[smile]

I think I`ve done it, thank you so much everyone!

Have a lovely Christmas