General Questions on Nuxeo | Nuxeo Answers - FAQ

How to make a query with properties parameter to fetch in nuxeo

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

3594 views

How can i update metadata value from nxql ?

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

2158 views

Performing case insensitive search on multiple valuse

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

1707 views

Nuxeo LTS 2016 (8.10-HF16) > NXQL : NOT query curious behavior

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

1763 views

Using CurrentDate in NXQL

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

3959 views

Widget Document Suggestion how to query on two fields?

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

1807 views

NXQL Cast string column to integer

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

TAGS: Deploy Nuxeo-IDE API-Playground 7.10 NXQL

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

3265 views

Using OR in the query of a Page Provider

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

2582 views

How to do a query NXQL with propierties in WHERE clause

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

12539 views

REST API/NXQL Children of a Collection

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

4538 views

Authentication Required

NXQL

What's new in Quandora?