MDM Java API 2 - setResultTablePath

[Former Member]

Result Table path must be defined when the result table is different than the search table.

How to use <b>setResultTablePath(Field[])</b> method of class RetrieveLimitedRecordsCommand

My search table is Products

My Result table is different.

How to use the above method? Any code snippet is appreciated.

[Former Member · Accepted solution]

Hi Adhappan,

Here's a simple example. (it's not code but it should allow you to understand)

search table is Products (this is also the main table)

it has a field called Manfucturer (lookup flat field to Manufacturers table)

result table is Manufacturers (a flat table)

Let's say you want all Manufacturers of Products meeting certain search criteria e.g. name contains "abc".

The FieldId array needs to contain the FieldId of the Manufacturer lookup field.

This is because it points to the table from which you want to return the results.

Hope this helps,

Richard

[Former Member · Accepted solution]

Thank You...