topic How to make FTS queries on custom type on Alfresco 6? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64179#M21882 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P><P></P><P>This is the definition of the field in the "alfresco model manager":</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>&lt;model xmlns="http://www.alfresco.org/model/dictionary/1.0" name="premsa:ArxiuPremsa"&gt;</P><P>&nbsp;&nbsp; ...<BR />&nbsp;&nbsp;&nbsp; &lt;types&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type name="premsa:Noticia"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;title&gt;AP_Noticia&lt;/title&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parent&gt;cm:content&lt;/parent&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;properties&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="premsa:AP_TITOL"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type&gt;d:text&lt;/type&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;mandatory&gt;false&lt;/mandatory&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;index enabled="true"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tokenised&gt;TRUE&lt;/tokenised&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;facetable&gt;false&lt;/facetable&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/index&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;constraints&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;constraint name="premsa:LENGTH_d32b06e3-d845-4337-83be-9dc616d49f20" type="LENGTH"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter name="maxLength"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;500&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter name="minLength"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;1&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/constraint&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/constraints&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;....</P></BLOCKQUOTE><P>First I've tried to perform the search in Alfresco Share with simple and advanced searches but they find no documents.</P><P></P><P>I'm able to perform transactional queries in CMIS like this one and I get 1 document:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>SELECT * FROM premsa:Noticia where premsa:AP_TITOL='Llach treu una nova novel· la'</P></BLOCKQUOTE><P>But I'm unable to find this document using FTS queries in CMIS, for example:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>SELECT * FROM premsa:Noticia where contains('\'Llach\'')</P><P>SELECT * FROM premsa:Noticia where contains('premsa:AP_TITOL:\'Llach\'')</P></BLOCKQUOTE><P>In SOLR, I've enabled the log level org.solr.client.AbstractQParser to DEBUG. And I see the following in the SOLR log corresponding to the last FTS query:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>2019-03-27 08:15:51.162 DEBUG (qtp1528637575-17) [&nbsp;&nbsp; x:alfresco] o.a.s.q.AbstractQParser AFTS QP query as lucene:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +(TYPE:{http://www.ccma.cat/model/arxiuPremsa/1.0}Noticia) +(_dummy_:Llach text@s__lt@{http://www.ccma.cat/model/arxiuPremsa/1.0}AP_TITOL:{ca}llach)^1000.0</P></BLOCKQUOTE><P>If I perform this Lucene search against SOLR, it retrieves more than 10 results.</P><P>Why I'm not seing this results in Alfresco?</P><P></P><P>Thanks,</P><P>Jordi.</P></BODY></HTML> Wed, 27 Mar 2019 09:28:00 GMT easy_bd_infra 2019-03-27T09:28:00Z How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64179#M21882 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":&lt;model xmlns="http://www.alfresco.org/model/dictionary/1.0" name="premsa:ArxiuPremsa"&gt;&nbsp;&nbsp; ...&nbsp;&nbsp;&nbsp; &amp;l Wed, 27 Mar 2019 09:28:00 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64179#M21882 easy_bd_infra 2019-03-27T09:28:00Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64180#M21883 <HTML><HEAD></HEAD><BODY><P>Probably the results are different because SOLR is not considering permissions.</P></BODY></HTML> Wed, 27 Mar 2019 10:20:16 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64180#M21883 angelborroy 2019-03-27T10:20:16Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64181#M21884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm connecting with the "admin" user.</P><P>The document, has the following permissions:</P><UL><LI>inherited: Everyone=Consumer</LI><LI>has no locally set permissions</LI></UL></BODY></HTML> Wed, 27 Mar 2019 11:07:19 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64181#M21884 easy_bd_infra 2019-03-27T11:07:19Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64182#M21885 <HTML><HEAD></HEAD><BODY><P>As I said, SOLR is not considering permissions.</P></BODY></HTML> Wed, 27 Mar 2019 12:11:37 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64182#M21885 angelborroy 2019-03-27T12:11:37Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64183#M21886 <HTML><HEAD></HEAD><BODY><P>Hi Angel,</P><P>I don't understand your response.</P><P>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?</P><P>Jordi.</P></BODY></HTML> Thu, 28 Mar 2019 07:40:20 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64183#M21886 easy_bd_infra 2019-03-28T07:40:20Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64184#M21887 <HTML><HEAD></HEAD><BODY><P>If I understood right...</P><P></P><P>You get 1 result when using Search APIs (CMIS / FTS)</P><P>You get 10 results when querying directly SOLR</P><P></P><P>What makes sense, as SOLR does not check permissions and returns all the results in Alfresco Repository.</P><P></P><P>Am I missing something?</P></BODY></HTML> Thu, 28 Mar 2019 08:59:15 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64184#M21887 angelborroy 2019-03-28T08:59:15Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64185#M21888 <HTML><HEAD></HEAD><BODY><P>Not exactly.</P><P></P><P>This is the situation:</P><P>I have 1 document with AP_TITOL = "Llach treu una nova novel· la". User "admin" can see it (from Alfresco Share).</P><P>When querying SOLR directly, this document is in the list.</P><P>But when user "admin" queries by CMIS with CONTAINS no document is returned.</P><P></P><P>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.</P><P></P><P>Other facts:</P><P>If "admin" performs a CMIS relational query (without CONTAINS), the document is returned.</P><P>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!!</P><P></P><P>Jordi.</P></BODY></HTML> Thu, 28 Mar 2019 13:21:20 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64185#M21888 easy_bd_infra 2019-03-28T13:21:20Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64186#M21889 <HTML><HEAD></HEAD><BODY><P>Did you follow Step 3 (cross-language) to configure your SOLR 6?</P><P></P><P><A class="link-titled" href="https://docs.alfresco.com/search-community/tasks/solr6-install-withoutSSL.html" title="https://docs.alfresco.com/search-community/tasks/solr6-install-withoutSSL.html" rel="nofollow noopener noreferrer">Installing and configuring Search Services without SSL | Alfresco Documentation</A>&nbsp;</P></BODY></HTML> Thu, 28 Mar 2019 14:38:30 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64186#M21889 angelborroy 2019-03-28T14:38:30Z Re: How to make FTS queries on custom type on Alfresco 6? https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64187#M21890 <HTML><HEAD></HEAD><BODY><P>You were right.</P><P>After enabling cross-language in solr, restarting servers and reindexing documents, I'm able to find the documents with CMIS AFS.</P><P></P><P>Thank you Angel!</P></BODY></HTML> Tue, 02 Apr 2019 13:48:11 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-make-fts-queries-on-custom-type-on-alfresco-6/m-p/64187#M21890 easy_bd_infra 2019-04-02T13:48:11Z