* Burial Place and Death date

[Darryl-W]

If I have a individual with a known death date but the burial place is missing. How can I construct a query to identify those individuals.

[tatewise]

Your previous postings have been about creating custom Queries, so I guess you are comfortable with the general process.

A few more clues would help, so I have assumed the Individual records will have at most a single Death Event with a Date and at most a single Burial Event without a Place field.

Because you need to check two facts, this will need an Individual type of Query, as a Fact type of Query will be trickier.
However, it relies on there being only one Death and one Burial event.

The Rows tab filters will be along the lines of:
Exclude if %INDI.DEAT[1].DATE% is null = keep those with a Death Date
Exclude unless %INDI.BURI[1].PLAC>% is null = keep those with no Burial event or no Burial Place
The Condition is the opposite of what you might expect because there is no Operator for 'is not null'.

If you need to ignore those with no Burial Event at all, then add the following filter (the order of the filters is irrelevant):
Exclude if %INDI.BURI[1]% is null

[Darryl-W]

Mike Tate.. You are right-0 comfortable with the query process and i DID try but I get frustrated in the LOGIC -
When you detail the query is IS logic (then) -- so how do I learn the process- because I want to be able to write my own queries and not bother others - but I sincerely thank you for your help but it's like the "Give a man or fish - or teach him how to fish" As I see it
Darryl W

[tatewise]

Checkout how_to:creating_a_query|> Creating a Query that explains the tabs and the types of Query.
Among other things that explains the how_to:creating_a_query:rows_tab#query_window_rows_tab|> Query Window ~ Rows Tab and how the filters act like sieves.

Taking the recent example, the first filter is Exclude if %INDI.DEAT[1].DATE% is null
So the Result Set will initially include all Individual records, but after the filter will only keep those with a Death Date.

The next filter Exclude unless %INDI.BURI[1].PLAC>% is null will only keep those records without a Burial Place.

But if a later filter uses either Add if or Add unless then previous records that had been excluded may get added.
So the order of the filters may be critically important, but the Exclude filters can usually be in any order.