nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

NXQL: how to query docs with a list property attribute equal to null / empty / unvaluated?

promanov_

I have a custom doc model with a list attribute containing IDs to other objects, thus representing a list of links.

I'd like to query objects that have no values on this attribute, something like:

SELECT * FROM Document WHERE dc:subjects = NULL

Is it possible? I've not found anything like this in the official NXQL doc.

Thanks.

Find more posts tagged with

Accepted answers

Florent_Guillau

This should work:

SELECT * FROM Document WHERE dc:subjects/0 IS NULL

All comments

Florent_Guillau

This should work:

SELECT * FROM Document WHERE dc:subjects/0 IS NULL

promanov_

Thanks! It works perfectly (run on Nuxeo 5.8).

Florent_Guillau

As you can see the semantics are slightly different from what you're asking, but I think this is the best we can do. Also `dc

promanov_

Indeed.. not obvious to figure it out by yourself. Still, as long as it does the job it's just as good. Thanks again.