Page 1 of 1

Custom Query to find Census records

Posted: 07 Jul 2021 14:56
by peterbel
Some guidance please.
I want to be able to find:
All Individuals that have as one of their Facts, a Census Record with Media (an Image of the original record) but without Text from Source. I want to add the missing Text.

I have dug around the various parts of Individual>Events>Census, but not been able to get what I want.
I have also checked the Plug In list but couldn't see one that would suit.

Thanks

Re: Custom Query to find Census records

Posted: 07 Jul 2021 15:14
by tatewise
I suspect you are using an Individual Query which makes it difficult to find all instances of Census events.

So, I suggest you start with a Knowledge Base Download of All Facts Filter by Label.
That will list any type of fact via a user prompt, but you can modify it to specifically list only Census events.
You can also delete many of the Column data fields not required.

The following guidance assumes that each Census event has the Census Source Citation as the 1st Citation.

On the Columns tab, the Fields on the left allow Source> links to be expanded for (Data) > Text From Source and also for (Media Record>) that will produce the following data refs:
%FACT.SOUR[1].DATA.TEXT[1]%
%FACT.SOUR[1].OBJE[1]>%

On the Rows tab you can then test for lack of Text From Source followed by the existence of Media.
i.e.
Add if %FACT.SOUR[1].DATA.TEXT[1]% is null
Exclude if %FACT.SOUR[1].OBJE[1]>% is null

Re: Custom Query to find Census records

Posted: 07 Jul 2021 17:07
by peterbel
Thanks Mike, now working through the results.