Page 1 of 1

Query marriage

Posted: 27 May 2018 01:22
by kcuypers
Hi ,

I want to make a query where I can see all the families who has a date, place or date and place of a marriage.
I try something but it did not work. Suggestions ?

Greetings

Koenraad

Re: Query marriage

Posted: 27 May 2018 07:26
by DavidNewton
Create a custom family query with columns Family, Marriage Date, Marriage Place, Then apply two row filters
Add Unless Marriage Date is null
Add Unless Marriage Place is null

Running gives you all families with a date or a place or both.

David

Re: Query marriage

Posted: 27 May 2018 09:39
by tatewise
David's suggestion will work.
But if you want something ready made look at fhugdownloads:contents:query_all_facts_filter_by_date_label_or_text|> Query:Fact ~ All Facts Filter by Date, Label, or Text.

The All Facts Filter by Label Query lists every Marriage if you enter that Label.
It does not filter by Date or Place but I suspect very few Marriages have neither.

However, it can be easily customised to add Date and Place filters with a modified Marriage Fact filter:
Add unless %FACT.DATE% is null
Add unless %FACT.PLAC% is null
Exclude unless =FactLabel(%FACT%) matches 'Marriage'

Re: Query marriage

Posted: 30 May 2018 02:58
by kcuypers
Thanks for the advice

Greetings

Koenraad