#6 closed defect (fixed)
pb with {6} All Tickets By Milestone (Including closed)
Reported by: | pinsard | Owned by: | Olivier Thauvin |
---|---|---|---|
Priority: | critical | Milestone: | SAXO on trac |
Component: | component1 | Version: | |
Keywords: | Cc: |
Description (last modified by pinsard)
pb soumis à Olivier
voici la copie de la fenêtre aprÚs avoir sélectionner {6} All Tickets By Milestone (Including closed)
A more complex example to show how to make advanced reports.
Report execution failed: ERREUR: la colonne ?modified? n'existe pas SELECT p.value AS __color__, t.milestone AS __group__, (CASE status WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;' ELSE (CASE owner WHEN 'pinsard' THEN 'font-weight: bold' END) END) AS __style__, id AS ticket, summary, component, status, resolution,version, t.type AS type, priority, owner, changetime AS modified, time AS _time,reporter AS _reporter FROM ticket t,enum p WHERE p.name=t.priority AND p.type='priority' ORDER BY (milestone IS NULL), milestone DESC, (status > 'closed'), (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END) 'closed'), (CASE status WHEN 'closed' THEN changelogtime ELSE (-1)*p.value::int END) DESC
réponse d'Olivier
Oui, je l'ai corrigé pour Docipsl celle là , en gros c'est une syntaxe SQL
accepté par SQLite je pense mais par postgres, elle est facile à corriger
pour peu qu'on connaisse le SQL:
- renommer un colonne dans la requete,
- ajouter un cast explicite text => int
J'ai mis la ligne corrigé au dessus pour info.
J'ai corrigé pour saxo grace à mes super pouvoir d'admin postgres :)
Change History (2)
comment:1 Changed 18 years ago by pinsard
- Resolution set to fixed
- Status changed from new to closed
comment:2 Changed 17 years ago by pinsard
- Description modified (diff)
Note: See
TracTickets for help on using
tickets.