1. Family-Historian
  2. Topics

Query not bringing back expected results

Steve Miller
 

Thank you all for your advice. It is interesting to see different approaches. I changed my Expression to:

=SourceLinks(["Source"],%INDI%)

Which I took from the Query Bev mentioned.  It does ask me to select a Source from a drop down list, instead of referencing a single source, but I can live with that!

Thank you all for your timely responses.

Steve
Vyger
 

Bev,

That is good advice, when I started many of my queries were adaptions of built in queries, no point in reinventing the wheel.

Once I go

On Sun, 31 Jul 2022, 17:16 Beverly Smallwood, <bevsmallwood@...> wrote:
Steve - I'm also brand new to Family Historian so take my advice for what it's worth.

There is a query that came with the version I downloaded called "Individuals Linked to Source..."

That returns a list of people attached to the source I designated with the number of links.  You might be able to copy and refine this query to get what you need.

Bev



On Sun, Jul 31, 2022 at 7:19 AM Steve Miller <stephen.t.miller@...> wrote:
I have created a query to list all individuals where the Rows expression:

Expression: %INDI.BIRT[1].SOUR[1]>TITL%
Operator: begins with
Value: Index of Births (GRO)

It displays the results, only if the the GRO Source is the first citation linked to the Birth field, is there a way of checking for any Sources linked to the birth field.

I am relatively new to FH so I am still finding my feet.

Thank you all in advanced

Steve

 

Beverly Smallwood
 

Steve - I'm also brand new to Family Historian so take my advice for what it's worth.

There is a query that came with the version I downloaded called "Individuals Linked to Source..."

That returns a list of people attached to the source I designated with the number of links.  You might be able to copy and refine this query to get what you need.

Bev



On Sun, Jul 31, 2022 at 7:19 AM Steve Miller <stephen.t.miller@...> wrote:
I have created a query to list all individuals where the Rows expression:

Expression: %INDI.BIRT[1].SOUR[1]>TITL%
Operator: begins with
Value: Index of Births (GRO)

It displays the results, only if the the GRO Source is the first citation linked to the Birth field, is there a way of checking for any Sources linked to the birth field.

I am relatively new to FH so I am still finding my feet.

Thank you all in advanced

Steve

 

Lorna Craig
 

You need to add more rows, testing for subsequent sources linked to a birth event, increasing the index each time.  So in the next row the expression will be %INDI.BIRT[1].SOUR[2]>TITL%,  the next will be  %INDI.BIRT[1].SOUR[3]>TITL% and so on.

You will need to add as many rows as you think will be necessary to cover the greatest number of sources you have linked to a birth event.

On 31/07/2022 13:19, Steve Miller wrote:
I have created a query to list all individuals where the Rows expression:

Expression: %INDI.BIRT[1].SOUR[1]>TITL%
Operator: begins with
Value: Index of Births (GRO)

It displays the results, only if the the GRO Source is the first citation linked to the Birth field, is there a way of checking for any Sources linked to the birth field.
Steve Miller
 

I have created a query to list all individuals where the Rows expression:

Expression: %INDI.BIRT[1].SOUR[1]>TITL%
Operator: begins with
Value: Index of Births (GRO)

It displays the results, only if the the GRO Source is the first citation linked to the Birth field, is there a way of checking for any Sources linked to the birth field.

I am relatively new to FH so I am still finding my feet.

Thank you all in advanced

Steve

 

1 - 5 of 5