Vous pouvez par exemple utiliser le Boa. Dans la rubrique de ce Boa parmi nos chers messages disparus, ces quelques requêtes SQL qui permettent d’effectuer ces classements.
Le dossier par défaut est égal à 1
Le classement s’effectue par ordre alphabétique des patronymes et des lieux
Il suffit d’indiquer le numéro de votre dossier et de faire un copier coller de la requête et ensuite de consulter à loisir.
Individu décè manquant
SELECT I.CLE_FICHE AS NIP, I.NOM, I.PRENOM, R.REF_EVE_LIB_LONG AS EVENEMENT, E.EV_IND_DATE_WRITEN AS DATE_EVENEMENT, E.EV_IND_VILLE AS VILLE
FROM INDIVIDU I, EVENEMENTS_IND E, REF_EVENEMENTS R
WHERE I.KLE_DOSSIER = 1
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_TYPE = 'DEAT'
AND (E.EV_IND_ACTE = 0 OR E.EV_IND_ACTE IS NULL)
AND R.REF_EVE_LIB_COURT = E.EV_IND_TYPE
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NOM, I.PRENOM, I.CLE_FICHE
Individu décè trouvé
SELECT I.CLE_FICHE AS NIP, I.NOM, I.PRENOM, R.REF_EVE_LIB_LONG AS EVENEMENT, E.EV_IND_DATE_WRITEN AS DATE_EVENEMENT, E.EV_IND_VILLE AS VILLE
FROM INDIVIDU I, EVENEMENTS_IND E, REF_EVENEMENTS R
WHERE I.KLE_DOSSIER = 1
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_TYPE = 'DEAT'
AND EV_IND_ACTE = 1
AND R.REF_EVE_LIB_COURT = E.EV_IND_TYPE
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NOM, I.PRENOM, I.CLE_FICHE
Individus mariage manquant
SELECT I.NOM, I.PRENOM, I1.NOM AS NOM_CJT, I1.PRENOM AS PRENOM_CJT,
E.EV_FAM_DATE_WRITEN AS DATES, E.EV_FAM_VILLE AS LIEU
FROM T_UNION T, INDIVIDU I, INDIVIDU I1, EVENEMENTS_FAM E
WHERE T.KLE_DOSSIER = 1
AND I.CLE_FICHE = T.UNION_MARI
AND I.KLE_DOSSIER = T.KLE_DOSSIER
AND I1.CLE_FICHE = T.UNION_FEMME
AND I1.KLE_DOSSIER = T.KLE_DOSSIER
AND E.EV_FAM_KLE_FAMILLE = T.UNION_CLEF
AND E.EV_FAM_TYPE = 'MARR'
AND (E.EV_FAM_ACTE = 0 OR E.EV_FAM_ACTE IS NULL)
ORDER BY E.EV_FAM_VILLE, E.EV_FAM_DATE, I.NOM, I.PRENOM, I1.NOM, I1.PRENOM
Individus mariage trouvé
SELECT I.NOM, I.PRENOM, I1.NOM AS NOM_CJT, I1.PRENOM AS PRENOM_CJT,
E.EV_FAM_DATE_WRITEN AS DATES, E.EV_FAM_VILLE AS LIEU
FROM T_UNION T, INDIVIDU I, INDIVIDU I1, EVENEMENTS_FAM E
WHERE T.KLE_DOSSIER = 1
AND I.CLE_FICHE = T.UNION_MARI
AND I.KLE_DOSSIER = T.KLE_DOSSIER
AND I1.CLE_FICHE = T.UNION_FEMME
AND I1.KLE_DOSSIER = T.KLE_DOSSIER
AND E.EV_FAM_KLE_FAMILLE = T.UNION_CLEF
AND E.EV_FAM_TYPE = 'MARR'
AND E.EV_FAM_ACTE = 1
ORDER BY E.EV_FAM_VILLE, E.EV_FAM_DATE, I.NOM, I.PRENOM, I1.NOM, I1.PRENOM
Individus naissance manquant
SELECT I.CLE_FICHE AS NIP, I.NOM, I.PRENOM, R.REF_EVE_LIB_LONG AS EVENEMENT, E.EV_IND_DATE_WRITEN AS DATE_EVENEMENT, E.EV_IND_VILLE AS VILLE
FROM INDIVIDU I, EVENEMENTS_IND E, REF_EVENEMENTS R
WHERE I.KLE_DOSSIER = 1
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_TYPE = 'BIRT'
AND (E.EV_IND_ACTE = 0 OR E.EV_IND_ACTE IS NULL)
AND R.REF_EVE_LIB_COURT = E.EV_IND_TYPE
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NOM, I.PRENOM, I.CLE_FICHE
Individu naissance trouvé
SELECT I.CLE_FICHE AS NIP, I.NOM, I.PRENOM, R.REF_EVE_LIB_LONG AS EVENEMENT, E.EV_IND_DATE_WRITEN AS DATE_EVENEMENT, E.EV_IND_VILLE AS VILLE
FROM INDIVIDU I, EVENEMENTS_IND E, REF_EVENEMENTS R
WHERE I.KLE_DOSSIER = 1
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_TYPE = 'BIRT'
AND EV_IND_ACTE = 1
AND R.REF_EVE_LIB_COURT = E.EV_IND_TYPE
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NOM, I.PRENOM, I.CLE_FICHE
Sosa décès manquant
SELECT I.NUM_SOSA as SOSA, I.NOM, I.PRENOM,
E.EV_IND_DATE_WRITEN as Dates, E.EV_IND_VILLE as Lieu
FROM INDIVIDU I, EVENEMENTS_IND E
WHERE I.KLE_DOSSIER = 1
AND I.NUM_SOSA IS NOT NULL
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_KLE_DOSSIER = I.KLE_DOSSIER
AND E.EV_IND_TYPE = 'DEAT'
AND (E.EV_IND_ACTE = 0 or E.EV_IND_ACTE IS NULL)
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NUM_SOSA
Sosa décès trouvé
SELECT I.NUM_SOSA as SOSA, I.NOM, I.PRENOM,
E.EV_IND_DATE_WRITEN as Dates, E.EV_IND_VILLE as Lieu
FROM INDIVIDU I, EVENEMENTS_IND E
WHERE I.KLE_DOSSIER = 1
AND I.NUM_SOSA IS NOT NULL
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_KLE_DOSSIER = I.KLE_DOSSIER
AND E.EV_IND_TYPE = 'DEAT'
AND EV_IND_ACTE = 1
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NUM_SOSA
Sosa mariage manquant
SELECT I.NUM_SOSA , I.NOM, I.PRENOM, I1.NUM_SOSA AS SOSA_CJT, I1.NOM AS NOM_CJT, I1.PRENOM AS PRENOM_CJT,
E.EV_FAM_DATE_WRITEN AS DATES, E.EV_FAM_VILLE AS LIEU
FROM T_UNION T, INDIVIDU I, INDIVIDU I1, EVENEMENTS_FAM E
WHERE T.KLE_DOSSIER = 1
AND I.CLE_FICHE = T.UNION_MARI
AND I.KLE_DOSSIER = T.KLE_DOSSIER
AND I.NUM_SOSA IS NOT NULL
AND I1.CLE_FICHE = T.UNION_FEMME
AND I1.KLE_DOSSIER = T.KLE_DOSSIER
AND I1.NUM_SOSA IS NOT NULL
AND E.EV_FAM_KLE_FAMILLE = T.UNION_CLEF
AND E.EV_FAM_TYPE = 'MARR'
AND (E.EV_FAM_ACTE = 0 OR E.EV_FAM_ACTE IS NULL)
ORDER BY E.EV_FAM_VILLE, E.EV_FAM_DATE, I.NOM, I.PRENOM, I.NUM_SOSA, I1.NOM, I1.PRENOM,
I1.NUM_SOSA
Sosa mariage trouvé
SELECT I.NUM_SOSA , I.NOM, I.PRENOM, I1.NUM_SOSA AS SOSA_CJT, I1.NOM AS NOM_CJT, I1.PRENOM AS PRENOM_CJT,
E.EV_FAM_DATE_WRITEN AS DATES, E.EV_FAM_VILLE AS LIEU
FROM T_UNION T, INDIVIDU I, INDIVIDU I1, EVENEMENTS_FAM E
WHERE T.KLE_DOSSIER = 1
AND I.CLE_FICHE = T.UNION_MARI
AND I.KLE_DOSSIER = T.KLE_DOSSIER
AND I.NUM_SOSA IS NOT NULL
AND I1.CLE_FICHE = T.UNION_FEMME
AND I1.KLE_DOSSIER = T.KLE_DOSSIER
AND I1.NUM_SOSA IS NOT NULL
AND E.EV_FAM_KLE_FAMILLE = T.UNION_CLEF
AND E.EV_FAM_TYPE = 'MARR'
AND E.EV_FAM_ACTE = 1
ORDER BY E.EV_FAM_VILLE, E.EV_FAM_DATE, I.NOM, I.PRENOM, I.NUM_SOSA, I1.NOM, I1.PRENOM,
I1.NUM_SOSA
Sosa naissance manquant
SELECT I.NUM_SOSA as SOSA, I.NOM, I.PRENOM,
E.EV_IND_DATE_WRITEN as Dates, E.EV_IND_VILLE as Lieu
FROM INDIVIDU I, EVENEMENTS_IND E
WHERE I.KLE_DOSSIER = 1
AND I.NUM_SOSA IS NOT NULL
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_KLE_DOSSIER = I.KLE_DOSSIER
AND E.EV_IND_TYPE = 'BIRT'
AND (E.EV_IND_ACTE = 0 or E.EV_IND_ACTE IS NULL)
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NUM_SOSA
Sosa naissance trouvé
SELECT I.NUM_SOSA as SOSA, I.NOM, I.PRENOM,
E.EV_IND_DATE_WRITEN as Dates, E.EV_IND_VILLE as Lieu
FROM INDIVIDU I, EVENEMENTS_IND E
WHERE I.KLE_DOSSIER = 1
AND I.NUM_SOSA IS NOT NULL
AND E.EV_IND_KLE_FICHE = I.CLE_FICHE
AND E.EV_IND_KLE_DOSSIER = I.KLE_DOSSIER
AND E.EV_IND_TYPE = 'BIRT'
AND EV_IND_ACTE = 1
ORDER BY E.EV_IND_VILLE, E.EV_IND_DATE, I.NUM_SOSA