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.




History table in the DB

web-app

The history table has the Username in it and not the userID, it seems to be a concat on Fname and Sname. so to find out the history of a ticket to i need to hope the users fname and sname dont change and do a concat or is there a userid hidden in another table?

Overall i want to findout who did the last update to a ticket be this a comment or a status change so i was trying to join onto the history table, user table and issue table. is this the only way or is there a better way?
james123
· 1 		james123
Tuesday, August 3, 2010, 12:11:36 PM
Replies (4)
helpful
0
not helpful

Best way is to listen to the issue updated event in a simple custom plugin.

Use the Twitter plugin as a guide.

http://www.countersoft.com/downloads/v37/CounterSoftGeminiPlugins.zip
Harvey Kandola
· 212 		Harvey Kandola
Tuesday, August 3, 2010, 1:01:50 PM
helpful
0
not helpful

yep i could but i am running a reporting services report off the back of it so need it at DB level. May be a nice change anyway as the rest of the tables use userid.

Will do a join on the username for now!
james123
· 1 		james123
Tuesday, August 3, 2010, 5:28:16 PM
helpful
0
not helpful

Got it.

We can certainly add it but USERID will not be a Foreign Key (because Users get deleted but History must always remain inact!).
Harvey Kandola
· 212 		Harvey Kandola
Tuesday, August 3, 2010, 6:11:15 PM
helpful
0
not helpful

sounds good to me :)
james123
· 1 		james123
Tuesday, August 3, 2010, 11:46:59 PM