topic Re: How to perform FTS exact-exact phrase searches in Alfresco 6? in Alfresco Forum

How to perform FTS exact-exact phrase searches in Alfresco 6?

easy_bd_infra — Thu, 04 Apr 2019 13:06:39 GMT

Hello,I'm testing full text search (FTS) with Alfresco 6.0.7-ga and I have found that the "phrase search" (Search for a phrase | Alfresco Documentation ) is not what I expected.Our users want to be able to search:for approximate terms: the put the words without quotes and the search is approximate.

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

angelborroy — Fri, 05 Apr 2019 05:10:32 GMT

Are you using Alfresco in a cross locale environment? Do you have documents in different languages? Are your users accessing from browsers or OSs with different locales?

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

easy_bd_infra — Fri, 05 Apr 2019 06:54:58 GMT

Yes, we have enabled cross-locale in SOLR.

Yes, mainly we have documents in Spanish and Catalan, but we can have documents in English and French.

Our corporate computers and browsers have Catalan as the default language.

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

angelborroy — Fri, 05 Apr 2019 07:39:54 GMT

I have created a sample configuration (ES and EN) locales at GitHub - aborroy/search-services-cross-locale: Alfresco Search Services deployment for Cross Locale users

I tested different sentence searching terms, like "are animals intelligent" and it works as expected.

FTS Searching Sintax (to be included in Share search box and other APIs) is described at Alfresco Full Text Search Reference | Alfresco Documentation

Let me know if it works for you.

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

easy_bd_infra — Mon, 15 Apr 2019 14:00:08 GMT

Hi Angel,

sorry for the delay.

I have re-tested the searches.

Searches seem to be exact on my custom type (premsa:Noticia) and non-exact in cmis:document.

The results are the same using or not using quotes.

These are the results I get:

select * FROM cmis:document where contains('crisis') . returns 9 hits:
- 6 cmis:document, 4 of which only contain "crisi" and 2 of which only contain "crisis"
- 3 premsa:Noticia which only contain the word "crisis".
select * FROM cmis:document where contains('crisi'). returns 21 hits:
- 6 cmis:document of the previous search
- 15 premsa:Noticia which only contain the word "crisi".

After that, I have download 2 documents of premsa:Noticia (one with "crisi" and one with "crisis") and uploaded them as cmis:document and now these 2 new cmis:documents appear in both queries.

Why do I get these results? Does cmis:document have a special configuration?

Regards,

Jordi.

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

angelborroy — Mon, 15 Apr 2019 15:16:28 GMT

We have an open issue for this use case:

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

Exact term search is not working currently.

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

easy_bd_infra — Tue, 16 Apr 2019 12:41:17 GMT

Hi, I'm trying to access the issue you link, but I think I don't have permissions to see it.

Can I ask to have access? Who gives this access?

Thanks

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

angelborroy — Tue, 16 Apr 2019 13:23:46 GMT

Sorry for the inconvenience, I'm trying to move it internally to provide public access. Probably it can take a while...

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

easy_bd_infra — Thu, 09 May 2019 13:39:25 GMT

Hi, have you managed to get a public access for the issue?

Thanks,

Jordi.

Re: How to perform FTS exact-exact phrase searches in Alfresco 6?

angelborroy — Thu, 09 May 2019 14:19:46 GMT

Nope by now. Sorry. I'm still trying...