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.




Add fields (Project Name) to My Work View

web-app

I'm trying to customize the My Work screen by adding the Project name to the menu.  I see in the database where it is tracked (table userissuesview) but I can't figure out what field corresponds with which id.  Is it possible to add fields to this list?

Thanks.
Chuck

chuck.boyer
· 1
chuck.boyer
Replies (7)
helpful
0
not helpful

You can add fields via the "Customise" link (top right) of the "My Work" page. However, the project name field can not be added only the id and code.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Seems like that would be a pretty valuable piece of information to have in the My Work page.  We manage about 30 to 60 active projects at a time, so it would be helpful to have that in the next release.  Any possibilites for that?

 

Thanks
Chuck


chuck.boyer
· 1
chuck.boyer
helpful
0
not helpful

I see, can you please add it to our list: http://gemini.countersoft.com?

 


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

If you need this sort of functionality right now you could try a work around we've implemented at our site. I doubt that this is in any way future proof and YMMV but we have a scheduled job on SQL Server to run the following script daily against our 2.0.5 installation:

UPDATE geminiuser.issues SET userdata1 = p.projname
FROM geminiuser.issues i INNER JOIN geminiuser.projects p on i.projid = p.projid

This updates the userdata1 field on each issue with the project name it belongs to. We then add the userdata1 column containing the project name into the custom view of My Work. For the particularly daring it could be modified as a trigger on the issues table and just update an individual issue.

There are three userdata fields in the issues table which can be tweaked this way. The usual "at your own risk" things apply here - I'm sure it'll probably invalidate support agreements if things are manually tweaked outside of the application and I don't know whether the Gemini folk use the user fields elsewhere in the app.

Cheers

Graeme.


davisog
· 1
davisog
helpful
0
not helpful

I see that this is still not possible in the 3.6 online beta... are you planning to include this at any point? This would really be helpful for us as well... we're at approx. 180 projects and counting, so of course nobody can remember any project codes...


duncan
· 1
duncan
helpful
0
not helpful

We will do this for 3.6.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks!


duncan
· 1
duncan