topic Re: CMIS Query returns different results in Alfresco Forum

CMIS Query returns different results

darminm — Sat, 21 Jan 2017 18:43:21 GMT

Hello,We have a repository with about 2M documents.We are trying to get list of documents that have a certain category (attribute) assigned.I am using CMIS Workbench to connect to Alfresco 5.0.3.1Each time I ran the simple select query I get different result set.Attempt 1: 3185 results, 107 secondsA

Re: CMIS Query returns different results

jego — Sun, 22 Jan 2017 10:25:09 GMT

Hi,

please Post your query here... and check if the query will run via Solr or database...

maybe there is a timeout / limit in Alfresco which prevents returning all results.

do you find anything in the repository log?

thanks

jens

Re: CMIS Query returns different results

darminm — Sun, 22 Jan 2017 16:16:11 GMT

Hello,

Our query is:

SELECT f.td:folderId, d.cmisbjectId, d.td:legacyId FROM

td:insuranceDocument AS d JOIN td:tagged AS t ON d.cmisbjectId =

t.cmisbjectId JOIN td:folderId AS f ON d.cmisbjectId = f.cmisbjectId

WHERE t.td:folderTags = 'Images'

There is nothing in the alfresco.log when the query is run.

Thank you