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 Field Issue

custom-fields

I created some custom fields that were numeric but they are not showing up in the database. What am I not doing correctly?

Custom Field Screen Shot.docx ]
Patrick
· 1
Patrick
Replies (5)
helpful
0
not helpful

Please make sure that you have amended the screens (Administration -> Screens) to show this new field.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

They show on the screens, accept the values and I can see the values when I go back into the issue. But the database table does not show these records. I can see different data type custom fields though, (Dropdown List)


Patrick
· 1
Patrick
helpful
0
not helpful

select a.customfielddataid as customfielddataid, a.customfieldid as customfieldid, a.userid as userid, a.projectid as projectid, a.issueid as issueid, cast(a.fielddata as varchar(2000)) as fielddata, a.created as created, a.tstamp as tstamp, b.customfieldname

from geminicustomfielddata a join geminicustomfielddefinitions b on a.customfieldid = b.customfieldid where b.customfieldname = 'CBT Fastraack'

I get no values for that field but there should be values.


Patrick
· 1
Patrick
helpful
0
not helpful

If they show ok on the screens (create, edit and view) then they must be in the database. Try selecting the customfieldid from the definitions table instead of by name.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

When I run: select * from geminicustomfielddefinitions a join geminicustomfielddata b on a.customfieldid = b.customfieldid where a.customfieldname = 'CBT Fastraack'

I get the result I am looking for under numericdata instead of fielddata.

Will see if that works overall.

Thanks


Patrick
· 1
Patrick