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.




Gemini SQL - Moving CFS

custom-fields

I ran an SQL trace, we did a delete and this is the command it ran:

update x set customfieldid = 264 from geminicustomfielddata x where customfieldid = 0 and not exists (select * from geminicustomfielddata where customfieldid=264 and issueid=x.issueid and fielddata != '')

We were looking at the right tables before but there seems to be two issues with the SQL that Gemini is running.

1)It is changing the data for customfieldid 0 which is incorrect as that will not exist. 2)It is only moving custom field data across for issues that do not already have custom data for the target customfield on it.
User75862
· 1 		User75862
Wednesday, August 24, 2011, 2:39:08 PM
Replies (5)
helpful
0
not helpful

Which version of Gemini?
Saar Cohen
· 5000 		Saar Cohen
Wednesday, August 24, 2011, 3:26:29 PM
helpful
0
not helpful

Gemini 4.1
User75862
· 1 		User75862
Thursday, August 25, 2011, 11:07:02 AM
helpful
0
not helpful

Are you use the bulk move or single?
Mark Wing
· 9108 		Mark Wing
Thursday, August 25, 2011, 1:09:04 PM
helpful
0
not helpful

Single Move.
User75862
· 1 		User75862
Thursday, August 25, 2011, 1:12:41 PM
helpful
0
not helpful

Just tested it and all is fine for us. Can you explain what happens to the custom field once the item is moved? Does the value gets blanked out?
Mark Wing
· 9108 		Mark Wing
Thursday, August 25, 2011, 2:20:04 PM