Hello, I have this NXQL query to perform : SELECT * FROM Document WHERE custom:attribute = 'Ø600' You can notice the special character Ø. It's working fine when I use NXQL Search in Web UI. It's not working with Repository.query method in Java ...

All - I need to build an NXQL query that returns only the set of documents for which ALL values of a given multi-valued document schema property are in a set of values. E.g.: If principal A is allowed to see BLUE and GREEN then pseudo-nxql is: ...

Bonjour, J'ai un problème avec mes requêtes NXQL, en effet je cherche à effectuer une recherche sur un champ (dc:title par exemple) qui ne soit pas sensible à la casse depuis une application développée avec Django et utilisant l'API Python de Nuxeo. ...

Hello, I have a nuxeo with mongoDB which contains a lot of data. My problem is that the following nxql query is very slow: select * from Document where ecm:isTrashed = 0 By removing the filter on ecm:isTrashed , I will have an immediate response, ...

Hello, How I can execute query in a template report xls for get all record from Document for example. I try jx:each(items=“coreSession.query('select * from Document', 2000)” var=“docg”) But not working :'(

Hello, Can we process the following request with a generic page provider SELECT * FROM Document WHERE dc:language = '' OR dc:language IS NULL For information I managed to look for the nulls but I don't know how to add a predicate on the empty space ...

Hello everybody, How can I validate in polymer section that a column is unique in a nuxeo form? What is the best alternative? I tried to run nxql but I couldn't :'(

Hi, I am trying to override the default search form to add some custom fields and remove the fields “nature”, “subject” and “coverage”. I copy-pasted the code from nuxeo-default-search-form , removed the widgets that I did not want and added one for ...

I'm trying to count how much disk space the workspace is using, so I'm using NXQL rest api . This is my query: http://localhost:8080/nuxeo/site/api/v1/search/lang/NXQL/execute?query=SELECT COUNT(file:content/length) FROM Document Where ecm:isTrashed ...

Hello! I'm trying to search using a full-text query. As I have to search into a specific field I'm trying to use the property: ecm:fulltext.somefield = 'something' but it doesn't work for me. Any idea? Here is my code: ecm:fulltext.act:subject = ...

Hello, Is there a way to not list the documents with the facet “HiddenInNavigation” in the result of nxql. Scenario: 1- Add the “HiddenInNavigation” facet dynamically (via a operation which calls the 'document.addfacet' method). 2- search via the ...

Hello community, In the project I'm working on we have a workspace structure where different workspaces are nested, each workspace associated with user groups and read permissions, i.e: Workspaceroot Workspace 1 Workspace 1a Workspace 1b Workspace 2 ...

Hello, I am having some problems with DATE and TIMESTAMP when using NXQL queries. According to the documentation: TIMESTAMP <timestamp> : a timestamp in ISO format yyyy - MM - dd hh : mm : ss [ . sss] (the space separator can be replaced by a ...

Hi, I am using the REST API to search a Nuxeo LTS2019 document base. This request: ...

Hi, I'm trying to use the ILIKE operator with the REST API. I have a Workspace named 'Shared' on my instance, so from the Nuxeo NXQL Console it is working with “SELECT * FROM Document WHERE dc:title LIKE / ILIKE 'Shared' “. When I use GET (with ...