Skip to Content
0
Former Member
Sep 29, 2005 at 07:59 AM

java API :'OR' operator on lookup parameters not working in SP1

23 Views

Hi all,

We are using API version 5.5.15.09. (SP1) on MDM server SP1 as well.

We experience a problem when using java API:

when we create a search object and add lookup parameters on 2 fields with the 'OR' operator (GlobalOrSearchCombinationType), no result is returned.

The same code is working on String parameters

The code sample is:

Search search = new Search();

search.SetSearchTable("Products");

SearchParameters searchParam = search.GetParameters();

search.SetSearchType(Search.GlobalOrSearchCombinationType);

String fieldName1 = "GroupType1";

int recordID1 = 51;

LookupParameter lookupParam = searchParam.NewLookupParameter("Products",fieldName1);

lookupParam.Add(recordID1);

String fieldName2 = "GroupType2";

int recordID2 = 52;

LookupParameter lookupParam = searchParam.NewLookupParameter("Products",fieldName2);

lookupParam.Add(recordID2);

We expect to get all products belonging to GroupType1 OR GroupType2 but we get products belonging to GroupType1 AND GroupType2 which can be 0 product

thanks for your help

Nicolas