NXQL


Related Questions
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
  64 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
  176 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
  106 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
  151 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
  160 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
  307 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
  425 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
  274 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
  447 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
  458 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
  448 views

Hi, I am using the REST API to search a Nuxeo LTS2019 document base. This request: ...
  0 votes
  1 answers
  1 comments
  494 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
  600 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
  2387 views

Hi ! I'm looking for a way to update the value of one metadata on a large amount of documents. I'm currently selecting documents that need this update using a simple nxql query, yet the volume is big enough to look for an automatic way of doing ...
  0 votes
  1 answers
  0 comments
  1411 views

Working with the search i have a widget of type List. I am trying to search on multiple values. I use a prediate with the IN operator Is it possible to do the search with insensitive case? From my undestanding insensitive case is possible only with ...
  0 votes
  0 answers
  0 comments
  1156 views

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

Hi! In Nuxeo 6.0 HF 38 I'm trying to use CurrentDate in NXQL in avanced search or by quering http://nuxeoserver/nuxeo/api/v1/query When I try this, it works: http://nuxeoserver/nuxeo/api/v1/query?query=SELECT * FROM Document WHERE dc:created > ...
  0 votes
  2 answers
  3 comments
  2436 views

Hello, In my layout I would like to be able to search a document but be able to search either on its name or on its code. I tried several things with the nxql query but couldn't make it work. I thought about the javascript formatter but I think it ...
  0 votes
  1 answers
  0 comments
  1274 views

Hi there! I would like to know if there is a way to cast mine column which is string to integer in NXQL query. I want to do that because I want to either order by this column with desc attribute or choose the highest string (I didn't have any ...
  0 votes
  1 answers
  2 comments
  2078 views

Hello, We have a problem related with the query defined in a page provider. We are using Nuxeo 7.10. We are using the widgetType singleDocumentSuggestion . The following page provider works correctly: <coreQueryPageProvider name="test"> ...
  0 votes
  0 answers
  0 comments
  1537 views

Hi, I have a custom type of data in nuxeo, this custom type has some fields inside, and I trying to do a query putting this propierties in the WHERE clause. For example I can do this in a query on I want to SELECT by title: SELECT * FROM Document ...
  2 votes
  3 answers
  0 comments
  4547 views

Hi Normally one follows the recipe of querying a folder, get the UID and next issue a startswith on the ecm:path to get the contents of a folder (Workspace, Section). With Collections it is a different cookie: $query = “SELECT * FROM Document WHERE ...
  0 votes
  3 answers
  1 comments
  3258 views