SQL Error about agiledwarf

[markablov]

Redmine version?
Mysql version?
Thanks.

[chesterman]

Ops, sorry for the lack of info.

Redmine 1.4.4
PostgreSQL 9.1.4

[chesterman]

I fixed the SQL... kind of. There were just a few things that make it incompatible with PostgreSQL.
The problem is that the outer query does a group by in 3 of the 4 fields, so the remaing field MUST be in a aggregation function, like max(). I used SUM() in the example, but i dont know what the sql is supposed to return, so i ask you to alter:

select 
    sum(COALESCE(old_value::float,0)) as value,
    journalized_id as issueID,
    prop_key,
    DATE(journals.created_on) AS created_on 
from 
    journals
inner join
    journal_details on (journals.id = journal_id)
inner join
    issues on (issues.id = journalized_id)
where
    journalized_type = 'Issue' 
    and
    property = 'attr'
    and
    (prop_key = 'estimated_hours' or prop_key = 'done_ratio')
    and #{restcondchanges}
group by
    2, 3, 4
order by
    created_on desc

[markablov]

Main idea of grouping in same way is to recieve last day value;
For example if we edit same parameter of same issue several times of day, we need to count latest change.
That's why in inner query we should order by id to recieve actual value.

[kWhittington]

Thank you so much for the post @chesterman!

Replacing the queries with your's solved my error of the Run Charts tab crashing.
However, judging by the other issues, I might not be able to really play with the plugin much. :(