0

Please login or register to vote for this query.

(click on this box to dismiss)

Summary of the number of questions closed by the close reason type.

Q&A for Tridion developers and administrators

SELECT
    year( CreationDate ) as year,
    month( CreationDate ) as month,
    datepart( weekday, CreationDate ) as weekday,
    'All' AS 'Close Reason',
    '' AS CloseReasonId,
    SUM(1) AS Count
    FROM Posts 
    GROUP BY 
    year( CreationDate ) ,
    month( CreationDate ) ,
    datepart( weekday, CreationDate )

fork query

edited aug 24 12 anonymous

created jan 9 11 Jon Seigel