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.




Custom Fields needed

web-app

I would like to create two custom fields One QA and one Developer. I want this to contain the same data from the DB as assigned to (resources) has for it's dropdown selection values.

I can't figure out how to do this. I got all 4 tables hooked together but I can't for the life of me find where the "Assignable To Issues" is being stored for the schema for the particular roles.

Could you please post the query that is being used for the Assign To field in the issue edit screen.

Thanks, Angela Law
angelalaw
· 1 		angelalaw
Wednesday, June 16, 2010, 4:32:24 PM
Replies (2)
helpful
0
not helpful

This should work (change project id):

SELECT usr.firstname + ' ' + usr.surname  FROM geminiusers usr JOIN (
SELECT DISTINCT
    CASE WHEN gm.userid IS NOT NULL THEN gm.userid
    ELSE
        CASE WHEN pm.userid IS NOT NULL THEN pm.userid
        ELSE
            u.userid
        END
    END AS userid
FROM geminiprojects p JOIN geminiglobalsecurityschemeroles s ON p.globalschemeid = s.schemeid AND s.schemerole=14
LEFT JOIN geminiglobalgroupmembership gm on s.membertype = 2 AND s.memberid = gm.globalgroupid
LEFT JOIN geminiprojectgroupmembership pm on s.membertype = 3 AND s.memberid = pm.projectgroupid
LEFT JOIN geminiusers u on s.membertype = 1 AND s.memberid = u.userid
WHERE p.projectid = 19
) assignables ON usr.userid = assignables.userid
Mark Wing
· 9108 		Mark Wing
Wednesday, June 16, 2010, 5:01:54 PM
helpful
0
not helpful

Great thanks that worked :)
angelalaw
· 1 		angelalaw
Wednesday, June 16, 2010, 7:25:54 PM