How to delete more than 10000 records using HMC

[former_member635399]

We are trying to delete our old inactive records from users table using hmc. when we are selecting 10000 records and clicking on delete button but the records are not getting deleted. The page gets refreshed but records are untouched. Could you please suggest is there any way we can delete more than 10000 records at one shot from hmc. We have millions of data which needs to be deleted for clean up . We need advvice how to delete that much data using hmc.

[rohit31_raj92]

Hi , Do refer to discussion and solution mentioned for same type of issue :

https://answers.sap.com/questions/12772413/how-to-delete-large-amount-of-data-through-hmc-hyb.html?c...

[former_member649347]

Please use groovy script to delete

import de.hybris.platform.servicelayer.search.*
import de.hybris.platform.servicelayer.model.*
import de.hybris.platform.servicelayer.search.FlexibleSearchQuery

query = "select {pk} from {Product} where {code} in ('12345','23456')"
flexibleSearchQuery = new FlexibleSearchQuery(query);
searchResult = flexibleSearchService.search(flexibleSearchQuery);

for(result in searchResult.getResult()) {
println "Product Code"+result.getCode()";
modelService.remove(result)
println “ Product Removed successfully for product id “+result.getCode();
}