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 Delete or other method??

web-app

I have a ton of issues that were created by the mailbox processor that I want to batch delete. Is there either something I'm missing in the interface that will allow me to do this, or some SQL sproc I could run that would properly clean up all the issues and related records, if I was able to get the collection of record ids myself....like:

exec domassdelete (1,2,3,4,5,6,7,8)

where 1,2,3,4,5,6,7,8 were issue ids

pauldes
· 1
pauldes
Replies (3)
helpful
0
not helpful

Unfortunately, no. However, if you let us know the Gemini version you are running, we could write it for you.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

THANKS!!

2.2.7


pauldes
· 1
pauldes
helpful
0
not helpful

The SQL below will delete any issues that are in the issuesfordeletion table:

-- Run this once

create table issuesfordeletion (issueid int)
go

 

-- Insert your issue ids into the table: here we only inserted 1 issue to delete (26)

insert into issuesfordeletion values(26)
go

delete from issuehistory where issueid in (select issueid from issuesfordeletion)
delete from issueattachments  where issueid in (select issueid from issuesfordeletion)
delete from issuevotes where issueid in (select issueid from issuesfordeletion)
delete from affectedversion where issueid in (select issueid from issuesfordeletion)
delete from issueresource where issueid in (select issueid from issuesfordeletion)
delete from issuecomponent where issueid in (select issueid from issuesfordeletion)
delete from watchissue where issueid in (select issueid from issuesfordeletion)
delete from issuealerts where issueid in (select issueid from issuesfordeletion)
delete from issuelinks where issueid in (select issueid from issuesfordeletion)
delete from issuelinks where otherissueid in (select issueid from issuesfordeletion)
delete from customfielddata where issueid in (select issueid from issuesfordeletion)
delete from personalfilters where issueid in (select issueid from issuesfordeletion)
delete from sourcecontrolissuefiles where issueid in (select issueid from issuesfordeletion)
delete from timetracking where issueid in (select issueid from issuesfordeletion)
delete from issuecomments where issueid in (select issueid from issuesfordeletion)
delete from issues where issueid in (select issueid from issuesfordeletion)


Saar Cohen
· 5000
Saar Cohen