Date
1 - 11 of 11
Names listed in Place query
|
Kath Liddell
I am working with the Places query to find persons living close to each other at any time. The resulting report shows Record (names) / Date / Place / Context (BMD etc). The names are listed alphabetically by first name ... is there any way to list these by surname? Or to separate first and surnames for sorting by surname?
Here's how I get there ... Tools >> Work with data >> Places Ideally, I want to also list the Address as well as the Place. However, from past experience, any discussion of Addresses turns out a can of worms, so for now I will add addresses by hand.Where used >> Result set Many thanks. Kath |
|
|
|
Brian Horridge
Kath
toggle quoted message
Show quoted text
Against every field in a query there is a sort option, either none, ascending or descending. The query will sort by priority of any fields with sorting set - the first columns taking priority over later columns. The sort selected will show in the "Columns" window to the right of the screen (ie after the "Expression" column). One problem with this priority might be that the order you want the columns displayed may not immediately let you sort the way you want. The way I got round this was to duplicate the columns I wanted to sort by at the end of the list of columns (ie so they appear far right on the screen) and you set the requisite sort order only on these duplicated columns and all the others are set to "none". That way you can arrange the sort to suit without messing up the "view". If needed, you can shuffle the order of these duplicated "sorting" columns to get what you want. Hope this helps Brian On 06/06/2020 10:01, Kath Liddell wrote:
I am working with the Places query to find persons living close to each other at any time. The resulting report shows Record (names) / Date / Place / Context (BMD etc). The names are listed alphabetically by first name ... is there any way to list these by surname? Or to separate first and surnames for sorting by surname? |
|
|
|
Kath I have never used those tools before. I just tried it, and note that you can only select one address to be able to use 'wherer used' option, so I am curious as to how you use it in the context of finding people who live close to that address. Best Wishes, Neil
On Saturday, 6 June 2020, 10:01:15 BST, Kath Liddell <kliddell1920@...> wrote:
I am working with the Places query to find persons living close to each other at any time. The resulting report shows Record (names) / Date / Place / Context (BMD etc). The names are listed alphabetically by first name ... is there any way to list these by surname? Or to separate first and surnames for sorting by surname? Here's how I get there ... Tools >> Work with data >> Places >> Where used >> Result set Ideally, I want to also list the Address as well as the Place. However, from past experience, any discussion of Addresses turns out a can of worms, so for now I will add addresses by hand. Many thanks. Kath |
|
|
|
Kath, What you are using is not a Query so the Result Set cannot be customised. It simply what that command sequence produces. Instead, use the View > Standard Queries > Events Near Place and set the Max. Distance option to a small value. As that is a Standard Query it cannot be customised, but on the cog icon Query Menu top right choose Save as Custom Query and then you can edit that. There is much advice in the Knowledge Base on Creating a Query and customisation such as adding an Address column: https://www.fhug.org.uk/wiki/doku.php?id=how_to:creating_a_query There is also specific advice on Sort Fact Query on Owner Surname: https://www.fhug.org.uk/wiki/doku.php?id=how_to:sort_fact_query_on_owner_surname Regards, Mike Tate -----Original Message-----
From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Kath Liddell Sent: 06 June 2020 10:01 To: family-historian@groups.io Subject: [family-historian] Names listed in Place query I am working with the Places query to find persons living close to each other at any time. The resulting report shows Record (names) / Date / Place / Context (BMD etc). The names are listed alphabetically by first name ... is there any way to list these by surname? Or to separate first and surnames for sorting by surname? Here's how I get there ... Tools >> Work with data >> Places >> Where used >> Result set Ideally, I want to also list the Address as well as the Place. However, from past experience, any discussion of Addresses turns out a can of worms, so for now I will add addresses by hand. Many thanks. Kath |
|
|
|
Kath Liddell
Thanks, Brian, for your reply. I am not very practised at writing custom queries, but found that the result I obtained by the Places route was not actually customisable. It seems I need to start with Individuals and grow a query from there.
toggle quoted message
Show quoted text
Also, Neil, yes you are right, there is only one Place or Address listed in the Tools report. In my example I look for Place (not Address) = Westoe or South Shields (County Durham). Would then add Address manually. A bit of background ... I am looking for a possible feud (rightly or wrongly) between two twigs of one family (not my own directly). I have a comprehensive tree and well-filed Excel census files, which I have worked on for years. However I have only recently realised that various people in the two twigs must have lived near each other and were therefore possibly well aware of family scandal. Hence I would like to see who lived where - and when. The advantage of the Tools > Places report is that Events are combined in a single column i.e. Name > Date > Place > Event .. very tidy. On experimenting with custom queries I can separate first and surnames for sorting, and include Address, but cannot see a way to combine birth, census, residence, death places into one list. That's where I stand just now. I guess there's a lot still to learn, but I did hope there would be a way to sort the Places report by Surname. Thanks for your interest. Kath On 06/06/2020 10:17, Brian Horridge via groups.io wrote:
Kath |
|
|
|
Jane Taubman
Kath Another route to do this is to use the Map view with the time slider. If you add two marker sets one for each twig you can then see all the events mapped for the twigs and "eye ball" the relative locations. -- |
|
|
|
Brian Horridge
Kath
toggle quoted message
Show quoted text
The trick is to find the nearest-to-what-you-want Standard Query (as Mike Tate has said) and then save it as a Custom Query and tweak it to suit your own needs. Brian On 06/06/2020 15:33, Kath Liddell wrote:
Thanks, Brian, for your reply. I am not very practised at writing custom queries, but found that the result I obtained by the Places route was not actually customisable. It seems I need to start with Individuals and grow a query from there. |
|
|
|
Kath Liddell
Brian
toggle quoted message
Show quoted text
Yes, thank you, I got that far. It seems the default Census or Residence data is only the first item recorded e.g. CENS[1], so the query needs to include subsequent items e.g. CENS[2] etc, then you get too many columns. I believe there is a way to generalise the events to a single FACT, but I'll keep looking and decide on a suitable compromise. I don't use mapping in FH (only TNG) ... I know where the Places are and Addresses are too precise and not mapable. Many thanks everyone. Kath On 07/06/2020 10:07, Brian Horridge via groups.io wrote:
Kath |
|
|
|
Kath, You must have missed my earlier reply that explained exactly what to do to get started. The Query that I suggest you use is a Fact Query instead of an Individual Query Therefore it finds every instance of CENS[1], CENS[2], CENS[3], etc, automatically and in just one row each, so Place and Address are easily shown. What you were using is not a Query so the Result Set cannot be customised. It simply what that command sequence produces. Instead, use the View > Standard Queries > Events Near Place and set the Max. Distance option to a small value. As that is a Standard Query it cannot be customised, but on the cog icon Query Menu top right choose Save as Custom Query and then you can edit that custom copy. There is much advice in the Knowledge Base on Creating a Query and customisation such as adding an Address column: https://www.fhug.org.uk/wiki/doku.php?id=how_to:creating_a_query There is also specific advice on Sort Fact Query on Owner Surname: https://www.fhug.org.uk/wiki/doku.php?id=how_to:sort_fact_query_on_owner_surname Once you have got your custom copy and reviewed those advice pages, come back with any questions you may have. Regards, Mike Tate -----Original Message-----
From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Kath Liddell Sent: 07 June 2020 10:30 To: family-historian@groups.io Subject: Re: [family-historian] Names listed in Place query Brian Yes, thank you, I got that far. It seems the default Census or Residence data is only the first item recorded e.g. CENS[1], so the query needs to include subsequent items e.g. CENS[2] etc, then you get too many columns. I believe there is a way to generalise the events to a single FACT, but I'll keep looking and decide on a suitable compromise. I don't use mapping in FH (only TNG) ... I know where the Places are and Addresses are too precise and not mapable. Many thanks everyone. Kath |
|
|
|
Brian Horridge
Kath
toggle quoted message
Show quoted text
Instead of CENS[1], use CENS[year=1841] etc. This way you can have a specific column for each Census Year. I actually use %INDI.CENS[year=1841].AGE% as this immediately shows if individual has a census entry for that year and also shows how their age may vary from census to census. actually 's age On 07/06/2020 10:29, Kath Liddell wrote:
Brian |
|
|
|
I recommend that you don’t use an Individual Query at all. I though Kath was looking for Individuals associated with a Place. So every instance of every Fact needs to be included, and that needs a Fact Query. Then the columns are such as %FACT%, %FACT.AGE%, %FACT.PLAC%, %FACT.ADDR%, etc. If you want to only see CENS facts then a simple Rows filter can do that using =FactLabel(%FACT%). -----Original Message-----
From: family-historian@groups.io <family-historian@groups.io> On Behalf Of Brian Horridge via groups.io Sent: 07 June 2020 10:44 To: family-historian@groups.io Subject: Re: [family-historian] Names listed in Place query Kath Instead of CENS[1], use CENS[year=1841] etc. This way you can have a specific column for each Census Year. I actually use %INDI.CENS[year=1841].AGE% as this immediately shows if individual has a census entry for that year and also shows how their age may vary from census to census. actually 's age On 07/06/2020 10:29, Kath Liddell wrote: > Brian > > Yes, thank you, I got that far. It seems the default Census or > Residence data is only the first item recorded e.g. CENS[1], so the > query needs to include subsequent items e.g. CENS[2] etc, then you get > too many columns. I believe there is a way to generalise the events to > a single FACT, but I'll keep looking and decide on a suitable compromise. > > I don't use mapping in FH (only TNG) ... I know where the Places are > and Addresses are too precise and not mapable. > > Many thanks everyone. > Kath |
|
|
