Skip to Content
0
Former Member
Jul 12, 2006 at 02:36 PM

MDM Java API: searches on multiple fields ,Query problem.

44 Views

Dear All,

I want to do a search on muliple fields in the MDM 'Products' table.The scenario may be like this:

FIND(Description,"dummytext") AND

FIND(Category,"dummycategoryname") AND

(FIND(Manufacturer,"dummymanufacturername") OR

FIND(Name,"dummyname"))

The problem is the inner query.How do i change the behaviour to 'OR' type.

I am using :

Search search = new Search("Products");

search.SetSearchType(Search.GlobalOrSearchCombinationType);

However this changes the default behaviour of the search object for the whole query.I want it to be limited to the inner query only.

I'll appreciate any help.

Thanks,

Karambir Singh.