NXQL


Related Questions
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: ...
  0 votes
  0 answers
  0 comments
  43 views

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. ...
  0 votes
  0 answers
  0 comments
  72 views

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, ...
  0 votes
  0 answers
  4 comments
  184 views

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 :'(
  0 votes
  1 answers
  0 comments
  109 views

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 ...
  0 votes
  1 answers
  1 comments
  160 views

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 :'(
  0 votes
  2 answers
  0 comments
  167 views

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 ...
  0 votes
  1 answers
  1 comments
  323 views

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 ...
  0 votes
  3 answers
  0 comments
  435 views

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 = ...
  0 votes
  1 answers
  2 comments
  279 views

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 ...
  0 votes
  1 answers
  1 comments
  454 views

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 ...
  0 votes
  2 answers
  2 comments
  469 views

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 ...
  0 votes
  0 answers
  0 comments
  456 views

Hi, I am using the REST API to search a Nuxeo LTS2019 document base. This request: ...
  0 votes
  1 answers
  1 comments
  507 views

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 ...
  0 votes
  2 answers
  1 comments
  615 views

I want to make a request with “dynamic” properties fetch from my Java app with nuxeo 8.10. There is the declatation of my NuxeoDocument: <schema name="TestDocumentProperties" src="data/TestDocumentProperties.xsd" prefix="test" /> <doctype ...
  0 votes
  0 answers
  1 comments
  2410 views