Deleting multiple items

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:

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

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:

Akber

Thanks for the code. I had > HI RGJ,