java - CMIS 查询路径包含编号不起作用

Question

我正在尝试使用路径从 alfresco 获取所有文档

SELECT cmis:path,cmis:objectId,cmis:allowedChildObjectTypeIds
FROM cmis:folder
WHERE CONTAINS('PATH:\"/app:company_home/st:sites/cm:my_tite/cm:documentLibrary/cm:PIM_x0020_Data//*\"')

工作正常，但是当在查询中再添加一列时，它不起作用

SELECT cmis:path,cmis:objectId,cmis:allowedChildObjectTypeIds
FROM cmis:folder
WHERE CONTAINS('PATH:\"/app:company_home/st:sites/cm:my_site/cm:documentLibrary/cm:3600009//*\"')

这是抛出异常

ERROR [hsRndDatasheetJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (hsRndDatasheetJob) [HSLoggingAspect] Cause : {} org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: 05090122 Request failed 400 /solr4/alfresco/cmis?wt=json&fl=DBID%2Cscore&rows=100&df=TEXT&start=0&loca le=en_IN&alternativeDic=DEFAULT_DICTIONARY&cmisVersion=CMIS_1_1&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:487) at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:629) at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:145) at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:600) at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132) at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48) at com.hs.alfresco.services.impl.HSBaseAlfrescoService.getDocumentsByPath(HSBaseAlfrescoService.java:302) at com.hs.alfresco.services.impl.HSBaseAlfrescoService$$FastClassBySpringCGLIB$$ee750fc3.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

Answer 1

问题是您的文件夹以数字开头。查看 ISO9075，对字符串进行编码应该可以解决问题。

http://docs.alfresco.com/4.1/references/API-JS-iso9075Encode.html