topic Nuxeo LTS 2016 (8.10-HF16) > NXQL : NOT query curious behavior in Nuxeo Forum

Nuxeo LTS 2016 (8.10-HF16) > NXQL : NOT query curious behavior

promanov_ — Fri, 20 Oct 2017 10:22:40 GMT

Hi guys,

I've spotted a curious behavior of the NOT criteria in NXQL:

Here is a query that doesn't work:

SELECT * FROM Workspace WHERE NOT ecm:path STARTSWITH '/default-domain/UserWorkspaces'

It gives shared workspaces that have "/default-domain/workspaces" path too. Replacing in the NXQL "UserWorkspaces" with "workspaces" works fine. Strange, not?

It seems to be a regression comparing to LTS 2015.

Re: Nuxeo LTS 2016 (8.10-HF16) > NXQL : NOT query curious behavior

Florent_Guillau — Fri, 20 Oct 2017 10:29:38 GMT

The query asks for all workspaces that are not under /default-domain/UserWorkspaces, so why do you say it's wrong to return /default-domain/workspaces/foobar? Such workspaces are not under /default-domain/UserWorkspaces so they match your query.

Re: Nuxeo LTS 2016 (8.10-HF16) > NXQL : NOT query curious behavior

promanov_ — Fri, 20 Oct 2017 11:46:55 GMT

oh, my phrase is not correct. In fact this query returns both

Re: Nuxeo LTS 2016 (8.10-HF16) > NXQL : NOT query curious behavior

Florent_Guillau — Fri, 20 Oct 2017 12:43:45 GMT

I can't reproduce your issue.