*Query for source note

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
MB@RE
Platinum
Posts: 30
Joined: 14 Sep 2013 11:04
Family Historian: V6
Location: Warwickshire

Query for source note

Postby MB@RE » 14 Apr 2018 20:52

Hi,

I've recently had a computer failure so I'm now having to re-do a lot of my settings.
I previously had a customised column in the records window which run from the Query. (for Probate Value)
The problem is, I'm trying to find the exact Source note field so I can re-run this query.
See the screen shot to show where I put the data.

I'd be grateful if you can advise the quote field record to chose.

My event is Probate.

Many thanks
Mike

Capture.PNG
Capture.PNG (29.43 KiB) Viewed 606 times
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs

User avatar
tatewise
Megastar
Posts: 14359
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Query for source note

Postby tatewise » 14 Apr 2018 21:30

Mike, when you have recovered your settings do use the Backup and Restore Family Historian Settings Plugin.
Then save its backup settings to external media the same way you save your Project Backups to external media.

I assume you are talking about the Individuals tab of the Records Window?
The column Expression you need is:
%INDI.PROB[1].SOUR[1]>NOTE2[1]%

That could be obtained by clicking the <<Insert Data Ref... button and choosing:
Individual > Events > Probate > Source> > Note ( not (Note) )
Mike Tate ~ researching the Tate and Scott family history.

MB@RE
Platinum
Posts: 30
Joined: 14 Sep 2013 11:04
Family Historian: V6
Location: Warwickshire

Re: Query for source note

Postby MB@RE » 14 Apr 2018 21:56

Hi Mike,

Yes. The query type is 'Individual'.

Sadly, there was no way back for the hard drive, the MS tool wasn't able to repair the problem, so I've lost some data and settings. A harsh lesson.

Thanks for your help Mike - i'll give a whirl.

Mike B.
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs

MB@RE
Platinum
Posts: 30
Joined: 14 Sep 2013 11:04
Family Historian: V6
Location: Warwickshire

Re: Query for source note

Postby MB@RE » 14 Apr 2018 22:13

Mike,

The expression was fantastic - thanks.

Just trying to understand your advice on getting there the other way :
Quote
That could be obtained by clicking the <<Insert Data Ref... button and choosing:
Individual > Events > Probate > Source> > Note ( not (Note) )
Unquote

I was a bit lost. I'm guessing this is the Field window in the Column Tab.
The difference you get is
%INDI.PROB[1].SOUR[1]>NOTE2[1]% (your expression)
and
%INDI.PROB[1].SOUR[1].NOTE2[1]% (insert ref)

The '>' and '.' is the only difference in the string and the '>' works -

I'm no techy i'm afraid.


BR
Mike
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs

User avatar
tatewise
Megastar
Posts: 14359
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Query for source note

Postby tatewise » 14 Apr 2018 23:20

You may not be techy, but you do know that Source records are separate from Individual records.
You should also know that in Data References the > symbol indicates the linkage between records.
So Source> indicates a linked Source record and produces the SOUR[1]> component.
A Source Note that produces SOUR[1] is something local to the Individual record.
Mike Tate ~ researching the Tate and Scott family history.

MB@RE
Platinum
Posts: 30
Joined: 14 Sep 2013 11:04
Family Historian: V6
Location: Warwickshire

Re: Query for source note

Postby MB@RE » 15 Apr 2018 10:41

Thanks again for your reply Mike.

Appreciate the advice a lot.

BR
Mike
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs


Return to “General Usage”

Who is online

Users browsing this forum: No registered users and 16 guests