OOo2.0.3 database + writer ( Mailing)
in mailing, using a Request with (join) I tried to use conditioned paragraphe.
The behavior was not the expected one. only one paragraph was displayed, 
always the same for any value of the field used for the condition.

I created a View with exactly the same sql source, it works perfectly
following the SQL, the field used is:
 "T_adherent"."civilite" AS "civiliteAdherent",   
it can have 3 values (0,1,2)

Thanks for your help. Claudine

SELECT 
"T_parrainage"."ID" AS "IDParrainage", 
"T_parrainage"."filleul",
"T_parrainage"."parrain",
"T_parrainage"."dateDebut",
"T_parrainage"."dateFin",
"T_parrainage"."etat" AS "etatParrainage",
"Tp_etatParrainage"."libelle"  AS "etatParrainageLib", 
"T_eleve"."ID" AS "IDEleve", 
"T_eleve"."nom" AS "nomEleve", 
"T_eleve"."prenom" AS "prenomEleve", 
"T_eleve"."datenaissance" AS "dateNaissEleve",
 "T_eleve"."adresseFamille1", 
"T_eleve"."adresseFamille2", 
"T_eleve"."sexe" AS "sexeEleve", 
"T_eleve"."nomPere",
 "T_eleve"."prenomPere", 
"T_eleve"."dateEntree6",
 "T_eleve"."note", 
"T_eleve"."villeFamille", 
"T_eleve"."paysFamille",
 "T_eleve"."adr1Hebergement", 
"T_eleve"."adr2Hebergement", 
"T_eleve"."villeHebergement", 
"T_eleve"."paysHebergement", 
"T_eleve"."prenomHebergement", 
"T_eleve"."nomHebergement", 
"T_eleve"."responsable", 
"T_eleve"."nomResponsable", 
"T_eleve"."prenomResponsable", 
"T_eleve"."civiliteResponsable", 
"T_eleve"."civiliteHeberg",
 "T_eleve"."paranteHebergement" AS "parenteHebergement",
 "Tp_parenteHebergeur"."libelle", 
"T_adherent"."ID"  AS "IDAdherent", 
"T_adherent"."nom" AS "nomAdherent", 
"T_adherent"."prenom" AS "prenomAdherent", 
"T_adherent"."adresse1" AS "adr1Adherent", 
"T_adherent"."adresse2" AS "adr2Adherent", 
"T_adherent"."codePostal" AS "codePostalAdherent", 
"T_adherent"."ville" AS "villeAdherent", 
"T_adherent"."pays" AS "paysAdherent", 
 "T_adherent"."telephone" AS "telephoneAdherent", 
"T_adherent"."mail"  AS "mailAdherent", 
"T_adherent"."fax"  AS "faxAdherent",
 "T_adherent"."participeEcole",
 "T_adherent"."participeCollege", 
"T_adherent"."personne" AS "persPhyMoAdh", 
"T_adherent"."courrierPrefere", 
"T_adherent"."envoiRecuMail", 
"T_adherent"."civilite" AS "civiliteAdherent", 
"T_adherent"."telephone2", 
"Tp_civilite"."libelle" AS "civiliteLib", 
"Tp_modeCommunication"."libelle" AS "modeComLib", 
"T_ecole"."ID" AS "IDEcole",
"T_ecole"."adr1" AS "adr1Ecole",
"T_ecole"."adr2" AS "adr2Ecole",
"T_ecole"."codePostal" AS "codePostalEcole",
"T_ecole"."ville" AS "villeEcole",
"T_ecole"."pays" AS "paysEcole",
"T_ecole"."nom" AS "nomEcole",
"T_ecole"."type" AS "typeEcole",
"Tp_typeEcole"."libelle" AS "typeEcoleLib", 
"Tp_sexe"."libelle" AS "sexeEleveLib", 
"Tp_responsable"."libelle" AS "responsableEleveLib", 
"Tp_personne"."libelle" AS "personneAdherLib"

 FROM "T_parrainage" "T_parrainage"
      JOIN "T_eleve" "T_eleve"
                  ON  "T_parrainage"."filleul" = "T_eleve"."ID" 
                          LEFT OUTER JOIN   "T_scolarite" "T_scolarite"
                                    ON  "T_eleve"."ID" 
= "T_scolarite"."filleul" 
                                              LEFT OUTER 
JOIN    "T_ecole" "T_ecole"
                                                    ON  "T_scolarite"."ecole" 
= "T_ecole"."ID" 
                                                            LEFT OUTER 
JOIN    "Tp_typeEcole" "Tp_typeEcole"
                                                                     
ON  "T_ecole"."type" = "Tp_typeEcole"."code"
                           LEFT OUTER 
JOIN   "Tp_parenteHebergeur" "Tp_parenteHebergeur"
                                    ON  "T_eleve"."paranteHebergement" 
= "Tp_parenteHebergeur"."code" 
                           LEFT OUTER JOIN   "Tp_sexe" "Tp_sexe"
                                    ON  "T_eleve"."sexe" = "Tp_sexe"."code" 
                           LEFT OUTER JOIN   "Tp_responsable" "Tp_responsable" 
                                    ON "T_eleve"."responsable" 
= "Tp_responsable"."code" 
      JOIN "T_adherent" "T_adherent"
                 ON "T_parrainage"."parrain" = "T_adherent"."ID"
                            LEFT OUTER JOIN   "Tp_civilite" "Tp_civilite"
                                   ON "T_adherent"."civilite" 
= "Tp_civilite"."code" 
                             LEFT OUTER 
JOIN   "Tp_modeCommunication" "Tp_modeCommunication"
                                   ON "T_adherent"."courrierPrefere" 
= "Tp_modeCommunication"."code"
                             LEFT OUTER JOIN   "Tp_personne" "Tp_personne"
                                   ON  "T_adherent"."personne" 
= "Tp_personne"."code" 
      LEFT OUTER JOIN  "Tp_etatParrainage" "Tp_etatParrainage"
                 ON "T_parrainage"."etat" = "Tp_etatParrainage"."code" 
WHERE (("T_parrainage"."dateFin" >= NOW()) AND ("T_parrainage"."etat"=0) )