NXQL
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 ...
 |
Ghazi HAKIM
Java Developer (1.2K) 1 5 8 |
12/26/2022 |
0 votes
0 answers
0 comments
543 views
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: ...
 |
Eric Ace
Member (967) 1 2 4 |
05/14/2021 |
0 votes
0 answers
0 comments
761 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. ...
 |
De Grossi Hugo
Member (286) 1 1 7 |
04/07/2021 |
0 votes
0 answers
0 comments
953 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, ...
 |
Ahmad Ben Maallem
Member (1.9K) 2 4 7 |
01/27/2021 |
0 votes
0 answers
4 comments
778 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 :'(
 |
Gabino Reyes
Member (291) 2 2 2 |
01/20/2021 |
0 votes
1 answers
0 comments
621 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 ...
|
Ahmad Ben Maallem
Member (1.9K) 2 4 7 |
01/14/2021 |
0 votes
1 answers
1 comments
1046 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 :'(
|
Gabino Reyes
Member (291) 2 2 2 |
10/06/2020 |
0 votes
2 answers
0 comments
822 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 ...
 |
Corentin Bourdon
Member (227) 1 2 2 |
07/20/2020 |
0 votes
1 answers
1 comments
1322 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 ...
 |
Gabriel A. de Souza
Member (427) 1 2 4 |
06/25/2020 |
Answer: I solved the problem, I created a custom endpoint on nuxeo which do that @WebObject(type = "my-url")
public class MyController extends DefaultObject{ @GET @Path("workspace-size") public Object simpleQuery(@Context HttpServletRequest request, ...
0 votes
3 answers
0 comments
1338 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 = ...
 |
Pablo Rodríguez
Member (56) 1 0 2 |
05/26/2020 |
0 votes
1 answers
2 comments
949 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 ...
|
Ahmad Ben Maallem
Member (1.9K) 2 4 7 |
01/10/2020 |
Answer: Hello, I think there is not any way of doing that. From the documentation: ecm:mixinType: a list of the document facets ( DocumentModel.getFacets() ) with some restrictions. 1. the facet Immutable is never seen. 2. the facets Folderish and ...
0 votes
1 answers
1 comments
1310 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 ...
 |
a c
Member (505) 1 3 6 |
11/15/2019 |
0 votes
2 answers
2 comments
1346 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 ...
 |
Rodri
Member (3K) 3 5 9 |
08/23/2019 |
0 votes
0 answers
0 comments
1738 views
Hi, I am using the REST API to search a Nuxeo LTS2019 document base. This request: ...
 |
Emmanuel Otton
Member (155) 1 2 3 |
08/06/2019 |
0 votes
1 answers
1 comments
1740 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 ...
 |
Julien ROY
Member (110) 1 1 3 |
05/27/2019 |
0 votes
2 answers
1 comments
1479 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 ...
 |
julien.dumortier90@gmail.com
Member (40) 1 2 1 |
02/09/2018 |
0 votes
0 answers
1 comments
3592 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 ...
 |
V M
Member (77) 1 2 2 |
01/05/2018 |
0 votes
1 answers
0 comments
2155 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 ...
 |
Mathieu
Member (45) 1 2 1 |
11/09/2017 |
0 votes
0 answers
0 comments
1706 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 ...
 |
promanov
Developper (1.2K) 2 4 5 |
10/20/2017 |
0 votes
0 answers
3 comments
1762 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 > ...
 |
Thierry SEBBAR
Member (115) 1 2 1 |
05/05/2017 |
0 votes
2 answers
3 comments
3953 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 ...
 |
Mathilde Viveris
Member (449) 1 2 6 |
03/30/2017 |
0 votes
1 answers
0 comments
1805 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 ...
 |
wochnik.michal@gmail.com
Member (538) 1 3 6 |
02/24/2017 |
Answer: This is not possible and would be horribly inefficient in terms of query performance for large volumes. You must design your data model according to the operations needed on the data, therefore make your column an numeric type. The fact that CMISQL ...
0 votes
1 answers
2 comments
3263 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"> ...
 |
ioihanguren
Member (1.3K) 3 5 7 |
02/03/2017 |
0 votes
0 answers
0 comments
2580 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 ...
 |
Domingo González Lozano
Member (401) 2 2 3 |
11/23/2016 |
2 votes
3 answers
0 comments
12537 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 ...
 |
olaf
Member (767) 2 3 5 |
06/13/2016 |
0 votes
3 answers
1 comments
4537 views
Follow
Development 10.10 nuxeo-platform Nuxeo10.10 Development-Configuration LTS2019 REST 7.10 REST-API Nuxeo-IDE Elasticsearch 5.8 Java API java-client 2019 PageProvider System-Environment 6.0 nuxeoplatform 8.10 webui predicate Update Collection BUG search page-provider PHP development index 9.10 HF-20 validation template-rendering nuxeo-templates-rendering nuxeo-studio API-Playground customization
Development 10.10 nuxeo-platform Nuxeo10.10 Development-Configuration LTS2019 REST 7.10 REST-API Nuxeo-IDE Elasticsearch 5.8 Java API java-client 2019 PageProvider System-Environment 6.0 nuxeoplatform 8.10 webui predicate Update Collection BUG search page-provider PHP development index 9.10 HF-20 validation template-rendering nuxeo-templates-rendering nuxeo-studio API-Playground customization
Ahmad Ben Maallem
Member (1.9K)
Member (1.9K)
Gabino Reyes
Member (291)
Member (291)
olaf
Member (767)
Member (767)
Pablo Rodríguez
Member (56)
Member (56)
Julien ROY
Member (110)
Member (110)
Ghazi HAKIM
Java Developer (1.2K)
Java Developer (1.2K)
julien.dumortier90@gmail.com
Member (40)
Member (40)
Corentin Bourdon
Member (227)
Member (227)
ioihanguren
Member (1.3K)
Member (1.3K)
Thierry SEBBAR
Member (115)
Member (115)
De Grossi Hugo
Member (286)
Member (286)
wochnik.michal@gmail.com
Member (538)
Member (538)
Mathilde Viveris
Member (449)
Member (449)
Emmanuel Otton
Member (155)
Member (155)
Rodri
Member (3K)
Member (3K)
Gabriel A. de Souza
Member (427)
Member (427)
Mathieu
Member (45)
Member (45)
V M
Member (77)
Member (77)
a c
Member (505)
Member (505)
Domingo González Lozano
Member (401)
Member (401)
promanov
Developper (1.2K)
Developper (1.2K)
Eric Ace
Member (967)
Member (967)