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 ...
0 votes
0 answers
0 comments
643 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: ...
0 votes
0 answers
0 comments
821 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
1042 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
851 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
688 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
1157 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
902 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
1406 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
1437 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
1017 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
1397 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
1439 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
1809 views
Hi, I am using the REST API to search a Nuxeo LTS2019 document base. This request: ...
0 votes
1 answers
1 comments
1826 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
1567 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
3684 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
2227 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
1784 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
1842 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
4051 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
1863 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
3392 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
2659 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
12671 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
4618 views