To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69495
Issue #|69495
Summary|OOo2.0.3 Request + conditionned paragraph in mailing
Component|Database access
Version|OOo 2.0.3
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|claudinedec
------- Additional comments from [EMAIL PROTECTED] Wed Sep 13 00:29:54 -0700
2006 -------
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) )
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
