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.




Batch update without changing the Revised field

web-app

Hi, I noticed that the Revised field is changed when issue is updated by Batch update command. Is there some way to prevent this? I need to update thousands of issues...

stepand76
· 504
stepand76
Replies (11)
helpful
0
not helpful

Unfortunately, not as each issue is updated and therefore revised....


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

The problem is that after batch update is changed default order of issues in the list. It confuse users.


stepand76
· 504
stepand76
helpful
0
not helpful

Hi there, I'm asking again: Is there any way to batch update issues without affecting the revised field?

My task is to assign versions to thousands of issues (we didn't use versions and we want to use them for existing issues). I need to only change the version field. No others. Any chance?


stepand76
· 504
stepand76
helpful
0
not helpful

Unfortunately, no. Batch update will always update the revised field.
The only way to do this is directly from SQL.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

OK. Thanks for the info. Could you please provide some info about Gemini database stucture. What tables and what fields to edit? I just need to set versions to issues. Thank you.


stepand76
· 504
stepand76
helpful
0
not helpful

You need to update the field fixedinversionid in the geminiissues table (filter on issueid).
Update it to a value from the gemini
versions (versionid).


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thank you. Last question: How to change affected versions?


stepand76
· 504
stepand76
helpful
0
not helpful

insert issueid and versionid to the gemini_affectedversions table.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

[quote user="MarkWing"]Unfortunately, no. Batch update will always update the revised field.
The only way to do this is directly from SQL.
[/quote]
And what about from Web Service? Also touch the revised field?


stepand76
· 504
stepand76
helpful
0
not helpful

Yes.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

OK. Thanks.


stepand76
· 504
stepand76