Deleting multiple items

Posted by rgj on May 4, 2007, 6:30 pm

Please log in for more thread options

In the Items window (Ver2.0) I can only highlight one item at a time
for deletion.
Is there any way I can delete multiple items in one hit?

Posted by Akber Alwani on May 5, 2007, 1:38 am

Please log in for more thread options

HI, as it risky and not all system provide you to do so in one click. so I
would say you need some 3rd party add on for this.

"rgj" wrote:

> In the Items window (Ver2.0) I can only highlight one item at a time

> for deletion.

> Is there any way I can delete multiple items in one hit?

Posted by rgj on May 6, 2007, 4:06 pm

Please log in for more thread options

On May 5, 6:38 am, Akber Alwani

> HI, as it risky and not all system provide you to do so in one click. so I

> would say you need some 3rd party add on for this.

> "rgj" wrote:

> > In the Items window (Ver2.0) I can only highlight one item at a time

> > for deletion.

> > Is there any way I can delete multiple items in one hit?- Hide quoted text -

> - Show quoted text -

Thanks Akber
Thought that might be the case.
It seems it is easy to make a mistake using the matrix option and
generate multiple unwanted items (as I did) but then tedious to delete
those items to put the mistake right.
Bob

Posted by Akber Alwani on May 7, 2007, 12:35 am

Please log in for more thread options

HI RGJ,
if this is the case and you have not use any transaction for these items,
then I give you script which do what you need :

Below three scripts will first delete the items, then item component (matrix
details) and then Matrix header. IN the below scrip you will replace the
'MatrixItemLookupcode' with the code of your matrix i.e. 25000 as sample data.

delete from item
where ID in (select itemid from itemclasscomponent
where ItemClassID in (select ID from ItemClass where
ItemLookupcode='MatrixItemLookupCode'))

delete from itemclasscomponent
where ItemClassID in (select ID from ItemClass where
ItemLookupcode='MatrixItemLookupCode')

delete from ItemClass where ItemLookupcode='MatrixItemLookupcode'

Rate please.

"rgj" wrote:

> On May 5, 6:38 am, Akber Alwani

> > HI, as it risky and not all system provide you to do so in one click. so I

> > would say you need some 3rd party add on for this.

> >

> > "rgj" wrote:

> > > In the Items window (Ver2.0) I can only highlight one item at a time

> > > for deletion.

> > > Is there any way I can delete multiple items in one hit?- Hide quoted text

> >

> > - Show quoted text -

> Thanks Akber

> Thought that might be the case.

> It seems it is easy to make a mistake using the matrix option and

> generate multiple unwanted items (as I did) but then tedious to delete

> those items to put the mistake right.

> Bob

Posted by rgj on May 10, 2007, 6:48 pm

Please log in for more thread options

Akber

Thanks for the code.
I had in the meantime gone ahead and deleted manually - so I haven't tried
your code.
I'll keep it for next time though.
Bob

"Akber Alwani" wrote:

> HI RGJ,

> if this is the case and you have not use any transaction for these items,

> then I give you script which do what you need :

> Below three scripts will first delete the items, then item component (matrix

> details) and then Matrix header. IN the below scrip you will replace the

> 'MatrixItemLookupcode' with the code of your matrix i.e. 25000 as sample data.

> delete from item

> where ID in (select itemid from itemclasscomponent

> where ItemClassID in (select ID from ItemClass where

> ItemLookupcode='MatrixItemLookupCode'))

> delete from itemclasscomponent

> where ItemClassID in (select ID from ItemClass where

> ItemLookupcode='MatrixItemLookupCode')

> delete from ItemClass where ItemLookupcode='MatrixItemLookupcode'

> Rate please.

> "rgj" wrote:

> > On May 5, 6:38 am, Akber Alwani

> > > HI, as it risky and not all system provide you to do so in one click. so I

> > > would say you need some 3rd party add on for this.

> > >

> > > "rgj" wrote:

> > > > In the Items window (Ver2.0) I can only highlight one item at a time

> > > > for deletion.

> > > > Is there any way I can delete multiple items in one hit?- Hide quoted

text -

> > >

> > > - Show quoted text -

> >

> > Thanks Akber

> > Thought that might be the case.

> > It seems it is easy to make a mistake using the matrix option and

> > generate multiple unwanted items (as I did) but then tedious to delete

> > those items to put the mistake right.

> > Bob

> >