nxql
Hello, I'm currently trying to retrieve all the versions of a document using a NXQL query, filtering them by their parent id. Here is my current NXQL query : SELECT * FROM MyDocumentType WHERE ecm:parentId = '63ab5b87-6e28-4deb-929b-5b5259bcc143' ...
0 votes
2 answers
0 comments
6870 views
I am programming using the REST API and NXQL. I ran into some problems and found it easier to test queries first using Nuxeo Shell : Nuxeo Shell in batch mode My goal is to have a listing of items found in a workspace or folder. I tried the ...
 |
olaf
Member (767) 2 3 5 |
05/02/2016 |
0 votes
3 answers
5 comments
4420 views
I am new to nuxeo. I want list of thumbnails of all the documents stored in nuxeo. I can fetch the documents and and its related properties. I can see that one of the facet element is"Thumbnail” in facets. I need the java code to fetch the ...
 |
Veena Chaudhari
Member (47) 2 2 2 |
03/23/2016 |
0 votes
0 answers
0 comments
2222 views
is it possible to achieve IsAMemberOf(“groupName”) functionality using NXQL code.. If so, could u pls provide me with one..
 |
krishna chaitanya
Member (50) 1 2 1 |
11/09/2015 |
0 votes
1 answers
0 comments
2405 views
Hello, I'm wondering if there are any helper classes or any object model services to create NXQL queries? In order to avoid concatenating text manually or to avoid chars escaping problems. Thanks.
0 votes
1 answers
1 comments
1994 views
i'm using Nxql to do search on my custom document types, but i've noticed that with this NXQL query : <fixedPart> ecm:isCheckedInVersion = 0 AND ecm:mixinType != 'HiddenInNavigation' AND ecm:currentLifeCycleState != 'deleted' AND ecm:parentId ...
0 votes
1 answers
0 comments
4047 views
Hi, I'm getting a misbehavior with elasticsearch while casting a NXQL query with ILIKE operators. I mapped the fields lowercase_analyzer in the elasticsearch config file. It works perfect with ElasticSearch, but it cast different result depending on ...
 |
JVent
Member (485) 1 4 4 |
07/23/2015 |
0 votes
1 answers
4 comments
4017 views
Hi, I'm using NXQL to read data from the default repository using a simple operation chain created on the fly: CoreSession cs = CoreInstance.openCoreSession(null);
String lookbookQuery = "SELECT * from Document WHERE ...
 |
Lorenzol
Member (198) 1 2 4 |
04/10/2015 |
0 votes
0 answers
0 comments
1777 views
Hello, I am considering a repository structure where there are two document types: let's call one “Base” and the other “Enhancements”. I would like to use the Relations functionality of Nuxeo to indicated that a given “Enhancements” requires a given ...
 |
Steven Huwig
Member (2.3K) 3 5 6 |
03/02/2015 |
Answer: I ended up implementing the following solution. It appears to work for my use case. package com.example; import org.apache.commons.lang.StringUtils;
import org.nuxeo.ecm.automation.core.Constants;
import ...
1 votes
2 answers
2 comments
3134 views
Hi i upgraded a nuxeo 5.4.1 to 6.0 There are some issues with the publication_widget_template.xhtml widget with documents having a name with a quote. has there been a problem during upgrades that lead to this error ? http://pastebin.com/bEt5nh2C
 |
pibou Bouvret
Member (8.9K) 4 7 10 |
11/24/2014 |
Answer: Thanks for the stack trace. That's a bug ( NXP-16014 ), we'll fix this for the first hotfix. In the meantime a workaround is to avoid single quotes in domain names.
0 votes
1 answers
0 comments
2247 views
With such a schema <ubx_convention:avis>
<item>
<instance>Instance Centrales/Conseil d'administration</instance>
<date>2014-10-09T22:00:00.00Z</date>
</item>
<item>
<instance>Instance ...
|
pibou Bouvret
Member (8.9K) 4 7 10 |
10/18/2014 |
Answer: If the only SQL equivalent involves NOT EXISTS then I don't think this can be done in a single query in Nuxeo.
0 votes
1 answers
0 comments
2181 views
Hi i m trying to build dynamic content based on dates comparisons : I can either use smart folders in order to build a NXQL query that must contain a static part (eg : validation_date > current_date). Unfortunately, there is no current_date ...
|
pibou Bouvret
Member (8.9K) 4 7 10 |
10/14/2014 |
0 votes
0 answers
0 comments
2375 views
Like documents having no value in the dc:subjects field.
 |
fast_narcis
Member (179) 1 2 3 |
04/24/2014 |
0 votes
1 answers
3 comments
1756 views
I have a custom doc model with a list attribute containing IDs to other objects, thus representing a list of links. I'd like to query objects that have no values on this attribute, something like: SELECT * FROM Document WHERE dc:subjects = NULL Is ...
0 votes
1 answers
3 comments
3666 views
i am looking for unique validation on title of workspace using NXQL . Is there any tool to execute NXQL other than the script? one separate question - where are my workspaces stored? which table ?
 |
zod
Member (239) 2 3 4 |
03/10/2014 |
0 votes
2 answers
1 comments
2475 views
Hi i have accented characters in some documents titles and paths. Querying titles from an automation client based portlet works fine but not for paths. Any idea ?
|
pibou Bouvret
Member (8.9K) 4 7 10 |
01/31/2014 |
0 votes
0 answers
3 comments
4309 views
I have a standard Content View based on NXQL query. I want an optional criteria in the query, coming from a seam bean property. In this particular case, it is a flag to show or hide obsolete objects. Here is the query: SELECT * FROM Document WHERE ...
0 votes
2 answers
5 comments
2719 views
Hi, I need to set up the DAM module so that some assets can be limited to certain groups or campuses. I've set up Folders for each Campus in the Asset Library. These show up fine in the DM; but I want to see them in the DAM. I'm using the Nuxeo DAM ...
0 votes
1 answers
0 comments
2447 views
Suppose that I have published document 'abcd' with version 1.0. Then later, I modify the document and publish it with 1.5. I want to get a hold of the previously published version of a document using NXQL. Is there a way to do that? Something like ...
 |
kneumei
Member (26) 1 1 1 |
07/25/2013 |
0 votes
1 answers
4 comments
3603 views
Hello Nuxeo people, I'm using the studio and in this case i'm focussed on the Content Model -> Structure Templates functionality. My problem is if i want to create a document with a ' in it (for instance “L'école …“) i have to pass my document ...
 |
Antoine Cordier
Member (2.7K) 3 5 7 |
06/06/2013 |
Answer: OK, It was all my mistake as I attached a trigger to workspace creation in that domain. This trigger is using a NXQL query to determine whether a chain should run or not. So this made my day: Replace : SELECT * FROM Document WHERE ...
0 votes
1 answers
0 comments
1100 views
I'm creating a new Content View. I want to select documents where a date field (rule:Rule-ExpiringDate) is less than the current date plus 30 days. In other words, all documents that will expire within 30 days from today, including those already ...
 |
paerickson Erickson
Member (10) 1 1 0 |
02/01/2013 |
0 votes
1 answers
0 comments
3432 views
I have a new clean 5.5 install running against a PostgreSQL 9.1 and phrase-based searching is not working. For example if I enter “data migration” (with the double-quotes) I get documents with the words data AND migration no matter where in the ...
 |
sradford
Member (96) 1 2 2 |
11/14/2012 |
1 votes
0 answers
3 comments
1870 views
I have a query in a content view which looks like this: (ecm:mixinType = 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted') AND ecm:parentId=? AND (ecm:primaryType =? OR ecm:currentLifeCycleState ...
 |
karl_harris
Member (3.4K) 3 6 6 |
11/02/2012 |
0 votes
1 answers
0 comments
1919 views
Is there a way to fetch a part of a document (eg. a particular set of metadata) using NXQL search?
 |
roccapl
Member (412) 1 4 3 |
10/27/2012 |
0 votes
1 answers
0 comments
2448 views
In our developpement in Nuxeo, we added some new permissions. We want to know if a particular permission is grant anywhere in Nuxeo for a specific user or group. Is it possible? If we look directly into the database, it's really easy to answer to ...
0 votes
3 answers
3 comments
3492 views
I have a problem with a simple NXQL query in Studio launched using quartz : SELECT * FROM Document WHERE reunion:rappel > @{CurrentDate.days(-1)} AND reunion:rappel < @{CurrentDate.days(1)} it generates the following text in an Info Message : ...
|
pibou Bouvret
Member (8.9K) 4 7 10 |
09/10/2012 |
Answer: Although my scheduler included the Administrator user <schedule id="cron_alarm_reunion"> <username>Administrator</username> <eventId>cron_alarm_reunion</eventId> <eventCategory>default</eventCategory> ...
0 votes
1 answers
4 comments
3692 views
Hello, in our project we have a set of new document types with a property 'assignee'. The documents can be assigned to a user or a user group which means that the user/group will be responsible to work on the specified documents. Now I am trying to ...
 |
Dirk Wenke
Member (201) 2 2 2 |
09/06/2012 |
0 votes
1 answers
1 comments
4404 views
Hello, I'm testing NXQL queries via Nuxel Shell on a slightly customized CMF 5.6-RC3 installation. Is it normal that a query like following SELECT * FROM Case returns only an id value (ecm:uuid) ? /case-management/case-root/2012/08/20/case 1 ...
 |
promanov
Developper (1.2K) 2 4 5 |
08/20/2012 |
Answer: The query command in the Nuxeo Shell only returns documents (either their uuid or their path depending on the options). You would need to define your own Shell command using an new Operation that uses queryAndFetch to get the result you want (this ...
0 votes
1 answers
2 comments
3896 views
While coreSession.query() works fine for “SELECT * FROM Document WHERE … order by ecm:pos " i do not find a way to get this ecm:pos value. Unfortunately, it is not one of the getters of DocumentModel. The simple trial with “SELECT * , ecm:pos FROM” ...
0 votes
1 answers
2 comments
2582 views
We have nuxeo queries which come from a constants file. A sample query is listed below. public static final String GET_FILES_BY_PARENT =“SELECT * FROM File WHERE ecm:parentId = ?” OR public static final String GET_FILES_BY_PARENT =“SELECT * FROM ...
 |
nuxeonovice
Member (251) 1 3 1 |
05/08/2012 |
0 votes
1 answers
0 comments
2138 views
We have Nuxeo EP 5.5 deployed at one of our server. Our application that is deployed on another computer using Nuxeo webservices to search document against a search criteria. Now there may be 10,000 records against this search criteria because we ...
 |
SMAH Haider
Member (754) 2 4 2 |
05/02/2012 |
Answer: There are various different signatures for CoreSession.query() , some of which like this take limit/offset values. Make sure that you ORDER BY in your query to get consistent results, for instance ORDER BY ecm:uuid .
0 votes
1 answers
3 comments
3755 views
I've done the following query two ways: Using parent/child in Studio. Using NXQL query in Studio and get the same error. Here is the NXQL. SELECT * FROM Document WHERE ecm:isCheckedInVersion = 0 AND ecm:parentId = '@{Context[“TRAVELERID”]}' AND ...
|
karl_harris
Member (3.4K) 3 6 6 |
03/30/2012 |
Answer: I found the automation chain I was calling did not return a document this was by my design. I was using Run Document Chain which expects a document or documents to be returned. Since nothing was returned (the end result of the called chain was a ...
0 votes
1 answers
3 comments
2030 views
I have a content view with the following query ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' and ecm:parentId=? AND ecm:primaryType =? and as query parameters {currentDocument.id} ...
|
karl_harris
Member (3.4K) 3 6 6 |
03/14/2012 |
0 votes
0 answers
0 comments
1771 views
Hi, I'm inside an automation chain and I need to get the current user's private workspace. The trouble is that user names are in the form: username@domain.com, and the private workspace is named like 'username-domain-com'. How can I write a query ...
0 votes
3 answers
0 comments
2594 views
Follow
content-management-platform document-management nuxeo-studio automation search queries repositories jsf webservices 5.5 nuxeo-sudio integration metadata userworkspace upgrade postgresql nuxeo-ide permissions nuxeo-client content_view 5.8 version 7.10 digital-asset-management quartz migration thumbnail cmis nuxeo parameter versions relations accent 6.0 query elasticsearch Development-Configuration date 7.4
content-management-platform document-management nuxeo-studio automation search queries repositories jsf webservices 5.5 nuxeo-sudio integration metadata userworkspace upgrade postgresql nuxeo-ide permissions nuxeo-client content_view 5.8 version 7.10 digital-asset-management quartz migration thumbnail cmis nuxeo parameter versions relations accent 6.0 query elasticsearch Development-Configuration date 7.4
pibou Bouvret
Member (8.9K)
Member (8.9K)
promanov
Developper (1.2K)
Developper (1.2K)
karl_harris
Member (3.4K)
Member (3.4K)
olaf
Member (767)
Member (767)
zod
Member (239)
Member (239)
ITShine
Member (1.8K)
Member (1.8K)
Veena Chaudhari
Member (47)
Member (47)
elteo
Member (79)
Member (79)
Brian T
Member (541)
Member (541)
fast_narcis
Member (179)
Member (179)
SMAH Haider
Member (754)
Member (754)
krishna chaitanya
Member (50)
Member (50)
kneumei
Member (26)
Member (26)
Lorenzol
Member (198)
Member (198)
Steven Huwig
Member (2.3K)
Member (2.3K)
nuxeonovice
Member (251)
Member (251)
erdmann
Member (57)
Member (57)
paerickson Erickson
Member (10)
Member (10)
roccapl
Member (412)
Member (412)
Dirk Wenke
Member (201)
Member (201)
kfrapin
Member (91)
Member (91)
maxr
Member (147)
Member (147)
JVent
Member (485)
Member (485)
sradford
Member (96)
Member (96)
Antoine Cordier
Member (2.7K)
Member (2.7K)