topic alfresco_fts query in Alfresco Forum

alfresco_fts query

ssciacca — Wed, 27 Nov 2019 18:59:33 GMT

I faced with strange (for me) problem.
When I query with (for example)

SITE:"test" and TYPE:"test:myDoc"

I get a lot of nodes.
Now I add an optional aspect to only 2 of previous nodes and try to get such nodes with

SITE:"test" and TYPE:"test:myDoc" and ASPECT:"test:myAspect"

Responce on node browser is: zero results. But If I cut the SITE part of the query and use:

TYPE:"test:myDoc" and ASPECT:"test:myAspect"

I get only the 2 nodes!

The problem is that I cannot cut the SITE part of the query.
Would anyone know how to solve this strange problem?
I'm stuck.

Thanks in advance.

Re: alfresco_fts query

narkuss — Wed, 27 Nov 2019 20:56:15 GMT

I did never heard about SITE keyword in fts queries, but have you tried specifying PATH instead of SITE? PATH would be something like "app:company_home/st:sites/cm:test". I don't remember exactly the namespaces, but you can find this path searching site's document library noderef in node browser

Re: alfresco_fts query

ssciacca — Wed, 27 Nov 2019 21:46:14 GMT

Thank you, Narkuss, for the answer.

Before to post the message I tryed the PATH alternative with the same (identical) problem.

SITE is a special field.

You can find the complete list here.

Re: alfresco_fts query

ssciacca — Thu, 28 Nov 2019 17:32:58 GMT

Solved!
Write here the solution for others with the same or similar problem.
I performed a full reindex with solr (as described on documentation) and now I get correct results. Now both the 2 query:

SITE:"test" and TYPE:"test:myDoc" and ASPECT:"test:myAspect"
TYPE:"test:myDoc" and ASPECT:"test:myAspect"

return 2 nodes!