Having produced my data in two time separated stages I find I would rather have not done certain things (heard that before?).
I am trying to create a Query based on finding all Marriage Notes (as attached to Status & Note) so that I may delete them.
I have found Status under Misc for the Add If Expression but not the Note (which seem to be sprinkled around the list).
The Status has always been blank and so cannot be searched as a link to the Note.
Any advice please that will avoid manual per couple editing.
ID:5930
* Queries for Notes
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Queries for Notes
Since these are Family Record details, I would advise using a Family Query rather than an Individual Query.
Then on the Columns tab in the Fields pane on the left you should find the data you want.
e.g.
Family + Miscellaneous + Status gives you Marriage Status.
Family + Notes + Note gives you Notes on the Family Record as a whole.
Family + Events + Marriage + Note gives you Notes on the Marriage Event Fact.
Similar Notes are possible on Divorce, Annulment, and other Family Facts.
Run the Query and in the Result Set select the fields to be deleted and click Delete key on keyboard.
There is a warning in case you need to change your mind.
FYI: I often experiment on the Family Historian Sample Project, because it avoids damaging my main Projects, and can be easily reset to a known state by using File > Project Window > More Tasks > Samples > Reset Sample Project.
Then on the Columns tab in the Fields pane on the left you should find the data you want.
e.g.
Family + Miscellaneous + Status gives you Marriage Status.
Family + Notes + Note gives you Notes on the Family Record as a whole.
Family + Events + Marriage + Note gives you Notes on the Marriage Event Fact.
Similar Notes are possible on Divorce, Annulment, and other Family Facts.
Run the Query and in the Result Set select the fields to be deleted and click Delete key on keyboard.
There is a warning in case you need to change your mind.
FYI: I often experiment on the Family Historian Sample Project, because it avoids damaging my main Projects, and can be easily reset to a known state by using File > Project Window > More Tasks > Samples > Reset Sample Project.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Queries for Notes
Thank you again.
I did follow the correct path (Family etc) but I came unstuck with Note. There are a bewildering number of them in the tree.
Under Note it is possible to find endless levels all headed 'Note' as they get deeper and deeper. Some produce i.e. %FAM.NOTE.SOUR2% and some %FAM.NOTE>SOUR2% and more... %FAM.NOTE.SOUR>%
I will experiment as you suggest.
I did follow the correct path (Family etc) but I came unstuck with Note. There are a bewildering number of them in the tree.
Under Note it is possible to find endless levels all headed 'Note' as they get deeper and deeper. Some produce i.e. %FAM.NOTE.SOUR2% and some %FAM.NOTE>SOUR2% and more... %FAM.NOTE.SOUR>%
I will experiment as you suggest.
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Queries for Notes
I think we did discuss Notes before, and there are a lot, because almost every GEDCOM item can have a Note attached.
Once you become more familiar with the GEDCOM data structure and the Data Reference syntax it will become clearer.
The Knowledge Base article Understanding Data References may help.
The trick is recognising some important Tags and Connectors.
The following is not comprehensive, but covers the popular items.
The Tags INDI, FAM, SOUR, REPO & OBJE refer to Individual, Family, Source, Repository, and Multimedia Records as per the FH Record Window tabs.
The Connectors:
. (dot) associates a Record to a Field, or a Field within a Field.
e.g.
INDI.BIRT.PLAC is an Individual Birth Place.
SOUR.AUTH is a Source Author.
> indicates a Record link.
e.g.
INDI.BIRT.SOUR> links a Birth Fact to a Source Record.
SOUR.OBJE> links a Source Record to a Multimedia Record.
[?] identifies one instance of a Field.
e.g.
INDI.CENS[1] identifies 1st Census Event.
INDI.CENS[3] identifies 3rd Census Event.
So putting this together:
INDI.NOTE2 is an Individual whole record Note.
INDI.BIRT.NOTE2 is a Birth Fact Note.
INDI.BIRT.NOTE> is a Birth Fact link to a Note Record
INDI.CENS[2].SOUR>NOTE2 is 2nd Census Fact linked to a Source Record Note.
Once you become more familiar with the GEDCOM data structure and the Data Reference syntax it will become clearer.
The Knowledge Base article Understanding Data References may help.
The trick is recognising some important Tags and Connectors.
The following is not comprehensive, but covers the popular items.
The Tags INDI, FAM, SOUR, REPO & OBJE refer to Individual, Family, Source, Repository, and Multimedia Records as per the FH Record Window tabs.
The Connectors:
. (dot) associates a Record to a Field, or a Field within a Field.
e.g.
INDI.BIRT.PLAC is an Individual Birth Place.
SOUR.AUTH is a Source Author.
> indicates a Record link.
e.g.
INDI.BIRT.SOUR> links a Birth Fact to a Source Record.
SOUR.OBJE> links a Source Record to a Multimedia Record.
[?] identifies one instance of a Field.
e.g.
INDI.CENS[1] identifies 1st Census Event.
INDI.CENS[3] identifies 3rd Census Event.
So putting this together:
INDI.NOTE2 is an Individual whole record Note.
INDI.BIRT.NOTE2 is a Birth Fact Note.
INDI.BIRT.NOTE> is a Birth Fact link to a Note Record
INDI.CENS[2].SOUR>NOTE2 is 2nd Census Fact linked to a Source Record Note.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Queries for Notes
A mine of valuable information.
That is very clear and answers a lot, thank you for the time.
Just as an aside
I have just experimented and found that the photograph Face feature is useful if used with a Source Photo of BMD records to pick out the person referred to, assuming I had no other way of highlighting it or cutting it out. Hovering the mouse at least shows the part of the page required for zooming.
That is very clear and answers a lot, thank you for the time.
Just as an aside
I have just experimented and found that the photograph Face feature is useful if used with a Source Photo of BMD records to pick out the person referred to, assuming I had no other way of highlighting it or cutting it out. Hovering the mouse at least shows the part of the page required for zooming.
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Queries for Notes
Yes, I use that feature a lot, exactly as you say, to highlight the part of a large document relevant to an individual.
When you get to publishing Reports, you will find these highlighted parts are automatically incorporated.
When you get to publishing Reports, you will find these highlighted parts are automatically incorporated.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry