Hi,
This requirement is achievable but not as you want. As per my understanding, there is an alternative to achieve this requirement that is explained below. Using MDM Java API You can achieve your requirement using some custom work.
As per your scenario, you are maintaining two main tables (e.g. Main_Table_A and Main_Table_B) and you want to fetch the data from both the table using some common search conditaions. As per the provided MDM Java functionalities, you cannot perform search on Lookup [Main Field].
To achieve it, you will have to maintain a common field in both the main tables e.g. Main_Table_A has fields a, b, c, d and Main_Table_B has a, e, f, g fields, where a is a common field in both the tables. As per my understanding your requirement is like this, you want to fetch the data of a, c, d, f, & g fields from Main_Table_A and Main_Table_B.
Steps:
1. Search the data from first main table on the basis of common fields and your desired search criteria and store it into a result-set object.
2. Search the data from second main table on the basis of common fields and your desired search criteria and store it into another result-set object.
3. Now, you can retrieve your selected fieldsu2019 data from these searched result-sets and display it on the portal. This is how you can achieve your requirement.
I know, this is little bit lengthy and tricky way but this is how you can achieve your requirement using MDM Java API.
Thanks/ -Tarun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.