PTB administration des élections — PVDA administratie verkiezingen

Roos Eligius, 02 5040 145 (privé 056 71 94 87, 0487 16 94 74)administrationelections@ptb.be

Dominique Meeùs, 02 5040 155 (privé 0473 61 31 75)alias administratieverkiezingen@pvda.be

Dernière modification le


Annexe 4, code de la vue perso-view

SELECT 
  "perso"."ID" AS "ID", 
  "perso"."prenombul" AS "prenombul",
  "perso"."nombul" AS "nombul",
  "perso"."provparti" AS "provparti",
  "perso"."prenoms" AS "prenoms",
  "perso"."nom" AS "nom",
  CASE
    WHEN "perso"."masculin"
    THEN 'M'
    ELSE 'F'
  END AS "sexe",
  "perso"."paysnat" AS "paysnat",
  "perso"."numnat" AS "RRN",
  "perso"."datenaiss" AS "datenaiss",
  "perso"."profession" AS "profession",
  "perso"."ruedomi" + ' ' + "perso"."numdomi"
    + CASE
        WHEN "perso"."btedomi" IS NULL
        THEN ''
        ELSE ' bus ' + "perso"."btedomi"
      END AS "adresse",
  "perso"."cpdomi" AS "cp",
  "perso"."commdomi" AS "commune",
  "perso"."email" AS "e-mail",
  "perso"."phone" AS "phone",
  "perso"."gsm" AS "gsm",
  "perso"."profil" AS "profil",
  "perso"."professionalt" AS "professionalt",
  CASE
    WHEN "perso"."plus"
    THEN '+'
    ELSE ''
  END AS "plus"
FROM "perso" 
ORDER BY "perso"."prenombul"
  

Retour en haut de la page