When trying to add a WHERE clause such as "SELECT * FROM cmis:document WHERE cmis:isLatestVersion = true", one get the following error:
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.query.QueryParseException. message: Cannot use column in WHERE clause: cmis:isLatestVersion
at org.nuxeo.ecm.core.opencmis.impl.server.CMISQLQueryMaker.recordSelector(CMISQLQueryMaker.java:672)
at org.nuxeo.ecm.core.opencmis.impl.server.CMISQLQueryMaker.buildQuery(CMISQLQueryMaker.java:214)
at org.nuxeo.ecm.core.storage.sql.jdbc.ResultSetQueryResult.<init>(ResultSetQueryResult.java:58)
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.queryAndFetch(JDBCMapper.java:772)
... 112 more