Thanks Mike. The last filter in your list doesn't seem to work, but I don't think it is needed. I don't think it is possible to create a blank custom sentence (if you try, it reverts to the default sentence). I am also a bit confused about the second and third lines in the list below. How would it be possible to have a Note or Multimedia attached to a Source citation when you have already excluded all facts with Source citations? However, these refinements go well beyond what is needed to find most instances of 'empty' facts, so I am hapy with the query as it stands. Thanks again Lorna On 21/04/2014 15:34, Beryl & Mike Tate wrote: > Lorna, > You are correct, but to be pedantic there are several other cases that need to be covered too. > =IsTrue(%FACT.SOUR% = "") for Source Citation and most associated fields > =IsTrue(%FACT.SOUR2% = "") for Note attached to Citation > =IsTrue(%FACT.OBJE% = "") for Multimedia attached to Citation > =IsTrue(%FACT.TYPE% = "") for Fact Descriptor > =IsTrue(%FACT.PHON% = "") for Fact Phone No > =IsTrue(%FACT._EMAIL % = "") for Fact E-mail Addr > =IsTrue(%FACT._WEB% = "") for Fact Website > =IsTrue(%FACT.AGNC% = "") for Fact Responsible Agency > =IsTrue(%FACT.OBJE2% = "") for Fact Local Multimedia > =IsTrue(%FACT.NOTE% = "") for Fact linked Note Record > =IsTrue(%FACT.SENT% = "") for Fact custom Sentence > > I have added all these to the KB posting. >
Hi Lorna, I know it is a bit convoluted, but you have the logic back to front. The last filter is saying Exclude unless =IsTrue(%FACT.SENT% = "") is true i.e. Keep the Fact in the Result Set if it has NO custom Sentence, which is the normal case. But if it has a non-standard customised Sentence (not a blank one) then we must not delete the Fact, so exclude it from Result Set. The second and third lines are needed because it possible to add Notes and Multimedia to Citations even when there is no linked Source Record. Such are the mysterious ways of GEDCOM structures. Regards, Mike Tate -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Lorna Craig Sent: 21 April 2014 16:27 To: [email protected] Subject: Re: [FHU] Phantom deaths. How to prevent/remove? Thanks Mike. The last filter in your list doesn't seem to work, but I don't think it is needed. I don't think it is possible to create a blank custom sentence (if you try, it reverts to the default sentence). I am also a bit confused about the second and third lines in the list below. How would it be possible to have a Note or Multimedia attached to a Source citation when you have already excluded all facts with Source citations? However, these refinements go well beyond what is needed to find most instances of 'empty' facts, so I am hapy with the query as it stands. Thanks again Lorna On 21/04/2014 15:34, Beryl & Mike Tate wrote: > Lorna, > You are correct, but to be pedantic there are several other cases that need to be covered too. > =IsTrue(%FACT.SOUR% = "") for Source Citation and most associated fields > =IsTrue(%FACT.SOUR2% = "") for Note attached to Citation > =IsTrue(%FACT.OBJE% = "") for Multimedia attached to Citation > =IsTrue(%FACT.TYPE% = "") for Fact Descriptor > =IsTrue(%FACT.PHON% = "") for Fact Phone No > =IsTrue(%FACT._EMAIL % = "") for Fact E-mail Addr > =IsTrue(%FACT._WEB% = "") for Fact Website > =IsTrue(%FACT.AGNC% = "") for Fact Responsible Agency > =IsTrue(%FACT.OBJE2% = "") for Fact Local Multimedia > =IsTrue(%FACT.NOTE% = "") for Fact linked Note Record > =IsTrue(%FACT.SENT% = "") for Fact custom Sentence > > I have added all these to the KB posting. > ------------------------------- To unsubscribe from the list, please send an email to [email protected].com with the word 'unsubscribe' without the quotes in the subject and the body of the message