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

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.
Adilos-Cantuerk
Adilos-CantuerkAccepted solution
New Participant
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.

View reply

3 replies

Adilos-Cantuerk
Adilos-CantuerkAccepted solution
New Participant
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.

Translate
    diksha_mishra
    diksha_mishra
    New Participant
    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. 

    Translate
      Saravanan_Dharmaraj
      Saravanan_Dharmaraj
      New Participant
      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.

       

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...