assigning to the right user
Grant
|
dig
· 1 |
|
| Monday, March 6, 2006, 2:28:22 PM | |
0
|
Hi Grant, There is no way to do this out of the box. What you can do is:
Hope this helps. |
||||
|
|||||
0
|
Are you talking about using VS.net and modify the ASPX page? I do not see any settings to default the assign to user name and lock it. |
||||
|
|||||
0
|
Apologies for the earlier email. You can only hide it by changing the ASPX page. You pre select a resource by changing the geminigetlut1 stored procedure: This: …. /* project resources (active only) / select 0 as userid,N'<Nobody>' as username, 0 as tstamp union all select a.userid, b.firstname + N' ' + b.surname as username, a.tstamp from projectresource a, users b where a.projid=@projid and b.userid=a.userid and a.isactive = 'y' --order by b.username order by username …. Can be changed to: / project resources (active only) */ select 2 as userid,N'Manager Name' as username, 0 as tstamp,N'' as userorder union all select a.userid, b.firstname + N' ' + b.surname as username, a.tstamp, b.firstname + N' ' + b.surname as userorder from projectresource a, users b where a.projid=@projid and b.userid=a.userid and a.isactive = 'y' --order by b.username order by userorder where 2 is the actual user id of the ‘Manager Name’ user. |
||||
|
|||||
0
|
Perfect, thanks a ton.... |
||||
|
|||||
0
|
I added a field in Projectresource called manager and datatype is bit. I set all manager to one so that when the user create a new issue, it will only load the user name with manager = 1. The manager then can reassign it to the programmers. Lucky, when new issue is created it uses SP gemingetlut1 and when the issue is being edit, this SP is not called. SP “geminigetlut1” Change fromselect 0 as userid,N'<Nobody>' as username, 0 as tstamp union all select a.userid, b.firstname + N' ' + b.surname as username, a.tstamp from projectresource a, users b where a.projid=@projid and b.userid=a.userid and a.isactive = 'y' --order by b.username order by username to select a.userid, b.firstname + N' ' + b.surname as username, a.tstamp from projectresource a, users b where a.projid=@projid and b.userid=a.userid and a.isactive = 'y' and a.manager = 1 --order by b.username order by username
|
||||
|
|||||




