topic Re: Searching files using fts-alfresco in Alfresco Forum

Searching files using fts-alfresco

Hoang — Tue, 06 Oct 2020 13:47:34 GMT

Hi,

I use fts-alfresco to search file name containing words starting with "my"

query: "+TYPE:content AND cm:name:'my*' AND PATH:'app:company_home/cm:Test//*'"

But I get also files, which not starting with "my"

"mydoc.xml"
"mytext.completeness.log"
"78789_my.joblog.lxml"
"1787975_my.joblog.html"

Any ideas for that?

Thanks,

Hoang

Re: Searching files using fts-alfresco

angelborroy — Tue, 06 Oct 2020 14:47:45 GMT

FTS is applying tokenization for "cm:name" field, so you get extra results that include "my" as token.

You can switch to CMIS Syntax, using a query similar to this one:

SELECT * FROM cmis:document WHERE cmis:name LIKE 'my%'

Re: Searching files using fts-alfresco

Hoang — Wed, 07 Oct 2020 12:54:42 GMT

Thanks angelborroy,

I've found some ways to achieve that including your suggestion.

CMIS:
query: "SELECT * FROM cmis:document WHERE IN_TREE('543a5920-8b57-4f7b-8831-fab4ae39eaa0') AND cmis:name like 'my%'"

or search for an exact term using "="

query: "SELECT * FROM cmis:document WHERE IN_TREE('543a5920-8b57-4f7b-8831-fab4ae39eaa0') AND CONTAINS('=cmis:name:my*')"

AFS:
query: query: "+TYPE:content AND =cm:name:'my*' AND PATH:'app:company_home/cm:Test//*'"

Results as expected:
"mydoc.xml"
"mytext.completeness.log"

Re: Searching files using fts-alfresco

angelborroy — Wed, 07 Oct 2020 12:59:10 GMT

@afaust I guess this "AFS" query from last comment is one that we broke in 2.0.0...

https://issues.alfresco.com/jira/browse/SEARCH-2461

Re: Searching files using fts-alfresco

Hoang — Mon, 12 Oct 2020 09:15:24 GMT

I have an other problem when using "=".

Example:

1) Query without "=". All pdf files were found. Results as expected.

Query: PATH:'/app:company_home/cm:Test//*' AND cm:name:'*.pdf'

2) Query with "=". Just only one was found. But all pdf files should be also found.

Query: PATH:'/app:company_home/cm:Test//*' AND =cm:name:'*.pdf'

Is this a bug?

Re: Searching files using fts-alfresco

Hoang — Mon, 12 Oct 2020 10:33:25 GMT

Another problem when using the "?" wildcard character.

Example:

3) Query file name starting with "28" followed by "?????.pdf". Results as expected.

4) Replace "28" with "??". Nothing found.

Any Ideas?