Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




assigning to the right user

web-app
Any issue that needs to be created is usually created by the tech support team. They get calls from our users and they may have a wish lists or a problem that the programmers will need to address. They are supposed to assign it to a manager then manager approves it and in turn assign it to the programmer. Sometime they will assign it straight to the programmer which the manger does not like. Is there a way for me to setup to lock it so that they can only assign it to the manager then the manager can reassign it to the programmer?

Grant

dig
· 1
dig
Replies (5)
helpful
0
not helpful

Hi Grant,

There is no way to do this out of the box.

What you can do is:

  • Hide the "Assigned To" box in the CreateIssue.aspx and set it to default to a specific user.
  • Create your own "Create Issue" page that will use web services to actually create the issue.

Hope this helps.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

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.


dig
· 1
dig
helpful
0
not helpful

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.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Perfect, thanks a ton....


dig
· 1
dig
helpful
0
not helpful

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 from
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

 

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

 



dig
· 1
dig