Re: [LegacyUG] doing an event search
Mark, Secondary and tertiary conditions only apply after the previous searches have been completed (see Help Files), so try reversing the order of the searches. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby Sent: Wednesday, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? Regards Mark No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1869 / Virus Database: 2092/4604 - Release Date: 11/08/11 Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Hi Ron, Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whom”, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need to do is search for an event with these criteria. Can this be done? I’m beginning to think not. Regards Mark From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 10:04 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, My apologies, after posting I realised that my answer just does not make sense when only two conditions are applied – it is valid for a third though. I have tried searching as you suggest for gardeners in the 1901 census and 8 were found, so I am not getting the results which you indicate ie. all individuals with an Event-Date of 1901 (irrespective of Event Description) and all individuals with an Event-Description of ‘gardener’ (irrespective of date), which is what I understand your question to mean. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? Regards Mark No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1869 / Virus Database: 2092/4604 - Release Date: 11/08/11 Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] doing an event search
On 09/11/2011 10:26, Mark Wilby wrote: Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whomâ€, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need to do is search for an event with these criteria. Can this be done? I’m beginning to think not. Yes, I have encountered this problem before. It is a deficiency in the Legacy Search I think. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] doing an event search
On 2011/11/09 11:01, Mark Wilby wrote: What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? In trying to get a handle on what is actually happening here, I added a single event to a single person. The event-name doesn't matter, but the description, date and location fields were 'what', 'when' and 'Where'. I then tried searching for an individual with an Event-Date Equal To when. The search came up with 15 individuals and excluded the individual to whom the solitary event was added. What was significant about the 15 individuals was they all had at least one event that had no date. Obviously, there are some non-logical things going on with the Legacy Search! -- Regards, Mike Fry Johannesburg Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] doing an event search
Mark, Ah, that is the bit which I did not get! No, you cannot search for a single Event. All Detailed searches are for Individuals or Marriages. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby Sent: Wednesday, November 09, 2011 10:26 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Hi Ron, Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whom”, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need to do is search for an event with these criteria. Can this be done? I’m beginning to think not. Regards Mark From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 10:04 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, My apologies, after posting I realised that my answer just does not make sense when only two conditions are applied – it is valid for a third though. I have tried searching as you suggest for gardeners in the 1901 census and 8 were found, so I am not getting the results which you indicate ie. all individuals with an Event-Date of 1901 (irrespective of Event Description) and all individuals with an Event-Description of ‘gardener’ (irrespective of date), which is what I understand your question to mean. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby Sent: Wednesday, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? Regards Mark Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Ron, Mark I am struggling to understand the problem. In search you can search for an individual who has a specific event name which occurred on a specific date that has a specific description. Alan From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 11:46 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, Ah, that is the bit which I did not get! No, you cannot search for a single Event. All Detailed searches are for Individuals or Marriages. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 10:26 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Hi Ron, Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whom”, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need to do is search for an event with these criteria. Can this be done? I’m beginning to think not. Regards Mark From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 10:04 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, My apologies, after posting I realised that my answer just does not make sense when only two conditions are applied – it is valid for a third though. I have tried searching as you suggest for gardeners in the 1901 census and 8 were found, so I am not getting the results which you indicate ie. all individuals with an Event-Date of 1901 (irrespective of Event Description) and all individuals with an Event-Description of ‘gardener’ (irrespective of date), which is what I understand your question to mean. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? Regards Mark Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] doing an event search
On 09/11/2011 11:53, Alan Pereira wrote: I am struggling to understand the problem. In search you can search for an individual who has a specific event name which occurred on a specific date that has a specific description. Not quite! I have individuals who all appeared in the 1911 Census. They all have several Events with the specific name England Census and some of them have Descriptions which include Clerk. If I search for Individual with EventName equals England Census AND EventDate equal 02 April 1911 AND EventDescription contains Clerk I DO NOT get ONLY those people whose 1911 England Census includes Clerk, but I get all those who have England Census Events, one of which is dated 02 April 1911 and any of which might contain Clerk. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Wow! That suggests the AND operators are not working properly. I had not come across this problem, which explains my not understanding. My apologies to all. I guess building more complex searches via tagging is out then! Alan -Original Message- From: Jenny M Benson [mailto:ge...@cedarbank.me.uk] Sent: 09 November 2011 12:14 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search On 09/11/2011 11:53, Alan Pereira wrote: I am struggling to understand the problem. In search you can search for an individual who has a specific event name which occurred on a specific date that has a specific description. Not quite! I have individuals who all appeared in the 1911 Census. They all have several Events with the specific name England Census and some of them have Descriptions which include Clerk. If I search for Individual with EventName equals England Census AND EventDate equal 02 April 1911 AND EventDescription contains Clerk I DO NOT get ONLY those people whose 1911 England Census includes Clerk, but I get all those who have England Census Events, one of which is dated 02 April 1911 and any of which might contain Clerk. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Yes Alan But you get a mixture of both search criteria as well. mark From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: 09 November 2011 11:53 To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Ron, Mark I am struggling to understand the problem. In search you can search for an individual who has a specific event name which occurred on a specific date that has a specific description. Alan From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 11:46 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, Ah, that is the bit which I did not get! No, you cannot search for a single Event. All Detailed searches are for Individuals or Marriages. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 10:26 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Hi Ron, Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whom”, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need to do is search for an event with these criteria. Can this be done? I’m beginning to think not. Regards Mark From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 10:04 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, My apologies, after posting I realised that my answer just does not make sense when only two conditions are applied – it is valid for a third though. I have tried searching as you suggest for gardeners in the 1901 census and 8 were found, so I am not getting the results which you indicate ie. all individuals with an Event-Date of 1901 (irrespective of Event Description) and all individuals with an Event-Description of ‘gardener’ (irrespective of date), which is what I understand your question to mean. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? Regards Mark Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Mark, If you take the search results and tag them say with tag 1, then use tag1 as the first criteria and one of your criteria as the second condition, does that change the result. Alan From: Mark Wilby [mailto:mark.wil...@sky.com] Sent: 09 November 2011 12:32 To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Yes Alan But you get a mixture of both search criteria as well. mark From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: 09 November 2011 11:53 To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Ron, Mark I am struggling to understand the problem. In search you can search for an individual who has a specific event name which occurred on a specific date that has a specific description. Alan From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 11:46 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, Ah, that is the bit which I did not get! No, you cannot search for a single Event. All Detailed searches are for Individuals or Marriages. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 10:26 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Hi Ron, Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whom”, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need to do is search for an event with these criteria. Can this be done? I’m beginning to think not. Regards Mark From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 10:04 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, My apologies, after posting I realised that my answer just does not make sense when only two conditions are applied – it is valid for a third though. I have tried searching as you suggest for gardeners in the 1901 census and 8 were found, so I am not getting the results which you indicate ie. all individuals with an Event-Date of 1901 (irrespective of Event Description) and all individuals with an Event-Description of ‘gardener’ (irrespective of date), which is what I understand your question to mean. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby mailto:mark.wil...@sky.com Sent: Wednesday, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and all events with the description of “not looked for”. Can any kind soul help? Regards Mark Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http
Re: [LegacyUG] doing an event search
On Wed, 9 Nov 2011 12:24:50 -, Alan Pereira alanpere...@tiscali.co.uk wrote: That suggests the AND operators are not working properly. No, it is working properly ... just not the way you expect. In English, Jenny's query looks something like... Find all individuals with an event where EventName equals England Census AND with an event where EventDate equals 02 April 1911 AND with an event where EventDescription contains Clerk. If an individual had 3 events as follows... 1) EventName England Census EventDate 02 April 1891 EventDescription Smith 2) EventName Residence EventDate 02 April 1911 EventDescription 123 Mayfair 3) EventName Occupation EventDate 02 April 1901 EventDescription Clerk ... the individual would be selected. What she really wanted was... Find all individuals with an event where EventName equals England Census AND EventDate equals 02 April 1911 AND EventDescription contains Clerk. -- Dennis Kowallek (LTools/Custom Programming) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] doing an event search
On 09/11/2011 12:36, Alan Pereira wrote: If you take the search results and tag them say with tag 1, then use tag1 as the first criteria and one of your criteria as the second condition, does that change the result. Because you can only search on Individuals or Marriages, you can't look for a particular Event with a particular criterion, only for an Individual who has both that Event and *an* Event with that criterion - which may or may not be the same Event. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Jenny, Dennis Thank you for clearing that up, I got there in the end. Even breaking the query down with advanced tagging will end up with the same results. Alan -Original Message- From: Dennis M. Kowallek [mailto:kowal...@iglou.com] Sent: 09 November 2011 13:16 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search On Wed, 9 Nov 2011 12:24:50 -, Alan Pereira alanpere...@tiscali.co.uk wrote: That suggests the AND operators are not working properly. No, it is working properly ... just not the way you expect. In English, Jenny's query looks something like... Find all individuals with an event where EventName equals England Census AND with an event where EventDate equals 02 April 1911 AND with an event where EventDescription contains Clerk. If an individual had 3 events as follows... 1) EventName England Census EventDate 02 April 1891 EventDescription Smith 2) EventName Residence EventDate 02 April 1911 EventDescription 123 Mayfair 3) EventName Occupation EventDate 02 April 1901 EventDescription Clerk ... the individual would be selected. What she really wanted was... Find all individuals with an event where EventName equals England Census AND EventDate equals 02 April 1911 AND EventDescription contains Clerk. -- Dennis Kowallek (LTools/Custom Programming) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] doing an event search
On Wed, 9 Nov 2011 16:44:52 -, Alan Pereira alanpere...@tiscali.co.uk wrote: Even breaking the query down with advanced tagging will end up with the same results. You can do it with Access or LTools. Using Jenny's example, the query would look something like ... SELECT tblIR.IDIR AS RIN FROM (tblET INNER JOIN tblER ON tblET.IDET = tblER.IDET) INNER JOIN tblIR ON tblER.IDIR = tblIR.IDIR WHERE (((tblET.EventType)=England Census) AND ((tblER.IDType)=0) AND ((tblER.Description)=Clerk) AND ((tblER.EventD) Like 0002041860*)); This query has not been tested thoroughly. If you wanted to tag the individuals on Tag1... UPDATE (tblET INNER JOIN tblER ON tblET.IDET = tblER.IDET) INNER JOIN tblIR ON tblER.IDIR = tblIR.IDIR SET tblIR.Tag1 = 1 WHERE (((tblET.EventType)=England Census) AND ((tblER.IDType)=0) AND ((tblER.Description)=Clerk) AND ((tblER.EventD) Like 0002041860*)); Again, not tested thoroughly. -- Dennis Kowallek (LTools/Custom Programming) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] doing an event search
Hi Mark, and others, I think you will find that the 'And' operator is working properly. The problem is not being able to select a specific event when using 'Event Description' as one of the parameters. If you select 1. 'Event-Name' 'Equal To' 1911 census 2. AND 'Event-Description'of 'Not Equal To' 'blank' ... it will return the expected results ONLY if there are no other events in that record. In other words, if you have any number of records with more than one event, including '1911 census', the second 'AND' condition looks at all the events in that record, not just the event equal to '1911 census'. There is no way to narrow down the search to find only the '1911 census' with no data (or specific data) in the Event Description field. Note, too, that the 'Event Description' is different from 'Notes' contained in the Event. Hope I was able to explain it properly. Bob -Original Message- From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: Wednesday, November 09, 2011 4:25 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Wow! That suggests the AND operators are not working properly. I had not come across this problem, which explains my not understanding. My apologies to all. I guess building more complex searches via tagging is out then! Alan -Original Message- From: Jenny M Benson [mailto:ge...@cedarbank.me.uk] Sent: 09 November 2011 12:14 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search On 09/11/2011 11:53, Alan Pereira wrote: I am struggling to understand the problem. In search you can search for an individual who has a specific event name which occurred on a specific date that has a specific description. Not quite! I have individuals who all appeared in the 1911 Census. They all have several Events with the specific name England Census and some of them have Descriptions which include Clerk. If I search for Individual with EventName equals England Census AND EventDate equal 02 April 1911 AND EventDescription contains Clerk I DO NOT get ONLY those people whose 1911 England Census includes Clerk, but I get all those who have England Census Events, one of which is dated 02 April 1911 and any of which might contain Clerk. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp