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.




How can I link issue and assigned worker?

web-app

 In 2.0.5 I was able to run this query and get a name of the user assigned to work on any given issue.


select userid, firstname + ' ' + surname as full_name

from users, issues

where users.userid = issues.assignedto

and issues.projid = 1

group by userid, firstname + ' ' + surname

In version 2.22 I cannot find assignedto filed in the issues table any longer.
Can you please provide an example how to link User working on the Issue and issue itself?

This change broke all of reports we created for management in v2.0.5

Thanks
-Boris
bskylar
· 1 		bskylar
Friday, October 12, 2007, 11:56:46 PM
Replies (3)
helpful
0
not helpful

You need to look at the issueresource table. This is because you can now assign multiple ressources to an issue.
Saar Cohen
· 5000 		Saar Cohen
Saturday, October 13, 2007, 12:02:36 AM
helpful
0
not helpful

Thank you for your response! I cannot seem to find the issueresource table in the Gemini DB. Did you mean projectresource table? It does exist and here is a query to pull all assigned to the project users. Still, how does Gemini link a record from this table to issues table?

 

select r.userid, a.firstname + N' ' + a.surname as full_name

from users a, projectresource r where r.userid=a.userid and r.projid =1

group by r.userid, a.firstname + N' ' + a.surname

order by 2
bskylar
· 1 		bskylar
Saturday, October 13, 2007, 12:09:16 AM
helpful
0
not helpful

After I responded to your email, I went back to SQL mgmt Studio and refreshed the tables list. The issueresource table showed up! Thank you and sorry for a confusion!!!

-Boris
bskylar
· 1 		bskylar
Saturday, October 13, 2007, 12:28:57 AM