Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.

AEM 6.2 Bulk Editor Query Parameters

Avatar

Former Community Member

Hi,

I am trying to use AEM BulkEditor to export/import metadata for my assets.  When I search for assets, its returning all the subassets as well.  For example, I have pdf file called /content/dm/gmassets/samplefolder/searchTOLogicalflow.pdf that has 4 pages.  When I search in BulkEditor, results grid shows me 4 subassets, one for each page.  Is there a way to filter these out.  I tried several query parameters like mainasset:mainasset=true but nothing has worked.  

Can anyone suggest a way to remove these subassets from results?

Thanks,

Manisha

2 Replies

Avatar

Level 10

I am getting the same results. If you need that level of querying - i would look at using JCR SQL and perform queries like: 

"SELECT * FROM nt:unstructured WHERE jcr:path LIKE '"+path +"/%' AND NOT jcr:path LIKE '"+path +"/%/%'";

Using JCQ SQL/2 - you ahve much better control over what the result set is.