JIRA: Select Estimate and Actually Spent (Logged) Hours

Categories: Development Notes; Tagged with: ; @ May 9th, 2013 21:24

SELECT TOP 20
    CAST((ji.TIMESPENT – TIMEORIGINALESTIMATE)/3600  AS DECIMAL (6, 2)) AS [Diff(H)] ,
    CAST (ji.TIMEORIGINALESTIMATE/3600 AS DECIMAL (6,2)) AS [TIMEORIGINALESTIMATE(H)],
    CAST(ji.TIMESPENT/3600  AS DECIMAL (6, 2)) AS [TIMESPENT(H)],
    Project.pname AS [ProjectName],
    *
FROM jiraschema.jiraissue ji 
    LEFT JOIN jiraschema.project Project on ji.PROJECT = PROJECT.ID
ORDER BY (ji.TIMESPENT – TIMEORIGINALESTIMATE) desc

<->



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.