V4.1.3 Query - request for help
Posted: 25 May 2013 18:30
Hello,
Ive tried creating a query (on version 4.1.3) to include all the following columns :-
Report Column Expression
Individuals Name (Surname, First) %INDI.NAME[1]:SURNAME_FIRST%
Birth Date %INDI.BIRT[1].DATE:COMPACT%
Birth Place %INDI.BIRT[1].PLAC:FULL%
Baptism Date %INDI.BAPM[1].DATE:COMPACT%
Baptism Place %INDI.BAPM[1].PLAC:FULL%
Marriage 1 Date %INDI.FAMS[1]>MARR[1].DATE%
Marriage 1 Place %INDI.~SPOU[1]>FAMS[1]>MARR[1].PLAC%
Spouse 1 Name %INDI.~SPOU[1]>NAME[1]:SURNAME_FIRST%
Marriage 2 Date %INDI.FAMS[2]>MARR[1].DATE%
Marriage 2 Place %INDI.~SPOU[2]>FAMS[1]>MARR[1].PLAC%
Spouse 2 Name %INDI.~SPOU[2]>NAME[1]:SURNAME_FIRST%
Marriage 3 Date %INDI.FAMS[3]>MARR[1].DATE%
Marriage 3 Place %INDI.~SPOU[3]>FAMS[1]>MARR[1].PLAC%
Spouse 3 Name %INDI.~SPOU[3]>NAME[1]:SURNAME_FIRST%
Father s Name %INDI.FAMC[1]>HUSB[1]>NAME[1]:SURNAME_FIRST%
Mothers Date %INDI.FAMC[1]>WIFE[1]>NAME[1]:SURNAME_FIRST%
Death Date %INDI.DEAT[1].DATE:COMPACT%
Death Place %INDI.DEAT[1].PLAC:FULL%
Ive added a parameter query with Place name to compile a report of people/events in a place. The filters are based on :-
Add if expression contains value
%INDI.BIRT[1].PLAC:FULL%
%INDI.BAPM[1].PLAC:FULL%
%INDI.~SPOU[1]>FAMS[1]>MARR[1].PLAC%
%INDI.~SPOU[2]>FAMS[2]>MARR[2].PLAC%
%INDI.~SPOU[3]>FAMS[3]>MARR[3].PLAC%
%INDI.DEAT[1].PLAC:FULL%
Result Set :
Some places for the 2nd / 3rd marriages are shown alongside the spouse #2 name (they occurred in the place according to my parameter query)
However I would still like the columns to list all the place names even if this occurred outside the county. How should I express this in the query ?
Appreciate any advice.
Also if the 2nd marriage occurred outside my parameter query (e.g. county of Leicester) and the spouse is technically on their 1st marriage & 2nd family (i.e. my individual has an earlier family as an unmarried mother) will this affect the filter : %INDI.~SPOU[2]>FAMS[1]>MARR[1].PLAC% ?
Thanks for any help.
ID:6960
Ive tried creating a query (on version 4.1.3) to include all the following columns :-
Report Column Expression
Individuals Name (Surname, First) %INDI.NAME[1]:SURNAME_FIRST%
Birth Date %INDI.BIRT[1].DATE:COMPACT%
Birth Place %INDI.BIRT[1].PLAC:FULL%
Baptism Date %INDI.BAPM[1].DATE:COMPACT%
Baptism Place %INDI.BAPM[1].PLAC:FULL%
Marriage 1 Date %INDI.FAMS[1]>MARR[1].DATE%
Marriage 1 Place %INDI.~SPOU[1]>FAMS[1]>MARR[1].PLAC%
Spouse 1 Name %INDI.~SPOU[1]>NAME[1]:SURNAME_FIRST%
Marriage 2 Date %INDI.FAMS[2]>MARR[1].DATE%
Marriage 2 Place %INDI.~SPOU[2]>FAMS[1]>MARR[1].PLAC%
Spouse 2 Name %INDI.~SPOU[2]>NAME[1]:SURNAME_FIRST%
Marriage 3 Date %INDI.FAMS[3]>MARR[1].DATE%
Marriage 3 Place %INDI.~SPOU[3]>FAMS[1]>MARR[1].PLAC%
Spouse 3 Name %INDI.~SPOU[3]>NAME[1]:SURNAME_FIRST%
Father s Name %INDI.FAMC[1]>HUSB[1]>NAME[1]:SURNAME_FIRST%
Mothers Date %INDI.FAMC[1]>WIFE[1]>NAME[1]:SURNAME_FIRST%
Death Date %INDI.DEAT[1].DATE:COMPACT%
Death Place %INDI.DEAT[1].PLAC:FULL%
Ive added a parameter query with Place name to compile a report of people/events in a place. The filters are based on :-
Add if expression contains value
%INDI.BIRT[1].PLAC:FULL%
%INDI.BAPM[1].PLAC:FULL%
%INDI.~SPOU[1]>FAMS[1]>MARR[1].PLAC%
%INDI.~SPOU[2]>FAMS[2]>MARR[2].PLAC%
%INDI.~SPOU[3]>FAMS[3]>MARR[3].PLAC%
%INDI.DEAT[1].PLAC:FULL%
Result Set :
Some places for the 2nd / 3rd marriages are shown alongside the spouse #2 name (they occurred in the place according to my parameter query)
However I would still like the columns to list all the place names even if this occurred outside the county. How should I express this in the query ?
Appreciate any advice.
Also if the 2nd marriage occurred outside my parameter query (e.g. county of Leicester) and the spouse is technically on their 1st marriage & 2nd family (i.e. my individual has an earlier family as an unmarried mother) will this affect the filter : %INDI.~SPOU[2]>FAMS[1]>MARR[1].PLAC% ?
Thanks for any help.
ID:6960