-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
>>>>> "Jen" == Jen <[EMAIL PROTECTED]> writes:
Jen> field, so we ignore the status field. We would like a report
Jen> or custom query that includes the workflow_state field from the
Jen> ticket_custom table. I've tried numerous SQL commands to
Custom fields are stored in another table.
Here is my query that returns a custom field "id_effort"
SELECT p.value AS __color__,
milestone||' Release' AS __group__,
(CASE status
WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
ELSE
(CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
END) AS __style__,
id AS ticket, summary, c.value AS id_effort, component, t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t, ticket_custom c
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE milestone="iteration4"
AND t.id = c.ticket AND c.name = 'id_effort'
ORDER BY (milestone IS NULL),milestone, p.value, t.type, time
- --
] Bear: "Me, I'm just the shape of a bear." | firewalls [
] Michael Richardson, Xelerance Corporation, Ottawa, ON |net architect[
] [EMAIL PROTECTED] http://www.sandelman.ottawa.on.ca/mcr/ |device driver[
] panic("Just another Debian GNU/Linux using, kernel hacking, security guy"); [
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Finger me for keys
iQEVAwUBRqYUN4CLcPvd0N1lAQKIvwf+MZogFcIFJofP1gqygMukHjTiOfa+Zdpx
wwJ1nqsuGd5qWwjKAOY3OXBxy3Yil4zB1cCvuT5qeW+m/jxqrKmga9VNi+8j7Xat
LCW1Pe0gve2ERlKXtY3xOFZktG1suHAb2wzgrGDyYQwdI8Qhnx2dMRJsV7vdQ7Pl
8MxQsCJbEj+nE5lRL5xBUl5XygTNBM++44SKO47sZBXiA+1RkvjD9CCTnqUXbWR5
e9si51KA/aZimMAyZ22SzOjspYkHwTDJTWlWLa38MhGTHFyRBtlhJFykl92vcrQT
c6o4oxuRzwo5kKxxJi7qEqDsRB4yD9VzbhLPk/X476H3QJk2q9XmeA==
=mhfP
-----END PGP SIGNATURE-----
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
