Admin doesn't list users shows only displayName

Sep 25, 2009 at 9:22 PM
Edited Sep 25, 2009 at 9:22 PM

I am running Microsoft Visual Studio 2008 Team System Web Access SP1

I have Timesheet 4.01 installed.  Everything seems to work except for the ability to approve timesheets...  When i click the admin button i get a yellow rectangle with the word displayName in it.

Any suggestions?

Oct 8, 2009 at 3:52 PM

We are having the same problem here.

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.