Hi Folks. Using TRAC 0.11, I am trying to run the following query :
SELECT
id AS ticket,
summary,
priority,
severity,
status,
type as __group__,
owner,
date(time,"unixepoch") as 'Created',
date(changetime,"unixepoch") as 'Modified',
reporter,
(case when c.value is NULL then '' else c.value end) as 'estimate',
(case when c3.value is NULL then '' else c3.value end) as 'actual',
(case when c1.value is NULL then '' when c1.value = '<click to set
date>'
then '' else c1.value end) as 'date desired',
(case when c2.value is NULL then '' when c2.value = '<click to set
date>'
then '' else c2.value end) as 'date due'
FROM ticket t
LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name =
'estimate_hours')
LEFT OUTER JOIN ticket_custom c1 ON (t.id = c1.ticket AND c1.name =
'date_desired')
LEFT OUTER JOIN ticket_custom c2 ON (t.id = c2.ticket AND c2.name =
'date_due')
LEFT OUTER JOIN ticket_custom c3 ON (t.id = c3.ticket AND c3.name =
'actual_hours')
WHERE
owner = '$USER' and
c2.value is not NULL and
c2.value != '<click to set date>' and
strftime("%s",substr(c2.value,7,4) || "-" || substr(c2.value,1,2)
||
"-" || substr(c2.value,4,2)) < strftime('%s','now') and
t.status != 'closed' and
t.status != 'completed' and
type not in ( 'Collaboration Ticket', 'Information Request' )
ORDER BY lower(type),t.changetime desc
When doing so, I get :
Report execution failed: not enough arguments for format string
I can use '$USER' successfully in simpler queries ( select * from
tickets where owner='$USER' ), but not in more complex ones. Any
suggestions?
Dan Winslow
Director of Information Technology, AIM INSTITUTE
1905 Harney Street, Suite 700
Omaha, NE 68102
402-345-5025 x156
[email protected]
www.aiminstitute.org
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
