Finding Specific Dates


Brian Horridge
 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian


Mike Tate
 

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian


Brian Horridge
 

Mike

Once I realised I had to change the Query type to a "Fact" query, I managed to get a list of events with that date so thanks for that.  I've also got it working with a Parameter box so I can easily check any data I like.

However, I cannot seem to see a way of displaying the relevant individual in a Column that the event "happened" to.  If I click on one of the results it takes me to the relevant Individual's Property box but none of the Query "Column" fields seem to offer a way of identifying the person in the result set.  Can this be done ??

Many thanks

Brian



On 16/12/2020 10:28, Mike Tate wrote:

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian


Virus-free. www.avg.com


Mike Tate
 

Yes, there are many ways that and other options can be exercised.

Checkout the FH standard Fact Queries like All Facts.

See the Knowledge Base for loads of advice…

https://fhug.org.uk/kb/kb-article/an-overview-of-queries/

Look under Sorting a Fact Query on Owner Surname

Also, the Downloads for Fact Queries has many examples.

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 12:20
To: family-historian@groups.io
Subject: Re: [family-historian] Finding Specific Dates

 

Mike

Once I realised I had to change the Query type to a "Fact" query, I managed to get a list of events with that date so thanks for that.  I've also got it working with a Parameter box so I can easily check any data I like.

However, I cannot seem to see a way of displaying the relevant individual in a Column that the event "happened" to.  If I click on one of the results it takes me to the relevant Individual's Property box but none of the Query "Column" fields seem to offer a way of identifying the person in the result set.  Can this be done ??

Many thanks

Brian


On 16/12/2020 10:28, Mike Tate wrote:

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian

 

Virus-free. www.avg.com

 


Brian Horridge
 

Mike

Thanks.  I've looked at the examples in the link you sent and I've got something working- I just need to play around to get the columns exactly how I want them  (after I get to grips with the function syntax which the examples will help with).

I think it would be nice if it was possible to select the functions for columns in a similar way that one can select Facts / events in queries.  I'm still on FH6 - does FH7 improve this sort of thing ??

Brian


On 16/12/2020 13:45, Mike Tate wrote:

Yes, there are many ways that and other options can be exercised.

Checkout the FH standard Fact Queries like All Facts.

See the Knowledge Base for loads of advice…

https://fhug.org.uk/kb/kb-article/an-overview-of-queries/

Look under Sorting a Fact Query on Owner Surname

Also, the Downloads for Fact Queries has many examples.

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 12:20
To: family-historian@groups.io
Subject: Re: [family-historian] Finding Specific Dates

 

Mike

Once I realised I had to change the Query type to a "Fact" query, I managed to get a list of events with that date so thanks for that.  I've also got it working with a Parameter box so I can easily check any data I like.

However, I cannot seem to see a way of displaying the relevant individual in a Column that the event "happened" to.  If I click on one of the results it takes me to the relevant Individual's Property box but none of the Query "Column" fields seem to offer a way of identifying the person in the result set.  Can this be done ??

Many thanks

Brian


On 16/12/2020 10:28, Mike Tate wrote:

You must use a Fact Query with Row filter =GetDisplayText(%FACT.DATE%, MIN) begins with 25 Dec

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 16 December 2020 09:46
To: family-historian@groups.io
Subject: [family-historian] Finding Specific Dates

 

Hi

Out of curiosity, I wanted to see how many people in my database had an "event" on 25 December (no specific year).  I tried to use the "Contains Text" query but that only looks at data fields that are defined as Text fields.

Is there an equivalent that will look at any Date field.  I can do it in the raw Gedcom file if opened in a text editor and using "Find" but it would be nice to be able to do it with FH.

Many thanks

Brian

 

Virus-free. www.avg.com

 



Mike Tate
 

No FH v7 does not provide an equivalent to the Data Ref Assistant but for functions.

 

From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io
Sent: 17 December 2020 13:20
To: family-historian@groups.io
Subject: Re: [family-historian] Finding Specific Dates

 

Mike

Thanks.  I've looked at the examples in the link you sent and I've got something working- I just need to play around to get the columns exactly how I want them  (after I get to grips with the function syntax which the examples will help with).

I think it would be nice if it was possible to select the functions for columns in a similar way that one can select Facts / events in queries.  I'm still on FH6 - does FH7 improve this sort of thing ??

Brian


Jane Taubman
 

Out of interest another way to do this without using functions on a Fact Query is to simply add a filters on the DAY and MONTH_NUMBER qualifiers for the Date.  
e.g
Add if %FACT.DATE:DAY% = 25
Exclude Unless %FACT.DATE:MONTH_NUMBER% = 12
and of course you could tick the parameter option to get them to prompt you for the Day and Month you want.


Helen Dignum
 

There is a Calendar Report function in FH7 which details all the events on the individuals or set of ancestors you choose.
See Publish/Misc Reports/Calendar


Brian Horridge
 

Jane

Thanks for an alternative way of doing things.

I've no real aversion to using Functions it's just that it's a problem getting the syntax right first time (after that I simply copy it from one to another).

Merry Christmas to everyone

Brian

On 21/12/2020 16:20, Jane Taubman wrote:

Out of interest another way to do this without using functions on a Fact Query is to simply add a filters on the DAY and MONTH_NUMBER qualifiers for the Date.  
e.g
Add if %FACT.DATE:DAY% = 25
Exclude Unless %FACT.DATE:MONTH_NUMBER% = 12
and of course you could tick the parameter option to get them to prompt you for the Day and Month you want.

Virus-free. www.avg.com