CMIS Query returns different results

cancel
Showing results for 
Search instead for 
Did you mean: 
darminm
Active Member

CMIS Query returns different results

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.1

Each time I ran the simple select query I get different result set.

Attempt 1: 3185 results, 107 seconds

Attempt 2: 3065 results, 93 seconds

Attempt 3: 4197 results, 112 seconds

Attempt 4: 3003 results, 76 seconds

We should have close to 100K documents that fall within the category we are searching for.

Thank you

2 Replies
jego
Partner

Re: CMIS Query returns different results

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

darminm
Active Member

Re: CMIS Query returns different results

Hello,

Our query is:

SELECT f.td:folderId, d.cmisSmiley SurprisedbjectId, d.td:legacyId FROM

td:insuranceDocument AS d JOIN td:tagged AS t ON d.cmisSmiley SurprisedbjectId =

t.cmisSmiley SurprisedbjectId JOIN td:folderId AS f ON d.cmisSmiley SurprisedbjectId = f.cmisSmiley SurprisedbjectId

WHERE t.td:folderTags = 'Images'

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

Thank you