topic Re: How to make FTS queries on custom type on Alfresco 6? in Alfresco Forum

How to make FTS queries on custom type on Alfresco 6?

easy_bd_infra — Wed, 27 Mar 2019 09:28:00 GMT

Hi,I've configured a custom type on Alfresco 6, but I'm not able to make Full Text Searches on custom fields of the custom type.This is the definition of the field in the "alfresco model manager":<model xmlns="http://www.alfresco.org/model/dictionary/1.0" name="premsa:ArxiuPremsa"> ... &l

Re: How to make FTS queries on custom type on Alfresco 6?

angelborroy — Wed, 27 Mar 2019 10:20:16 GMT

Probably the results are different because SOLR is not considering permissions.

Re: How to make FTS queries on custom type on Alfresco 6?

easy_bd_infra — Wed, 27 Mar 2019 11:07:19 GMT

Hi,

I'm connecting with the "admin" user.

The document, has the following permissions:

inherited: Everyone=Consumer
has no locally set permissions

Re: How to make FTS queries on custom type on Alfresco 6?

angelborroy — Wed, 27 Mar 2019 12:11:37 GMT

As I said, SOLR is not considering permissions.

Re: How to make FTS queries on custom type on Alfresco 6?

easy_bd_infra — Thu, 28 Mar 2019 07:40:20 GMT

Hi Angel,

I don't understand your response.

If SOLR is returning results and I know that at least one of them is accessible by me, why I'm not seing this result?

Jordi.

Re: How to make FTS queries on custom type on Alfresco 6?

angelborroy — Thu, 28 Mar 2019 08:59:15 GMT

If I understood right...

You get 1 result when using Search APIs (CMIS / FTS)

You get 10 results when querying directly SOLR

What makes sense, as SOLR does not check permissions and returns all the results in Alfresco Repository.

Am I missing something?

Re: How to make FTS queries on custom type on Alfresco 6?

easy_bd_infra — Thu, 28 Mar 2019 13:21:20 GMT

Not exactly.

This is the situation:

I have 1 document with AP_TITOL = "Llach treu una nova novel· la". User "admin" can see it (from Alfresco Share).

When querying SOLR directly, this document is in the list.

But when user "admin" queries by CMIS with CONTAINS no document is returned.

From my perspective, what should happen is: SOLR returns some documents , then Alfresco applies security and some documents may be discarted, but the Document I mentioned before should not be discarted because "admin" has permission to see it.

Other facts:

If "admin" performs a CMIS relational query (without CONTAINS), the document is returned.

After your last answer, I've found that when querying SOLR directly, it returns all the documents of my custom type, it seems to ignore my CONTAINS clause!!

Jordi.

Re: How to make FTS queries on custom type on Alfresco 6?

angelborroy — Thu, 28 Mar 2019 14:38:30 GMT

Did you follow Step 3 (cross-language) to configure your SOLR 6?

Installing and configuring Search Services without SSL | Alfresco Documentation

Re: How to make FTS queries on custom type on Alfresco 6?

easy_bd_infra — Tue, 02 Apr 2019 13:48:11 GMT

You were right.

After enabling cross-language in solr, restarting servers and reindexing documents, I'm able to find the documents with CMIS AFS.

Thank you Angel!