topic Re: The search doesn't work correctly in Alfresco Forum

The search doesn't work correctly

psycore — Tue, 13 Oct 2020 07:37:42 GMT

Hello,

when I seach in alfresco\admin and use db-cmis with select * from otp:backOfficeWorkflowAssignees I get 78 items as result

but when I use API https://srv-alfekka-app02.isb/alfresco/api/-default-/public/search/versions/1/search with body {"query":{"query":"TYPEtp\\:backOfficeWorkflowAssignees AND
cm\\:name:*"},"include":["aspectNames","properties","isLink"],"paging":{"maxItems":1,"skipCount":0}}

I get only 7 items result

{"list":{"pagination":{"count":1,"hasMoreItems":true,"totalItems":7,"skipCount":0,"maxItems":1},"c
ontext":{"consistency":{"lastTxId":7009222}} ... }

I didn't have any error in log

What could be the problem?

I use ACS 6.1 with ASS 1.4.0

kaynezhang — Tue, 13 Oct 2020 13:57:42 GMT

It seems your solr index is not consistent with your db ,have you tried to rebuild your index?

psycore — Wed, 14 Oct 2020 07:28:20 GMT

I rebuild index but it didn't help

I found that the problem is when I set sharding, if I have just alfresco and archive cores without sharding all searches fine