Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session
SOLVED

Search and tag null metadata fields

Avatar

Level 3

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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 solution in original post

3 Replies

Avatar

Community Advisor

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.

 

Avatar

Community Advisor

@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. 

Avatar

Correct answer by
Community Advisor

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.