* Queries for Notes

Older V4 Queries please post for any version in the General Forum
Locked
avatar
donone
Famous
Posts: 123
Joined: 14 Aug 2008 19:23
Family Historian: V5
Contact:

Queries for Notes

Post by donone » 17 Feb 2012 09:08

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

User avatar
tatewise
Megastar
Posts: 27074
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Queries for Notes

Post by tatewise » 17 Feb 2012 09:49

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.  
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
donone
Famous
Posts: 123
Joined: 14 Aug 2008 19:23
Family Historian: V5
Contact:

Queries for Notes

Post by donone » 17 Feb 2012 10:55

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.

User avatar
tatewise
Megastar
Posts: 27074
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Queries for Notes

Post by tatewise » 17 Feb 2012 13:05

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.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
donone
Famous
Posts: 123
Joined: 14 Aug 2008 19:23
Family Historian: V5
Contact:

Queries for Notes

Post by donone » 17 Feb 2012 15:54

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.

User avatar
tatewise
Megastar
Posts: 27074
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Queries for Notes

Post by tatewise » 17 Feb 2012 16:52

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.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Locked