NXQL


Related Questions
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
  67 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
  172 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
  145 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
  255 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
  270 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
  280 views

Hi, I am using the REST API to search a Nuxeo LTS2019 document base. This request: ...
  0 votes
  1 answers
  1 comments
  320 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
  433 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
  1873 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
  1131 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
  993 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
  1038 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
  1879 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
  1092 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
  1757 views