CMIS query return less result with broader parameters

cancel
Showing results for 
Search instead for 
Did you mean: 
bromb
Member II

CMIS query return less result with broader parameters

Hello,

We're currently facing a strange behavior in one of our search webscript.

The user can fill some filter, and we will return a list of document based on those filter.

For example:

Spoiler
SELECT * 
FROM fds:document AS D 
JOIN cmis:folder AS O ON D.cmis:objectId = O.cmis:objectId 
WHERE NOT (CONTAINS(D, 'PATH:\"/app:company_home/cm:Failure//*\"') OR CONTAINS(D, 'PATH:\"/app:company_home/cm:DropZone//*\"'))

AND D.fds:docType='F1 CONTR' AND D.fds:docSource='mail'

 

 

Will return one result :

Spoiler
20211103075626EML502 (fds:document): workspace://SpacesStore/d47f4bc2-d7ed-4753-8cd1-77d6897a3c7b

 

 

The following query will also return the same result:

Spoiler
SELECT * 
FROM fds:document AS D 
JOIN cmis:folder AS O ON D.cmis:objectId = O.cmis:objectId 
WHERE NOT (CONTAINS(D, 'PATH:\"/app:company_home/cm:Failure//*\"') OR CONTAINS(D, 'PATH:\"/app:company_home/cm:DropZone//*\"'))

AND D.fds:docType='F1 CONTR' AND AND D.fds:docSource='mail' AND O.cmis:name='202111*'

But if we broader the search on the name of the folder, such as " AND O.cmis:name='2021*' ", the query won't return any documents anymore.

 

 

The same behavior can be observed if we remove the first condition ( checking if the document is not on the path of cm:Failure and cmSmiley Very HappyropZone ). Which is counterintuitive, you would expect to find more results using broader query parameters.

I've read that it may be due to the tokenization in one property, but the name is not defined in our model, so I've got no idea how to disable it on the folder name attribute.

 

 

2 Replies
cesarista
Customer

Re: CMIS query return less result with broader parameters

Hi:

Are you sure that broader query is able to finish, and it is not giving some timeout due solr.http.socket.timeout param ?

Regards.

--C.

bromb
Member II

Re: CMIS query return less result with broader parameters

Hi,

 

I don't believe so, there are no errors indicating a timeout in either alfresco log files, or solr log files.

 

In order to be sure, I've added solr.http.socket.timeout=120000 to the alfresco-global.properties, and I still have the same issue.