Exception for Translation to SQL of a NXQL query order by
ecm:currentLifeCycleState or ecm:versionLabel
-------------------------------------------------------------------------------------------------------
Key: NXP-3595
URL: http://jira.nuxeo.org/browse/NXP-3595
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Reporter: Benjamin Jalon
Assignee: Thierry Delprat
this query "SELECT * FROM Document ORDER BY ecm:currentLifeCycleState" causes
an exception :
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
SELECT * FROM Document WHERE ecm:parentId =
'dbf2dbe5-1bc8-41b3-a558-330d9f3026da' AND ecm:isCheckedInVersion = 0 AND
ecm:mixinType != 'HiddenInNavigation' AND ecm:currentLifeCycleState !=
'deleted' ORDER BY ecm:currentLifeCycleState
at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:549)
at
org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:246)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:380)
... 164 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.postgresql.util.PSQLException. message: ERROR: for SELECT DISTINCT, ORDER
BY expressions must appear in select list
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
