Flexible Query to find duplicate CMSItems in Hybris

Published by Syed W. Aslam on

Sometimes HMC/Backoffice is buggy when searching for Duplicate Identifiers. This is a handy flexible query to find duplicate CMSItems in Hybris:

SELECT {UID}, count(1) from {CMSItem} WHERE {CatalogVersion} = <catalogversionPK> GROUP BY {UID} HAVING COUNT(1) > 1

For the CatalogVersion, use the respective CatalogVersion PK

Categories: Hybris

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

Related Posts

Backoffice Hybris

How to change the export CSV limit in Hybris Backoffice

In the Backoffice, there is a default limit for exporting the list to CSV that is set through <setting> element. For example, the Cronjobs has a default limit of 500. In some cases, we would Read more…

Hybris WebService

How to expose an endpoint from SAP Commerce (Hybris)

In this post, I will discuss how one can expose an endpoint in Hybris to be consumed by an external system. All of the code that we will add will be in an extension which Read more…

Backoffice Hybris

How to read properties inside Backoffice’s config file of SAP Commerce

To read the properties inside Backoffice’s config file, we need to get the configurationService bean. From it, we can get the properties. Reading properties inside config file Finally, for all of my posts in SAP Read more…