Searching multiple main tables in MDM with Java API

[Former Member]

Hi All,

I have two main tables in MDM system, say Table 1 and Table 2. Some of the fields in Table 1 and Table 2 are common. Say Column 1 is the field which is common in both the tables.

In the Webdynpro view, I have a search functionality. Here the user enters desired value for Column 1 and I need the results from both Table 1 and Table 2 in the result set whose Column 1 matches the entered value.

Is there any MDM Java API which will help me achieve this ?

Appreciate all the help !!!

Thanks and Regards,

Sayan Ghosh

[Former Member · Accepted solution]

One way to implement is doing multiple searches i.e

Search1 goes against Table1 and retrieves the matched records from Table1

Search2 goes against Table2 and retrieves the matched records from Table2

Merge both the result sets and display in webdynpro table.

Sample code for search against MDM using MDM java API

FieldId ffFieldId = reposSchema.getFieldId("Products",

"Item_Name");

SearchDimension sd_3 = new FieldSearchDimension(ffFieldId);

SearchConstraint sc_3 = new TextSearchConstraint("p",

TextSearchConstraint.CONTAINS);

search.addSearchItem(sd_3, sc_3);

Refer is MDM Java API Developer Guide for more coding samples.

Also if your problem is not solved move the thread to Master Data Management to get more help as is specific to MDM than Webdynpro Java.

Hope that helps.