topic Re: Advanced search on custom model properties has no results in Alfresco Forum

Advanced search on custom model properties has no results

dscheffer — Thu, 05 Sep 2019 13:16:25 GMT

Hi everyone,I am really at a loss here and could not find a solution to my problem here in the forums even though it seems others may have had similar problems.I am running an Alfresco 6.1.2 stack including alfresco-search-services 1.3.0.1 in a dockerized environment. I really want to use records ma

Re: Advanced search on custom model properties has no results

calvo — Fri, 06 Sep 2019 08:11:51 GMT

Hi,

In my case, running Alfresco 5.2, I had to re-generate Solr indexes, but I'm in doubt because -as you say- NodeBrowser return results.

I guess there are no errors in your log files, right?.

Regards,

clv

Re: Advanced search on custom model properties has no results

dscheffer — Fri, 06 Sep 2019 08:24:39 GMT

Hi,

the logs to the standard output the containers produce do not show anything noteworthy as far as I can tell. But I have to admit that the default logging level does not result in a huge amount of logs. I already tried turning the solr logging level up and could not find anything that hints in the direction of my problem. I guess, I will try to turn up the logging level of share and the repository service and see if I can find something there.

Thanks for your input.

Kind regards,

Dennis

Re: Advanced search on custom model properties has no results

abhinavmishra14 — Fri, 06 Sep 2019 12:54:28 GMT

It should work, as the indexes for each property is by default enabled. Not sure if the documents which has custom properties are indexed or not. See if you can do a quick search for those documents based on name, tile etc.

A quick trick could be, to update any of the properties e.g. title, description etc and save the document. It will retry to index again. And then try to search in advance search again after a gap.

If it is still not working then try and do a full re-index if you do not have much content.

Also, Can you try to update and re-deploy your content model by adding index config. and see if it works ?

Please add/update this log config: log4j.logger.org.alfresco.repo.jscript.ScriptLogger=debug

To see if you can find any logs when you hit search.

Your updated content model:

<types>
          <type name="my:invoice">
               <title>Base invoice type</title>
               <parent>cm:content</parent>
               <properties>
                    <property name="my:invoiceNumber">
                         <title>Invoice Number</title>
                         <type>d:text</type>
                         <multiple>true</multiple>
						 <index enabled="true">
						   <tokenised>false</tokenised>
						 </index>
                    </property>
               </properties>
               <mandatory-aspects>
                    <aspect>cm:taggable</aspect>
               </mandatory-aspects>
          </type>
          <type name="my:customerInvoice">
               <title>Customer invoice type</title>
               <parent>my:invoice</parent>
               <properties>
                    <property name="my:customerName">
                         <title>Customer Name</title>
                         <type>d:text</type>
						 <index enabled="true">
						   <tokenised>both</tokenised>
						 </index>
                    </property>
                    <property name="my:customerNumber">
                         <title>Customer Number</title>
                         <type>d:text</type>
						 <index enabled="true">
						   <tokenised>false</tokenised>
						 </index>
                    </property>
                    <property name="my:journeyCpvNumber">
                         <title>Journey CPV Number</title>
                         <type>d:text</type>
                         <multiple>true</multiple>
						 <index enabled="true">
						   <tokenised>false</tokenised>
						 </index>
                    </property>
               </properties>
          </type>
          <type name="my:serviceProviderInvoice">
               <title>Service provider invoice type</title>
               <parent>my:invoice</parent>
               <properties>
                    <property name="my:serviceProviderName">
                         <title>Customer Name</title>
                         <type>d:text</type>
                         <multiple>true</multiple>
						 <index enabled="true">
						   <tokenised>false</tokenised>
						 </index>
                    </property>
                    <property name="my:serviceProviderString">
                         <title>Customer Number</title>
                         <type>d:text</type>
                         <multiple>true</multiple>
						 <index enabled="true">
						   <tokenised>false</tokenised>
						 </index>
                    </property>
               </properties>
          </type>
     </types>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Advanced search on custom model properties has no results

dscheffer — Fri, 06 Sep 2019 13:13:15 GMT

Hi,

thanks for your reply. This change is apparently not incremental which makes things a little tricky. But I will try it anyway. Just so I understand your fix better: Why would explicitly enabling indexing be necessary? The documentation states that when no <index>-Tag is defined on a property, the following default is assumed:

<index enabled="true">
   <atomic>true</atomic>
   <stored>false</stored>
   <tokenised>true</tokenised>
</index>

Is the documentation wrong or am I just misunderstanding things? See: https://docs.alfresco.com/6.1/references/dev-extension-points-content-model-define-and-deploy.html

Kind regards,

Dennis

Re: Advanced search on custom model properties has no results

abhinavmishra14 — Fri, 06 Sep 2019 13:24:42 GMT

Yes, Documentation is correct. You don't have to explicitly enable it. You can see i have set the tokenised value to false which is default true.

Re: Advanced search on custom model properties has no results

dscheffer — Fri, 06 Sep 2019 13:36:22 GMT

Thank you so much! I have no idea why but setting tokenized to "false" did the trick.

Re: Advanced search on custom model properties has no results

abhinavmishra14 — Fri, 06 Sep 2019 13:50:42 GMT

It could be possible that the values you are using are getting tokenized and when you are searching it expects the values to be provided as tokens. When you set the tokenised to both then it works for both cases. When tokenised is set to true then it tries to index the values as tokens based on space, special chars and punctuation etc. Enabling the debug logs would show what values are being sent in the query so you can identify the problem in a better way.

This is what the docs days:

Solr/Lucene index configuration. The indexing behaviour of each property can be configured. If we do not configure any indexing behaviour then the default configuration is:

<index enabled="true">   <atomic>true</atomic>   <stored>false</stored>   <tokenised>true</tokenised></index>

This basically means that the default index configuration for properties is as follows:

Index the value of the property (enabled="true")
Atomic is not used when Alfresco Content Services uses Solr for search. The default value is there to allow the continued use of the built in Lucene indexing engine when customers do not want to or cannot switch to Solr. With Solr the index is eventually up-to-date with the database.
The property value is not stored in the index (<stored>false</stored>). This property is not used with Solr either, all fields are store in the new cached content store on the Solr side.
The property value is tokenized when it is indexed (<tokenized>true</tokenized>), so if the value is "Company Confidential" it will be tokenized into two strings that will be indexed separately, which might not always be what you want. You can also use false, which will just tokenize the value as one item. Further on, it also possible to set it to both, which means that "Company Confidential", "Company", and "Confidential" will be in the index.