topic Lucene query with extact phase? in Alfresco Archive

Lucene query with extact phase?

spilby — Mon, 16 Jun 2014 15:48:59 GMT

I want to find with Lucene a node with a property. Exactly with this text. I'm using Alfresco 4.2 and the Alfresco Java API.For example, imagine I have in Alfresco 2 nodes with my velocity_number property. One with the value "A B" and the other with the value "A B C".On my webscript, I do thisearc

Re: Lucene query with extact phase?

kaynezhang — Tue, 17 Jun 2014 02:44:30 GMT

How did you configure indexing behaviour in your model definition?
You should set

 Tokenised="both"‍

 Tokenised="false"‍

in your property index config, then "=" character query will work.like below



           <property name="own:velocity_number">
              <type>d:content</type>
              <mandatory>false</mandatory>
              <index enabled="true">
                 <atomic>false</atomic>
                 <stored>false</stored>
                 <tokenised>both</tokenised>
              </index>
           </property>
‍‍‍‍‍‍‍‍‍‍‍‍

The difference among "true","both","false" is :
If "true", the string value of the property is tokenized before indexing
if "false", it is indexed "as is" as a single string
if "both" then both forms above are in the index

So set it to "both" will be a good option.

Re: Lucene query with extact phase?

spilby — Tue, 17 Jun 2014 07:06:00 GMT

Yes, I have tokenised false. This is my xml, similar than your propose:


<property name="own:velocity_number">
<type>d:text</type>
<mandatory>true</mandatory>
<index enabled="true">
<atomic>false</atomic>
<stored>true</stored>
<tokenised>false</tokenised>
</index>
</property>
‍‍‍‍‍‍‍‍‍‍‍

But the = character not works. Don't find anything. (

For more info… If I do the same with the Node Browser of the Administration Console (with Lucene search) the same… 0 results. The character "=" only works for me if and find 1 result if I put the query on the Search combo on the Alfresco Explorer (advanced search).

Re: Lucene query with extact phase?

kaynezhang — Tue, 17 Jun 2014 16:18:16 GMT

Use character "=" you should use "fts-alfresco" language instead of lucene

Re: Lucene query with extact phase?

spilby — Wed, 18 Jun 2014 07:24:00 GMT

I thank use the webscript using Lucene. Some properties are indexing. But I can use sp.setLanguage(SearchService.LANGUAGE_FTS_ALFRESCO)? What may be the consequence if I use FTS-ALFRESCO instead of Lucene? Is the same? The same performance efficiency?

And using Lucene, what's the equivalence with the "="?

Re: Lucene query with extact phase?

kaynezhang — Wed, 18 Jun 2014 13:58:08 GMT

You still can use fts-alfresco language in javascript api ,just call it like this


 var def =
  {
     query: "=@own\:velocity_number:\"A B\"",
     language: "fts-alfresco"
  };
  var results = search.query(def); 
‍‍‍‍‍‍‍‍

As performance efficiency and consequence,I don't think it is a problem.In my opionion it is almost the same as lucene language.

Re: Lucene query with extact phase?

spilby — Fri, 27 Jun 2014 09:04:00 GMT

Thanks, with fts-alfresco works ok! It find my own property.

I only have a problem now with the query when I search by the alfresco uuid. I use this in the query:


   @sys\\:node-uuid:"6647a596-53e9-4676-adc4-a77d79487fdf";
‍‍‍

When I use Lucene, it works ok, but when I change to fts-alfresco, don't works. What's the equivalence in fts to search a node by uuid?

Note: I use a java backed webscript, not javascript.

Thanks again!

Re: Lucene query with extact phase?

kaynezhang — Fri, 27 Jun 2014 09:24:16 GMT

You can try to use ID as instead


 ID:workspace\://SpacesStore/ce55a850-b1c7-43c7-a600-b5c58a985429
‍‍‍

Re: Lucene query with extact phase?

spilby — Mon, 28 Jul 2014 07:14:00 GMT

Only one question more about indexing…

On my webscript, now I do this:


SearchParameters sp = new SearchParameters();
sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);
sp.setLanguage(SearchService.LANGUAGE_FTS_ALFRESCO);
sp.setQuery(query);
ResultSet results = getSearchService().query(myQuery);
‍‍‍‍‍‍‍

where myQuery is:


PATH: "//app:company_home/app:user_homes/cm:dir//." AND =@own\:velocity_number:"A B"
‍‍‍

We use SOLR. And the "own" property that I search is not indexed. But the query find me the result.

How is possible? We can find results that aren't indexed on SOLR? This indexation only affects the speed/performance of the query? Or maybe it depends if I use FTS-ALFRESCO or LUCENE?

Thanks again!

Re: Lucene query with extact phase?

kaynezhang — Mon, 28 Jul 2014 13:27:00 GMT

fts-alfresco query language is special.It can search in database or in index depends on configuration. By default it will search in db first,so you can find what is not indexed.

Re: Lucene query with extact phase?

spilby — Tue, 29 Jul 2014 05:43:00 GMT

Oh,ok. I think that I see the problem… In our desalModel.xml, all the properties that we added have the

<index enabled="true">‍

. SOLR use this desalModel, because of this, we can find those properties. I understand that we should only put enabled true on the properties that we want to find when use the searchService.query().

I use Alfresco share 4.2 with SOLR, and use fts-alfresco language on the query because I use the "=" to find exact results.

I want to be sure that when me call to searchService.query() with LANGUAGE_FTS_ALFRESCO I use the index and not the database, for a better performance and speed. In conclusion… If I put index enabled=true on the A property, and I use searchService.query() with LANGUAGE_FTS_ALFRESCO to find this A property, I will be use the index to search the property and not the database?

And if you know, for curiosity… What is LANGUAGE_SOLR_FTS_ALFRESCO? I must use it if I have SOLR?

Re: Lucene query with extact phase?

kaynezhang — Wed, 30 Jul 2014 03:39:26 GMT

1.In model definition , property is indexed by default ,so if you have not set enabled="false" explicitly ,it will be indexed.
2. Property definition has nothing do to with whether to search in index or search in db ,it is controlled by "solr.query.cmis.queryConsistency" parameter in alfresco-global.properties(if not exist,you can add it).If you set "solr.query.cmis.queryConsistency" to "EVENTUAL" ,it will search index first，but you run the risk of finding nothing.
3.Language SOLR_FTS_ALFRESCO has the same effect as language FTS_ALFRESCO in solr subystem.

Re: Lucene query with extact phase?

spilby — Mon, 04 Aug 2014 14:30:02 GMT

Oks! Perfect. Thank you very much!