Custom Field Issue
I created some custom fields that were numeric but they are not showing up in the database. What am I not doing correctly?
Patrick
· 1 |
|
Monday, April 16, 2012, 8:04:30 PM |
0
|
Please make sure that you have amended the screens (Administration -> Screens) to show this new field. |
||||
|
0
|
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) |
||||
|
0
|
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. |
||||
|
0
|
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. |
||||
|
0
|
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 |
||||
|