I am looking for query on how to select all dam assets(pdf, jpg and etc ) over 1 mega bites.
These are queries of what I can think of.
But when I checked the results, they are not correct.
Could you please provide advice on how to get all dam assets bigger that 1 mega bites using query builder?
Please find below query to find all jpg images with more than 1MB size.
Query Builder console result :
1.4+ mb size image in DAM :
Not sure about the use case for writing these queries but you can find those assets by using the OOTB Filter view under Assets. Here are the steps -
1) Navigate to http://localhost:4502/assets.html/content/dam
2) Switch to Filter view from the panel present on the top left.
3) This will allow you to select the path, file type, file size etc.
4) You can save your selected filter as a collection and then navigate to http://localhost:4502/mnt/overlay/dam/gui/content/collections.html/content/dam/collections if you would like to download all those images etc.