NXQL query for DAM-Custom Search

[Brian_T]

Hi,

I need to set up the DAM module so that some assets can be limited to certain groups or campuses.

I've set up Folders for each Campus in the Asset Library. These show up fine in the DM; but I want to see them in the DAM.

I'm using the Nuxeo DAM default [BETA] 1.2.0 (cap-5.7.1) Application Template in Studio.

under Project > Listing & Views > Content Views > DAM-Custom Search > Query & Form > Query filter

It starts out like this:

ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' and ecm:mixinType = 'Asset'

I changed it to 

>```
ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' 

and then I see the Folders that I do want and all kinds of stuff I don't want (users, workspaces, etc.)

so I changed it to

ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' AND ( ecm:mixinType = 'Asset' OR ecm:mixinType = 'Folder' )

but then I just see the same as the first Query Filter (just a test object, and the folders don't show up).

What is the proper query to show Assets and Folders?

[bruce_Grant · Accepted solution]

mixinType refers to document facets, so the correct NXQL phrase is:

ecm:mixinType = 'Folderish'

If you want to pickup only Folder document types then the NXQL phrase is:

ecm:primaryType = 'Folder'

Asset works in ecm:mixinType = 'Asset' because in this case Asset is a facet that can be applied to any document type