topic Re: fts-alfresco search multi value property in Alfresco Archive

fts-alfresco search multi value property

raaftjon — Mon, 10 Jun 2013 17:00:19 GMT

helloI have a own alfresco model type with a multi value property like this: <type name="test:document"> <title>Test Dokument</title> <description>Ein test Dokument</description> <parent>cm:content</parent> <property name="test:values">

Re: fts-alfresco search multi value property

mitpatoliya — Mon, 10 Jun 2013 17:30:39 GMT

I think you need to change language as "lucene"

Re: fts-alfresco search multi value property

raaftjon — Tue, 11 Jun 2013 08:00:32 GMT

I have also test with lucene. But the queries doesn't work:
<javascript>
query: 'TYPE:"test:document" and @test\\:values:[1,2,5]'
query: 'TYPE:"test:document" and @test\\:values1 2 5)' // lucene field grouping
query: 'TYPE:"test:document" and @test\\:values in (1,2,5))' // like sql
query: 'TYPE:"test:document" and @test\\:values:1 and @test\\:values:2 and @test\\:values:5',
</javascript>

A other approach is the useing of a simple text field (d:text) and store all int values comma separated into the text field:
e.g. 'v2v,v3v,v5v'

then I can call the following query:
<javascript>
query: 'TYPE:"test:document" and @test\\:textFieldValues"*v2v*" "*v3v*" "*v5v*")'
</javascript>

This is not pretty, but it works! Has everybody a idee, how to use multi value property in a query?

Re: fts-alfresco search multi value property

avyaznikov — Thu, 13 Jun 2013 14:13:00 GMT

Use disjunction:


var arrayOfValues = [1, 2, 5];
var query = "";
for (var i in arrayOfValues) {
  if (i > 0) {
    query += " OR ";
  }
  query += "@test:values:" + arrayOfValues;
}
‍‍‍‍‍‍‍‍‍‍

The resulting string is
<blockcode>@test:values:1 OR @test:values:2 OR @test:values:5</blockcode>

*if you are using lucene - escape colon with backsplashes