Gemini SQL - Moving CFS
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 |
|
Wednesday, August 24, 2011, 2:39:08 PM |