How to add multiple collections in IDfQuery Builder using addPartitionScope()

baptu

Hi,

We are using DFC 6.7 sp1 and trying to add multiple collections using addPartitionScope() method of IDfQuery Builder. But generated native query is coming up like this -

et $libs := collection('/docbase/dsearch/Data/Collection1', '/docbase/dsearch/Data/Collection2', '/docbase/dsearch/Data/Collection3', '/docbase/dsearch/Data/Collection4', '/docbase/dsearch/Data/Collection5')

But we need to get it like this -

et $libs := (collection('/docbase/dsearch/Data/Collection1'),collection( '/docbase/dsearch/Data/Collection2'),collection( '/docbase/dsearch/Data/Collection3'), collection('/docbase/dsearch/Data/Collection4'),collection( '/docbase/dsearch/Data/Collection5'))

our code is like this -

for(int index = 0; index < CollectionNames.getCount(); index++)
{

   qb.addPartitionScope(getDfSession().getDocbaseName(), CollectionNames.getString(index));     
}

How to add multiple ones.. please suggest.

Thanks in advance.

jkumar4689

You do not have to specify the multiple instances in the query

Change the xquery :

et $libs: collection("docbase/dsearch/Data")

This query will search for the results in all the collections.

Add the following property.

dfc.search.xquery.option.enable_parallel_execution -true in dfc.properties

This will execute the query parallely in all the collections.