nxql


Related Questions
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 ?
  0 votes
  0 answers
  3 comments
  3229 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
  1584 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
  1414 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 ...
  0 votes
  1 answers
  4 comments
  1924 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 ...
  0 votes
  1 answers
  0 comments
  704 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 ...
  0 votes
  1 answers
  0 comments
  1819 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 ...
  1 votes
  0 answers
  3 comments
  964 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 ...
  0 votes
  1 answers
  0 comments
  1097 views

Is there a way to fetch a part of a document (eg. a particular set of metadata) using NXQL search?
  0 votes
  1 answers
  0 comments
  1711 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
  2196 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 : ...
  0 votes
  1 answers
  4 comments
  2106 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 ...
  0 votes
  1 answers
  1 comments
  2405 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 ...
  0 votes
  1 answers
  2 comments
  2474 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
  1374 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 ...
  0 votes
  1 answers
  0 comments
  1326 views