Emply List of Users and Tasks in Admin.aspx

Nov 21, 2007 at 3:33 AM
When I click on the Admin icon to see the list of tasks that are completed or waiting for approval. I don't see anything except for a line which has the word "displayName" with a yellow background.

Did I miss anything?

Hoping for your inputs!

Louie
Jun 16, 2010 at 9:43 AM

There's a bug in sproc usp_RS_AwaitingApproval.

You need to change it to this:

ALTER PROCEDURE [dbo].[usp_RS_AwaitingApproval]
AS
BEGIN
    SET NOCOUNT ON

    SELECT
        dbo.TimesheetCompletions.sid,
        dbo.TimesheetCompletions.weekStarting,
        TfsWorkItemTracking.dbo.Constants.DisplayPart AS DisplayName
    FROM
        dbo.TimesheetCompletions WITH (NOLOCK)
        INNER JOIN TfsWorkItemTracking.dbo.Constants
        ON dbo.TimesheetCompletions.sid = TfsWorkItemTracking.dbo.Constants.SID
    WHERE
        (dbo.TimesheetCompletions.completed = 1)
        AND
        approved IS NULL
END

Regards.