Re: All Source / Media documents
Posted: 29 Nov 2021 20:52
Start with the FHUG Knowledge Base Download Fact Query Citation Details. ( See also Citation Details – Multiple. )
That has Columns for more than you need but gives more examples than the standard All Facts query.
You can remove the Columns you don't want.
It already has a Cit. Image %FACT.SOUR[1].OBJE[1]>% column for Media linked to the Citation itself.
You may need to add Source Media Record Media %FACT.SOUR[1]>OBJE[1]>% for Media linked to the Source Record.
Do you know whether you are looking for Citation Media or Source Media?
You'll need to add FILE[1] to the end of those Data Refs to show the actual Filename path.
All the above can be derived from the Fields data reference assistant on the left.
However, they only refer to the 1st SOUR[1] Source Citation for each Fact and the 1st OBJE[1] linked Media.
So you will need to add SOUR[2], SOUR[3], et seq and OBJE[2], OBJE[3], et seq to include 2nd, 3rd, etc, instances.
e.g. %FACT.SOUR[3]>OBJE[2]>FILE[1]% refers to the 3rd Source Citation and its 2nd linked Media file.
The Rows filter will need to use the =IsInList(...) function on the Owner Individual and the Named List.
However, that gets more complex for Family facts that have two Individual Owners. We can discuss that later.
The Rows filter must also exclude Facts without the Source Citations and Media you are looking for.
Do you need help with that?
That has Columns for more than you need but gives more examples than the standard All Facts query.
You can remove the Columns you don't want.
It already has a Cit. Image %FACT.SOUR[1].OBJE[1]>% column for Media linked to the Citation itself.
You may need to add Source Media Record Media %FACT.SOUR[1]>OBJE[1]>% for Media linked to the Source Record.
Do you know whether you are looking for Citation Media or Source Media?
You'll need to add FILE[1] to the end of those Data Refs to show the actual Filename path.
All the above can be derived from the Fields data reference assistant on the left.
However, they only refer to the 1st SOUR[1] Source Citation for each Fact and the 1st OBJE[1] linked Media.
So you will need to add SOUR[2], SOUR[3], et seq and OBJE[2], OBJE[3], et seq to include 2nd, 3rd, etc, instances.
e.g. %FACT.SOUR[3]>OBJE[2]>FILE[1]% refers to the 3rd Source Citation and its 2nd linked Media file.
The Rows filter will need to use the =IsInList(...) function on the Owner Individual and the Named List.
However, that gets more complex for Family facts that have two Individual Owners. We can discuss that later.
The Rows filter must also exclude Facts without the Source Citations and Media you are looking for.
Do you need help with that?