Search and tag null metadata fields | Community
Skip to main content
dmescia2
dmescia2
Level 3
December 11, 2023
Solved

Search and tag null metadata fields

  • December 11, 2023
  • 3 replies
  • 895 views

It would be amazing if we could search in the DAM based on null fields. Also, if we could bulk tag assets with nothing if we have to bulk remove a tag. Does this functionality exist?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Adilos-Cantuerk

You have already working options here from the others.
I use the metadata CSV export import and some excel powerquery to clean the system in such cases.
This provides me with a good before and after report, as well the option to go back with an import of the originaly exported CSV file if something went wrong with my import.

3 replies

Saravanan_Dharmaraj
Community Advisor
Saravanan_DharmarajCommunity Advisor
Community Advisor
December 11, 2023

if you know the property you could search for asset which doesnt have that property like below

 

type=nt:unstructured
path=/content/dam/<path>
property=jcr:content/metadata/propertyName
property.operation=not
p.hits=full
p.limit=-1

 You can set the property to null will remove the property for a resource.

 

    diksha_mishra
    Community Advisor
    diksha_mishraCommunity Advisor
    Community Advisor
    December 12, 2023

    @dmescia2 

    You might need to customize her as bulk removal isn't available OOTB. Here are some options:

    1. Create groovy script - here you can find an example that in general will do what you need - you will of course have to adjust properties/metadata you would like to remove - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-asset-metadata-delete/...
    2. You will be able to get similar results using on deploy scripts - https://adobe-consulting-services.github.io/acs-aem-commons/features/on-deploy-scripts/index.html
    3. Interesting option is also a small extension for ACS Commons Manage Control Process - here is detailed description what should be done to use it for bulk deletion of properties/metadata - https://kiransg.com/2021/12/10/bulk-add-update-and-delete-properties-in-aem-without-using-groovy-con...

    Hope this helps. 

      Adilos-Cantuerk
      Community Advisor
      Adilos-CantuerkCommunity AdvisorAccepted solution
      Community Advisor
      December 15, 2023

      You have already working options here from the others.
      I use the metadata CSV export import and some excel powerquery to clean the system in such cases.
      This provides me with a good before and after report, as well the option to go back with an import of the originaly exported CSV file if something went wrong with my import.

        Terms & ConditionsAccessibility statement

        Loading footer...