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 to display the version list per project in a custom field?

web-app

Dear Gemini users,

For each project, we have the possibility to give a list of versions. It is done in the project administration menu, in the version section. This list gives us the possibility to get the version list per project, for the fields "fixed for version" and "affected versions". 

We would like to get this same list for one of our custom field.

Could you please give us which values do we need to put in each one of these fields:

Lookup table name: Lookup key field name: Lookup description field name: Lookup sort field name:   

We already tried to take the "versions" table and to create a custom field this way:

Lookup table name: versions Lookup key field name: verid Lookup description field name: vernumber Lookup sort field name: vernumber

but we get the version values from all our projects mixed together.

Thank you in advance.

 

 

rbr
· 1
rbr
Replies (2)
helpful
1
not helpful

That is because the versions table contains all versions for all projects.

You will have to create a view per project and set that view as the table name:

CREATE VIEW Versions_P1 As SELECT * FROM versions WHERE projid=1


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

It works.

I created the view and set my customized field with it.

Thank you very much

 


rbr
· 1
rbr