I have been working on charting all the descendents of the Electress Sophia and now want to Find out all the intermarriages between her descendents.
Now fortunately I have given each of her descendents a custom ID .
Ive then constructed a very simple query based on the descendents query. Ive just added a spouse.Custom Id , Spouse.name, and Spouse.birthdate columns.
Now this is a good start but it shows ALL the mariages of The Electress Sophias's Descendents. I would like the output to dispaly ONLY those spouses which have a custom ID. Is this easy to do?
I would also like to be able to have a column showing the date of the marriage but i cant find this where i would expect it to be, under events. any ideas?
To show only those spouses who have a Custom ID, try adding these rows: Exclude if INDI.FAMS[1]>HUSB[1]>REFN[1] Is null Exclude if INDI.FAMS[1]>WIFE[1]>REFN[1] Is null
(Edit: Unfortunately this will exclude anyone whose first spouse has no custom ID, even if a second or third spouse does. I'm not sure how to get round that.)
To set a column showing marriage date, use %INDI.FAMS>MARR.DATE% (You'll find the data reference under Family as Spouse > Events > Marriage > Date)
Thanks Lorna. you were almost right but I needed to include just those who had a spouse with a custom ID and i did that by using INDI.~SPOU[1]>REFN[1].
Works very well but i think i could improve it more.
As I said earlier each descendent of The Electress has a Custom ID so when I now run the query it shows me all the descendents who have married another descendent .....But each marriage is listed twice. for example I have a line showing Elizabeth II marrying Philip Mountbatten but also a line showing Philip Mountbatten Marrying Elizabeth II. It would be nice if I could just have one line per marriage.
I'm guessing what I need to do is exclude a person if they have already been listed as a spouse in the query but I'm not sure if that is possible . any ideas?
Sorry Tatewise I was typing my reply when you posted yours
One way is to exclude all Female descendants, then only the Male married Female entries will appear: Exclude if INDI.SEX matches Female
Another approach would have been to use a Family Query instead of an Individual Query. You may not have been aware that there are 9 Query Types; one for each Record Type - see the General tab in Query window.
I suspect you will need to build an expression to check all the Families on an Individual Query, so it might be much easier to do a new Family Query, checking that both the Husband and Wife have a custom Id, or simply that they are both descendants of the Empress.
David, The link Jane gave in her post is a link to a .fhq file. This is a Family Historian Query file, not a plugin. It looks as if she has written the query for you, so all you need to do is download and install it.
Thank you so much for pointing me in the right direction Downloaded the query and saved it to a new directory where I keep my FH files. Clicked on the file and it asked me whether i wanted to sinstall it as a custom query. did that and it installed.
added the columns that I wanted then excluded rows that had nulls and it worked a dream.
I now have a list of all the 413 marriages that have taken place between descendants of the Electress (that I know about)
This web site was made with WebAPP v0.9.9.3.3, a web portal system written in Perl
All trademarks and copyrights on this page are owned by their
respective owners. Comments are owned by the Poster.
Marble theme based on "Crash" theme by my2cents
Author:
Logged
Working With Queries
