1. family-historian@groups.io
  2. Messages
   Date   
Re: Query with marriage date

Brian Horridge
 

Randy

I also forgot to mention that there are quite a few customised queries on the FHUG in the "KnowledgeBase - Downloads" page.  They used to be submitted by users themselves if they'd found something useful they thought others might benefit from but I think that might now have changed (it used to identify who uploaded it and when).

Brian

On 17/03/2021 12:44, Randy Dykhuis wrote:

Well, that was easy. I knew I must have been missing something. Thanks, Brian.

A follow-up question: How would one learn more about creating Expressions such as the one you used for spouse's ID? Is there information in the FH help? Or in the KnowledgeBase? I've looked but haven't found a comprehensive overview & explanation. Thanks.

From: "Brian Horridge via groups.io" <brian.horridge@...>
To: "family-historian@groups.io" <family-historian@groups.io>
Sent: Wednesday, March 17, 2021 12:40:25 AM
Subject: Re: [family-historian] Query with marriage date

Randy

You are right that the marriage is a "Family" event but you can still show it in an "Individual" Query.

In your Query in the "Columns" tab expand on "Family as Spouse" and then you can pick any of the spouse's events / attributes you want.  If you you want the Parents' details, choose from "Family as Child" events / attributes

If you want a column to show a spouse's ID use  the expression =RecordId(%INDI.~SPOU>%) .  A second's spouse's ID can be shown as =RecordId(%INDI.~SPOU[2]>%) etc by using the "[2]" in most queries.

Hope that does what you want.

Brian

On 17/03/2021 01:25, Randy Dykhuis wrote:
I will confess upfront that I've not spent a lot of time with queries. However, as my database has grown, and I'm starting to look for data that goes beyond using the Property box individual by individual.

I would like to write a query that returns a list of all children of my great-grandfather, their birthdate, their spouses' names, spouses' birthdates, and marriage dates. I can write a query that gets me everything except marriage. There is no marriage event so I am unable to add a column for that. I am using an Individual query and thought perhaps I needed a family query but that didn't seem to work either. It seems like there must be a simple way to do this but I sure am not finding it. Any help would be appreciated.


Virus-free. www.avg.com




Re: Query with marriage date

Brian Horridge
 

Helen

I don't fully understand the problem you are having.  Normally, clicking the "Add" puts the new expression at the bottom and then you need to use the up / down arrows to position it.

However, I must admit that I never normally start a query from scratch - I've always picked the "best fit" from the standard ones, save that as my own Custom Query and then add the new column into "my" Custom Query.  If there are Columns in the "best fit" that I don't want I just remove them from my version till I only have the ones I want.

Brian

On 17/03/2021 13:57, Helen Dignum via groups.io wrote:

This Spouse ID expression is very useful.   I have long wanted to be able to display the spouse in the Individual Records Display to help distinguish between the many individuals of the same name married to different spouses (previously I named as Stephen /Clay (spouse Eliz) , Stephen/ Clay (spouse Ann) etc.)

So following on from above, I created a custom query of Spouse, adding the %INDI.~SPOU[1]>% to the column expression.
then I can configure columns using add from query, adding query spouse.
The add column from query seems to override all the usual default columns so you need to add back in other columns like dates, birth place etc to suit.
Thanks, Helen

Virus-free. www.avg.com

Re: Query with marriage date

Helen Dignum
 

This Spouse ID expression is very useful.   I have long wanted to be able to display the spouse in the Individual Records Display to help distinguish between the many individuals of the same name married to different spouses (previously I named as Stephen /Clay (spouse Eliz) , Stephen/ Clay (spouse Ann) etc.)

So following on from above, I created a custom query of Spouse, adding the %INDI.~SPOU[1]>% to the column expression.
then I can configure columns using add from query, adding query spouse.
The add column from query seems to override all the usual default columns so you need to add back in other columns like dates, birth place etc to suit.
Thanks, Helen
Re: Query with marriage date

Brian Horridge
 

Randy

I learnt most of my "query tricks" by looking at the wide variety of Standard Queries that come with FH and how they return and display different information (even if the standard query is not really what I want the expressions may be useful).  I would copy individual column expressions into my own specific custom query (and also the Results window column if useful there). In addition, by looking at these varied queries, you get a feel for the relevant syntax required (ie the use of "[2]" and "[3]" etc.)

I've been using FH for a very long time (before the start of the KnowledgeBase) so I've picked up a lot hints and tips along the way from this e-mail list and latterly the FHUG Forum.  You can get a list of "Functions" from the "Help-Search Help" and type in Functions.  The results do not always give examples but using this help and the Knowledgebase (and other standard queries) you can usually work it out.  It's also worth looking at examples of Family queries to again get a feel for the syntax.

A lot of it was trial and error and I kept going till I managed to get rid of the FH error messages!!  

Another tip - something I do (to overcome the frustration of having to scroll down through the long list of queries) is that when I save a custom query, I name it "aa-myquery"  etc as the leading "aa-" makes it appear at the top of the list so can be seen without scrolling.  Therefore, the queries I use most are always at the top.

Hope this helps

Brian

On 17/03/2021 12:44, Randy Dykhuis wrote:

Well, that was easy. I knew I must have been missing something. Thanks, Brian.

A follow-up question: How would one learn more about creating Expressions such as the one you used for spouse's ID? Is there information in the FH help? Or in the KnowledgeBase? I've looked but haven't found a comprehensive overview & explanation. Thanks.

From: "Brian Horridge via groups.io" <brian.horridge@...>
To: "family-historian@groups.io" <family-historian@groups.io>
Sent: Wednesday, March 17, 2021 12:40:25 AM
Subject: Re: [family-historian] Query with marriage date

Randy

You are right that the marriage is a "Family" event but you can still show it in an "Individual" Query.

In your Query in the "Columns" tab expand on "Family as Spouse" and then you can pick any of the spouse's events / attributes you want.  If you you want the Parents' details, choose from "Family as Child" events / attributes

If you want a column to show a spouse's ID use  the expression =RecordId(%INDI.~SPOU>%) .  A second's spouse's ID can be shown as =RecordId(%INDI.~SPOU[2]>%) etc by using the "[2]" in most queries.

Hope that does what you want.

Brian

On 17/03/2021 01:25, Randy Dykhuis wrote:
I will confess upfront that I've not spent a lot of time with queries. However, as my database has grown, and I'm starting to look for data that goes beyond using the Property box individual by individual.

I would like to write a query that returns a list of all children of my great-grandfather, their birthdate, their spouses' names, spouses' birthdates, and marriage dates. I can write a query that gets me everything except marriage. There is no marriage event so I am unable to add a column for that. I am using an Individual query and thought perhaps I needed a family query but that didn't seem to work either. It seems like there must be a simple way to do this but I sure am not finding it. Any help would be appreciated.


Virus-free. www.avg.com




Re: Query with marriage date

Randy Dykhuis
 

Well, that was easy. I knew I must have been missing something. Thanks, Brian.

A follow-up question: How would one learn more about creating Expressions such as the one you used for spouse's ID? Is there information in the FH help? Or in the KnowledgeBase? I've looked but haven't found a comprehensive overview & explanation. Thanks.

From: "Brian Horridge via groups.io" <brian.horridge@...>
To: "family-historian@groups.io" <family-historian@groups.io>
Sent: Wednesday, March 17, 2021 12:40:25 AM
Subject: Re: [family-historian] Query with marriage date

Randy

You are right that the marriage is a "Family" event but you can still show it in an "Individual" Query.

In your Query in the "Columns" tab expand on "Family as Spouse" and then you can pick any of the spouse's events / attributes you want.  If you you want the Parents' details, choose from "Family as Child" events / attributes

If you want a column to show a spouse's ID use  the expression =RecordId(%INDI.~SPOU>%) .  A second's spouse's ID can be shown as =RecordId(%INDI.~SPOU[2]>%) etc by using the "[2]" in most queries.

Hope that does what you want.

Brian

On 17/03/2021 01:25, Randy Dykhuis wrote:
I will confess upfront that I've not spent a lot of time with queries. However, as my database has grown, and I'm starting to look for data that goes beyond using the Property box individual by individual.

I would like to write a query that returns a list of all children of my great-grandfather, their birthdate, their spouses' names, spouses' birthdates, and marriage dates. I can write a query that gets me everything except marriage. There is no marriage event so I am unable to add a column for that. I am using an Individual query and thought perhaps I needed a family query but that didn't seem to work either. It seems like there must be a simple way to do this but I sure am not finding it. Any help would be appreciated.


Virus-free. www.avg.com



Re: Query with marriage date

Brian Horridge
 

Randy

You are right that the marriage is a "Family" event but you can still show it in an "Individual" Query.

In your Query in the "Columns" tab expand on "Family as Spouse" and then you can pick any of the spouse's events / attributes you want.  If you you want the Parents' details, choose from "Family as Child" events / attributes

If you want a column to show a spouse's ID use  the expression =RecordId(%INDI.~SPOU>%) .  A second's spouse's ID can be shown as =RecordId(%INDI.~SPOU[2]>%) etc by using the "[2]" in most queries.

Hope that does what you want.

Brian

On 17/03/2021 01:25, Randy Dykhuis wrote:

I will confess upfront that I've not spent a lot of time with queries. However, as my database has grown, and I'm starting to look for data that goes beyond using the Property box individual by individual.

I would like to write a query that returns a list of all children of my great-grandfather, their birthdate, their spouses' names, spouses' birthdates, and marriage dates. I can write a query that gets me everything except marriage. There is no marriage event so I am unable to add a column for that. I am using an Individual query and thought perhaps I needed a family query but that didn't seem to work either. It seems like there must be a simple way to do this but I sure am not finding it. Any help would be appreciated.

Virus-free. www.avg.com

Query with marriage date

Randy Dykhuis
 

I will confess upfront that I've not spent a lot of time with queries. However, as my database has grown, and I'm starting to look for data that goes beyond using the Property box individual by individual.

I would like to write a query that returns a list of all children of my great-grandfather, their birthdate, their spouses' names, spouses' birthdates, and marriage dates. I can write a query that gets me everything except marriage. There is no marriage event so I am unable to add a column for that. I am using an Individual query and thought perhaps I needed a family query but that didn't seem to work either. It seems like there must be a simple way to do this but I sure am not finding it. Any help would be appreciated.

Re: Displaying Sources and citations

Debbie Kennett
 

Mike

 

I’ve always had a floating Property Box. I must have changed the setings very early on when I started using Family Historian. This allows me to resize the box and move it around the page easily. I’ve just tried docking it and it doesn’t suit my working style.

 

Best wishes

 

Debbie

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Mike Tate
Sent: 15 March 2021 22:45
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

If you hover on the rectangular icon at the right of the Property Box Toolbar is says ‘Dock Property Box’.

Click on that icon and the Property Box is docked to the right of the main window.

This docked mode is the installation default, so presumably you have adjusted the settings a while ago and forgotten.

Tools > Preferences > Workspaces defines whether the Property Box is Floating, Docked or Closed.

Mike Tate

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Debbie Kennett
Sent: 15 March 2021 20:46
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Mike

 

Yes I do have a floating property box. I didn’t think you could have it set any other way. I don’t have any fact witnesses so I’ve never used that box.

 

Debbie

 
Re: Displaying Sources and citations

Mike Tate
 

If you hover on the rectangular icon at the right of the Property Box Toolbar is says ‘Dock Property Box’.

Click on that icon and the Property Box is docked to the right of the main window.

This docked mode is the installation default, so presumably you have adjusted the settings a while ago and forgotten.

Tools > Preferences > Workspaces defines whether the Property Box is Floating, Docked or Closed.

Mike Tate

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Debbie Kennett
Sent: 15 March 2021 20:46
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Mike

 

Yes I do have a floating property box. I didn’t think you could have it set any other way. I don’t have any fact witnesses so I’ve never used that box.

 

Debbie

 
Re: Displaying Sources and citations

Debbie Kennett
 

Mike

 

Yes I do have a floating property box. I didn’t think you could have it set any other way. I don’t have any fact witnesses so I’ve never used that box.

 

Debbie

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Mike Tate
Sent: 15 March 2021 18:05
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Debbie,

I presume that is because you had a floating Property Box that can sit in front of other floating windows.

In FH V6, the floating Fact Witnesses window was always in front of a floating Property Box.

In FH V7, whichever floating window is clicked brings it to the front.

So as soon as you click a fact in the Property Box it jumps in front of the Fact Witnesses and Citation windows.

 

Mike Tate

 
Re: Displaying Sources and citations

Mike Tate
 

Debbie,

I presume that is because you had a floating Property Box that can sit in front of other floating windows.

In FH V6, the floating Fact Witnesses window was always in front of a floating Property Box.

In FH V7, whichever floating window is clicked brings it to the front.

So as soon as you click a fact in the Property Box it jumps in front of the Fact Witnesses and Citation windows.

 

Mike Tate

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Debbie Kennett
Sent: 15 March 2021 17:02
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Mike

 

Many thanks. You are quite right. I’m glad you pointed this out! I had the floating box partially obscured by the source pane but now that I’ve moved it out to the right I can now see all the text from source details every time I click on a new record.

 

Debbie
Re: Displaying Sources and citations

Debbie Kennett
 

Mike

 

Many thanks. You are quite right. I’m glad you pointed this out! I had the floating box partially obscured by the source pane but now that I’ve moved it out to the right I can now see all the text from source details every time I click on a new record.

 

Debbie

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Mike Tate
Sent: 15 March 2021 15:46
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Debbie,

Sorry, but it sounds as if you have not actually tried out the Citation Window.

As soon as you select a different Source Citation all the details immediately change.

The Source Record details at the top and the Citation-specific details at the bottom.

It is just the same as other FH non-modal displays that change as soon as you select a different item, even in FH V6.

e.g.

Open the Property Box and then select any record to immediately see that record’s details.

Open the Fact Witnesses floating window and then select any Fact with Witnesses to immediately see their details.

 

Mike Tate

 
Re: Displaying Sources and citations

Mike Tate
 

Debbie,

Sorry, but it sounds as if you have not actually tried out the Citation Window.

As soon as you select a different Source Citation all the details immediately change.

The Source Record details at the top and the Citation-specific details at the bottom.

It is just the same as other FH non-modal displays that change as soon as you select a different item, even in FH V6.

e.g.

Open the Property Box and then select any record to immediately see that record’s details.

Open the Fact Witnesses floating window and then select any Fact with Witnesses to immediately see their details.

 

Mike Tate

 
Re: Displaying Sources and citations

Debbie Kennett
 

Mike

 

That’s true but the floating window only shows the information for the specific citation so if I have FreeBMD as a reference for a birth and I’ve included the GRO details in the text from source for the birth if I then move to to the FreeBMD source for the death for the same person I don’t want to see the reference for the birth in the floating box I want to see the reference for the death. I still have to click through again to see the text from source as soon as I go to a different record from the same source.

 

Debbie

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Mike Tate
Sent: 15 March 2021 14:34
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Debbie,

The new Citation Window is a floating window that can be left open all the time sitting over the yellow Sources For pane where the Citation details were shown in FH V6. That way there are no extra clicks once you have customised the generic Citation fields onto its Citation tab. That is all explained in the FHUG Forum thread you mentioned.

Mike Tate

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Debbie Kennett
Sent: 15 March 2021 13:02
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Unfortunately you can longer get the citations to appear in the source pane. I managed to change it so that the details are one click away rather than several clicks away which is not a perfect solution. See this thread in the FHUG Forum:

 

https://www.fhug.org.uk/forum/viewtopic.php?f=32&t=18865&p=109618#p109618

 

I prefer the way that the text from source was displayed in FH6 but the other benefits of FH7, and particularly the word-processing facilities, make it worth staying with FH7.

 

Debbie
Re: Displaying Sources and citations

Mike Tate
 

Debbie,

The new Citation Window is a floating window that can be left open all the time sitting over the yellow Sources For pane where the Citation details were shown in FH V6. That way there are no extra clicks once you have customised the generic Citation fields onto its Citation tab. That is all explained in the FHUG Forum thread you mentioned.

Mike Tate

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Debbie Kennett
Sent: 15 March 2021 13:02
To: family-historian@groups.io
Subject: Re: [family-historian] Displaying Sources and citations

 

Unfortunately you can longer get the citations to appear in the source pane. I managed to change it so that the details are one click away rather than several clicks away which is not a perfect solution. See this thread in the FHUG Forum:

 

https://www.fhug.org.uk/forum/viewtopic.php?f=32&t=18865&p=109618#p109618

 

I prefer the way that the text from source was displayed in FH6 but the other benefits of FH7, and particularly the word-processing facilities, make it worth staying with FH7.

 

Debbie
Re: Displaying Sources and citations

Debbie Kennett
 

Unfortunately you can longer get the citations to appear in the source pane. I managed to change it so that the details are one click away rather than several clicks away which is not a perfect solution. See this thread in the FHUG Forum:

 

https://www.fhug.org.uk/forum/viewtopic.php?f=32&t=18865&p=109618#p109618

 

I prefer the way that the text from source was displayed in FH6 but the other benefits of FH7, and particularly the word-processing facilities, make it worth staying with FH7.

 

Debbie

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Mike Shingleton
Sent: 14 March 2021 13:46
To: family-historian@groups.io
Subject: [family-historian] Displaying Sources and citations

 

I am getting terribly confused and appear to be going round in circles.  I am hoping some patient soul will be able to assist me.

 

In FH V6 I had source citations of both 'source splitters' and 'source lumpers'.  The former were mostly added using Ancestral Sources and were mainly Census Records and BMD records added using Ancestral Sources. However for GRO BMD references I used three generic lumped sources - GRO Birth, GRO Marriage and GRO Death.

 

Since upgrading to FH v7 the display of these records has changed.   With the property box docked I have a window to the right which shows the source but none of the citation details I could see previously.  I have tried to configure it according to other posts on this forum but without success.

 

Is there a simple way to 'revert' back to FH v6 appearance?

 

Any help would be gratefully received.

 

 

Mike S
Re: Gedcom help

Mike Tate
 

Welcome Harvey,
In addition to this groups.io forum administered by Calico Pie, there is the FH User Group (FHUG) run by volunteers:
https://fhug.org.uk/
They provide Forums and a Knowledge Base wiki with an abundance of advice.
That includes 'Importing to Family Historian' from other products such as MyHeritage:
https://fhug.org.uk/kb/kb-article/importing-to-family-historian/
That has a section dedicated to 'Import from MyHeritage (MYH)'.

The FHUG Forums include an 'Importing and Exporting' Forum to answer your questions.

So, yes, you can download your database & images into FH on your laptop without retyping line by line.

Mike Tate

-----Original Message-----
From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Harvey Mattinson
Sent: 14 March 2021 14:51
To: family-historian@groups.io
Subject: Re: [family-historian] Gedcom help

Mike,
I have just joined the group, although I have been doing FH for over 10 years. I have masses of data on Ancestry and My
Heritage, but little independent. Is there a way I can download all my data from MH without having to type line by Line. I am not
over IT savvy but hope version 7 will allow me to store information on my own laptop. Very grateful for any help.
Cheers, Harvey
locked Re: Ancestry subscription discount

Frances Atherton
 

Hi Trevor,

I believe you have to click the link then log in to your account. I’ve done it several times and it has never worked for me the other way around. 

Frances

On Mon, 15 Mar 2021 at 08:42, Trevor Rix <trevor@...> wrote:
You need to login to Ancestry first before clicking the link.

locked Re: Ancestry subscription discount

Frances Atherton
 

Hi Susan,

Once you have clicked in you then have to log-in to your ancestry account to see the deal. 

Frances 

On Mon, 15 Mar 2021 at 08:41, <susangee@...> wrote:
I just tried the link but couldn't see a one year subscription? Am I doing something wrong?

locked Re: Ancestry subscription discount

Trevor Rix
 

You need to login to Ancestry first before clicking the link.
3141 - 3160 of 6500