How to remove data from a specific item type

[bidyadhar_tripathy]

Hi All,

We have a CustomB2BUnit type derived from B2BUnit type and we need to remove all CustomB2BUnit data and its relations from db.

If we use sql query to delete the data then relations (Principal2PrincipalGroup) are not getting removed.

So Is there any groovy/impex script to remove data from a specific item type ?

Thanks in advance.

[former_member620692 · Accepted solution]

Hi - you can try something like

 REMOVE CustomB2BUnit[batchmode=true];itemtype(code)[unique=true]
 ;CustomB2BUnit

[bidyadhar_tripathy · Accepted solution]

Hi Arvind,

Thank you for your response. I tried your example and it is working fine.

[former_member620692 · Accepted solution]

You are most welcome.