Hello. I have prepared about 121000 which I am going to delete from my project after splitting. Just have to be sure I have found the right people to delete before really doing it. I have flagged the people to be deleted with a flag called "AAS" with values Y (Yes) and N (No). Y for those I am going to delete (accented with a blue color) ,and N for the others with the usual green-like color (which I will keep). I am now working on finding out if I have forgotten people who should get the N instead of Y since I may have missed some who still have the Y. I was able to find some spouses and set them to N to keep ,but have some trouble with finding parents..... Therefore ,I wonder what`s the filter for finding "AAS" flags with Y that has parents marked with "AAS" and N??? Hopefully that would be a filter that let me find people with the AAS Y flag who should be kept because their parents have AAS and N. Guess some filter could be done on List of people.....(I have a "Possibles" flag as well ,but not sure if that can be used on the List of people to something....) (Have worked a bit with trying out different filters ,but not seemingly getting the right one....) Erik

At 2/7/2019 09:30, Erik Hov wrote >Therefore ,I wonder what`s the filter for finding "AAS" flags with Y that >has parents marked with "AAS" and N??? Hopefully that would be a filter that >let me find people with the AAS Y flag who should be kept because their >parents have AAS and N. >Guess some filter could be done on List of people.....(I have a "Possibles" >flag as well ,but not sure if that can be used on the List of people to >something....) You cannot create a filter for people based on conditions of other people. The only thing I can suggest is to make a report of persons with the AAS Y Flag which include the parents' ID#s and then checking the parents for the AAS Flag setting. However, the size of the list would prohibit this in my mind. I am brainstorming on this, but possibly sending the above report to a speadsheet which can then be sorted on the parent's ID#(s) and then another report of persons with the AAS N Flag and combine the two such that the same ID#s for parents in the first group might be close to the similar ID#s of the second group. This might allow a relatively fast review and give what you need. Lee

I could make two reports of persons and sort it in excel etc...... But it also belong to the story that I have 993000 people in total in my project just now (therefore splitting up!!!) ,so the AAS N people would result in a list of about 870000 people and a AAS Y list would be about 120000......so it would be many to go through to actually find the people that should not be deleted (it is probably a very small amount). -----Opprinnelig melding----- Fra: Lee Hoffman [mailto:azchief@bellsouth.net] Sendt: 7. februar 2019 16:20 Til: The Master Genealogist Rootsweb Email List <tmg@rootsweb.com> Emne: [TMG] Re: flag and filter... At 2/7/2019 09:30, Erik Hov wrote >Therefore ,I wonder what`s the filter for finding "AAS" flags with Y >that has parents marked with "AAS" and N??? Hopefully that would be a >filter that let me find people with the AAS Y flag who should be kept >because their parents have AAS and N. >Guess some filter could be done on List of people.....(I have a "Possibles" >flag as well ,but not sure if that can be used on the List of people to >something....) You cannot create a filter for people based on conditions of other people. The only thing I can suggest is to make a report of persons with the AAS Y Flag which include the parents' ID#s and then checking the parents for the AAS Flag setting. However, the size of the list would prohibit this in my mind. I am brainstorming on this, but possibly sending the above report to a speadsheet which can then be sorted on the parent's ID#(s) and then another report of persons with the AAS N Flag and combine the two such that the same ID#s for parents in the first group might be close to the similar ID#s of the second group. This might allow a relatively fast review and give what you need. Lee _______________________________________________ Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/tmg@rootsweb.com Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community

Erik Hov asked for: > a filter that let me find people with the AAS Y flag > who should be kept because their parents have AAS and N... > I have a "Possibles" flag as well... As Lee noted, you cannot do this with just one Flag. That is why I earlier described using a second Flag, like your "Possibles" Flag, to help with your efforts. It is also needed in this situation. The "trick" is one I mentioned to you last year: the bottom of the Filter screen lets you add Ancestors to the filter qualifying people. Based on your comments the people with AAS=Y is smaller than those with N. So, run a List of People report filtered for AAS = Y. BUT at the bottom of the Filter definition check (only) the Ancestors box and set it to one generation (which are these qualifying people's parents). On the Secondary Output tab of the Report Options, cause the report to set the Possibles Flag to 'Y' for these people. Thus all the AAS=Y people PLUS their parents now will have Possibles=Y. If the parents already have AAS=Y they will not add to the count. The count of people will only increase by parents who have AAS-N. Now run a second List of People report filtered for Possibles=Y AND AAS=N. This will result in a much shorter list, and will be a list just of those parents who have AAS=N but who have a child with AAS=Y. While that is a list of the parents not of the children, it should be a small enough list. Just review all these parents, and see if you wish to change any of their chilren whose AAS Flag value is Y to instead be N. Could you get a list of just the children? Yes, but that would involve using a third Flag, and another LOP filter which added descendants to one generation, etc. But this list of parents should be small enough to not need doing that, especially if a single set of AAS=N parents have multiple children with AAS=Y. Michael

Thanks for answering!. I did create the Possibles flag. Went to the List of People and filtered for AAS=Y and checked the ancestor box with one generation. Then going to Secondary output setting the Possibles flag to Y for those people which changed the Possibles flag to Y for 121944 people. So all in all ,the first run of List of People went very well. Some trouble when coming to the second time I shall run the List of People report. With filtering for Possibles=Y AND AAS=N ,I still get 121944 people......is the filter correct? The project explorer tells me it`s 121605 AAS Y with primary names and 121909 with both primary and non primary AAS Y names. -----Opprinnelig melding----- Fra: Michael J. Hannah [mailto:mjh@rr-nm.net] Sendt: 7. februar 2019 19:02 Til: The Master Genealogist Rootsweb Email List <tmg@rootsweb.com> Kopi: gj_erov7@bbnett.no Emne: [TMG] Re: flag and filter... Erik Hov asked for: > a filter that let me find people with the AAS Y flag who should be > kept because their parents have AAS and N... > I have a "Possibles" flag as well... As Lee noted, you cannot do this with just one Flag. That is why I earlier described using a second Flag, like your "Possibles" Flag, to help with your efforts. It is also needed in this situation. The "trick" is one I mentioned to you last year: the bottom of the Filter screen lets you add Ancestors to the filter qualifying people. Based on your comments the people with AAS=Y is smaller than those with N. So, run a List of People report filtered for AAS = Y. BUT at the bottom of the Filter definition check (only) the Ancestors box and set it to one generation (which are these qualifying people's parents). On the Secondary Output tab of the Report Options, cause the report to set the Possibles Flag to 'Y' for these people. Thus all the AAS=Y people PLUS their parents now will have Possibles=Y. If the parents already have AAS=Y they will not add to the count. The count of people will only increase by parents who have AAS-N. Now run a second List of People report filtered for Possibles=Y AND AAS=N. This will result in a much shorter list, and will be a list just of those parents who have AAS=N but who have a child with AAS=Y. While that is a list of the parents not of the children, it should be a small enough list. Just review all these parents, and see if you wish to change any of their chilren whose AAS Flag value is Y to instead be N. Could you get a list of just the children? Yes, but that would involve using a third Flag, and another LOP filter which added descendants to one generation, etc. But this list of parents should be small enough to not need doing that, especially if a single set of AAS=N parents have multiple children with AAS=Y. Michael _______________________________________________ Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/tmg@rootsweb.com Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community

On 2/7/19 9:30 AM, Erik Hov wrote: > Hello. > I have prepared about 121000 which I am going to delete from my project > after splitting. Just have to be sure I have found the right people to > delete before really doing it. > I have flagged the people to be deleted with a flag called "AAS" with values > Y (Yes) and N (No). > Y for those I am going to delete (accented with a blue color) ,and N for the > others with the usual green-like color (which I will keep). > I am now working on finding out if I have forgotten people who should get > the N instead of Y since I may have missed some who still have the Y. > I was able to find some spouses and set them to N to keep ,but have some > trouble with finding parents..... > Therefore ,I wonder what`s the filter for finding "AAS" flags with Y that > has parents marked with "AAS" and N??? Hopefully that would be a filter that > let me find people with the AAS Y flag who should be kept because their > parents have AAS and N. > Guess some filter could be done on List of people.....(I have a "Possibles" > flag as well ,but not sure if that can be used on the List of people to > something....) > (Have worked a bit with trying out different filters ,but not seemingly > getting the right one....) > Erik > The way I handle something like this is with a secondary (possibly temporary) flag. Set the flag to one value for everyone (or create it and it will start defaulted to the first value). Then run a list of people report for AAS = N and have it add descendants (and maybe spouses), and have this set the flag to the second value. Then run a filter to reset the flag for those people with AAS = N (but not their descendants), and the people left with the flag set are those with AAS = Y, but are the descendant of someone with it set to N. -- Richard Damon

Thanks. I think I have solved this.....and I did overlook something!!. I tried to follow what Michael wrote about the 2nd List of People report with a filter Possibles=Y AND AAS=N. I did actually run a 2nd List of People report ,but overlooked that the AAS flag in the 2nd filter had an N and not a an Y!. Since I used an Y ,the result became 121944 people after the 2nd report instead of 339 after setting AAS = N and not Y!!. I had tried out two different filters: Possibles=Y AND AAS are not J which produced 772 people (including 1 generation with ancestors) When not checking anything on the filter (ancestors ,spouses or descendants) using the same filter "Possibles=Y AND AAS are not J" I got down to 339 (The same result as Possibles=Y AND AAS=N would give). I have saved both these reports.....guess the one with 339 people would be the one I have to go through ,but what about the one with 772? Not sure about the difference between them ,but it seems like the one with 772 has more parents ,and some of those parents also have the AAS flag with value of Y ,so guess the 339 people report would be the right one........?? Somehow the 772 people report seems to give the parents with AAS=N/Y having children with AAS=Y/N plus one generation etc -----Opprinnelig melding----- Fra: Richard Damon [mailto:Richard@Damon-Family.org] Sendt: 8. februar 2019 04:11 Til: tmg@rootsweb.com Emne: [TMG] Re: [SPAM?] flag and filter... On 2/7/19 9:30 AM, Erik Hov wrote: > Hello. > I have prepared about 121000 which I am going to delete from my > project after splitting. Just have to be sure I have found the right > people to delete before really doing it. > I have flagged the people to be deleted with a flag called "AAS" with > values Y (Yes) and N (No). > Y for those I am going to delete (accented with a blue color) ,and N > for the others with the usual green-like color (which I will keep). > I am now working on finding out if I have forgotten people who should > get the N instead of Y since I may have missed some who still have the Y. > I was able to find some spouses and set them to N to keep ,but have > some trouble with finding parents..... > Therefore ,I wonder what`s the filter for finding "AAS" flags with Y > that has parents marked with "AAS" and N??? Hopefully that would be a > filter that let me find people with the AAS Y flag who should be kept > because their parents have AAS and N. > Guess some filter could be done on List of people.....(I have a "Possibles" > flag as well ,but not sure if that can be used on the List of people > to > something....) > (Have worked a bit with trying out different filters ,but not > seemingly getting the right one....) Erik > The way I handle something like this is with a secondary (possibly temporary) flag. Set the flag to one value for everyone (or create it and it will start defaulted to the first value). Then run a list of people report for AAS = N and have it add descendants (and maybe spouses), and have this set the flag to the second value. Then run a filter to reset the flag for those people with AAS = N (but not their descendants), and the people left with the flag set are those with AAS = Y, but are the descendant of someone with it set to N. -- Richard Damon _______________________________________________ Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/tmg@rootsweb.com Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community