Query on Address fields

RogerF · Post by **RogerF** » 06 Sep 2016 11:13

Sorry if this is another senior moment. Is it possible to write a query which reports on the number of uses of each distinct entry in all Address fields? Something like:

Code: Select all

Apple Avenue       3 
Back Street       37
Corporation Road  10
...

YouTube · Post by **Jane** » 06 Sep 2016 11:20

There is a plugin for this

http://www.family-historian.co.uk/plugi ... try?id=208

RogerF · Post by **RogerF** » 06 Sep 2016 12:31

Thank you Jane, and of course Peter.

Post by **tatewise** » 06 Sep 2016 13:24

Those counts are actually built into FH via the Tools > Work with Data > Addresses dialogue and the associated Special Data Report.

StevieSteve · Post by **StevieSteve** » 07 Sep 2016 05:09

The thing about the Work with Data reports (at least in V5) is that they include the facts for everyone in the database whereas I'd like to be able to restrict them to just related or Pool 1 individuals.

It'll be MyFirstPlugin when I get the time

Post by **tatewise** » 07 Sep 2016 08:20

In the meantime Stevie, use File > Import/Export > Export > GEDCOM File and Select the desired Individuals via Add using Query. After the exported Gedcom is saved in Public folder, FH will offer to open it, and then the Work with Data details will apply to that selection of Individuals. Create whatever Custom Queries you need to Select the desired Individuals.

RogerF · Post by **RogerF** » 07 Sep 2016 17:36

Thank you, Mike,

I just can't believe I missed the Tools > Work with Data > Addresses option. Creeping senility, eh?...

StevieSteve · Post by **StevieSteve** » 09 Sep 2016 06:18

In the meantime Stevie, use ...

Thanks for that workround, Mike, it'll be very useful

Family Historian User Group

* Query on Address fields

Query on Address fields

Re: Query on Address fields

Re: Query on Address fields

Re: Query on Address fields

Re: Query on Address fields

Re: Query on Address fields

Re: Query on Address fields

Re: Query on Address fields