Hi
I've created a custom query that lists all burial places, but what I'd like to do is filter that on just one place or part of a place just by putting in say eg: 'Rookwood' considering that I have at the moment 'three places with Rookwood'
Rookwood Cemetery, Lidcombe, New South Wales, Australia
Rookwood Memorial Gardens, Rookwood, Lidcombe, New South Wales, Australia
Roman Catholic Cemetery, Rookwood, Lidcombe, New South Wales, Australia
My custom query so far has the following information - which I need but it brings up all burial places. So how would I change the expression for the burial place which is currently %INDI.BURI.PLACE%.
Individual
Name (SURNAME)
Name (FIRST)
Death
Burial Date
Burial Place
Spouse Name (SURNAME)
Spouse Name (FIRST
Regards
Sandra
* Custom Query: events at specific place
- johnmorrisoniom
- Megastar
- Posts: 904
- Joined: 18 Dec 2008 07:40
- Family Historian: V7
- Location: Isle of Man
Re: Custom Query: events at specific place
Use a row filter to
Add if....
%INDI.BURI[1].PLAC%
Contains
and tick the Parameter box
Give the Parameter a suitable label i.e. Burial Place
The when you run it, put in the name you want (Rookwood) and Bingo
Add if....
%INDI.BURI[1].PLAC%
Contains
and tick the Parameter box
Give the Parameter a suitable label i.e. Burial Place
The when you run it, put in the name you want (Rookwood) and Bingo
- tatewise
- Megastar
- Posts: 28410
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom Query: events at specific place
Welcome to the FHUG Sandra.
You need a filter on the Rows tab with a labelled Parameter.
e.g.
Exclude unless %INDI.BURI.PLAC% contains ["Place"]
The only snag is that is matches wherever the text occurs.
So if you enter wood it would not only match Rockwood but also Sandwood and Long Wood, etc.
It can be mitigated to some extent by ticking Match case.
You need a filter on the Rows tab with a labelled Parameter.
e.g.
Exclude unless %INDI.BURI.PLAC% contains ["Place"]
The only snag is that is matches wherever the text occurs.
So if you enter wood it would not only match Rockwood but also Sandwood and Long Wood, etc.
It can be mitigated to some extent by ticking Match case.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- DavidNewton
- Superstar
- Posts: 464
- Joined: 25 Mar 2014 11:46
- Family Historian: V7
Re: Custom Query: events at specific place
At the risk of complicating matters it is worth pointing out that as single row filters the filters suggested by Mike and John do the same thing. However, added to other filters they can have differing effects.
For example, if you start by adding all individuals with a specific surname then John's filter added afterwards will provide a result set of all individuals with either the specified surname OR with a specific burial place. On the other hand, Mike's filter placed afterwards will provide a result set of all individuals with the given surname AND the specific burial place.
David
For example, if you start by adding all individuals with a specific surname then John's filter added afterwards will provide a result set of all individuals with either the specified surname OR with a specific burial place. On the other hand, Mike's filter placed afterwards will provide a result set of all individuals with the given surname AND the specific burial place.
David
- tatewise
- Megastar
- Posts: 28410
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom Query: events at specific place
David makes a valid point, and is why Exclude unless usually is a better option, as the order of the Rows tab filters is unimportant.
If you need more control over the Place name matching criteria than offered by a Query then try the Search and Replace Plugin.
On its Major Options tab, set the Search Scope on right to Burial (INDI.BURI).
Below under Basic Filters ensure that only the Place fields option is ticked.
In the Search box top left enter the Place name text to search for, i.e. Rookwood.
To the right you can choose Case sensitivity and Whole/Part Words matching.
(If you understand Regular Expressions then LUA Pattern Mode offers similar complex matching capabilities.)
Click the Search ONLY button bottom right and each matching Burial Place is shown in turn on clicking Report.
Untick Confirm every item found and click Report once more to produce a Result Set similar to your Query Result Set but with fewer column details, that may nevertheless be sufficient.
If you need more control over the Place name matching criteria than offered by a Query then try the Search and Replace Plugin.
On its Major Options tab, set the Search Scope on right to Burial (INDI.BURI).
Below under Basic Filters ensure that only the Place fields option is ticked.
In the Search box top left enter the Place name text to search for, i.e. Rookwood.
To the right you can choose Case sensitivity and Whole/Part Words matching.
(If you understand Regular Expressions then LUA Pattern Mode offers similar complex matching capabilities.)
Click the Search ONLY button bottom right and each matching Burial Place is shown in turn on clicking Report.
Untick Confirm every item found and click Report once more to produce a Result Set similar to your Query Result Set but with fewer column details, that may nevertheless be sufficient.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry