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' ...

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 ...

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 ...

is it possible to achieve IsAMemberOf(“groupName”) functionality using NXQL code.. If so, could u pls provide me with one..

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.

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 ...

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 ...

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 ...

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 ...

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

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 ...

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 ...

Like documents having no value in the dc:subjects field.

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 ...

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 ?