cancel
Showing results for 
Search instead for 
Did you mean: 

How to query two different BO and display the data in OWL

0 Kudos

Hello Colleague,

In one of my requirement I need to query two different BO and display the data in OWL result screen . Using the standard OWL component i can bind query of only BO search query . I need to search first BO based on the some of search criteria and then query another BO with the result list obtained in first query and using remaining search parameter .

For example

In OWL screen we will have the following search parameter .

   i  First Name

   ii Last Name

   iii Relationship Attribute

When user enters all the search parameter and clicks "Go" the following logic should be executed.

   i. Query Business Partner BO and get all contacts matching the First Name and Last Name criteria.

   ii. Now query the second BO(custom one)  passing the search result found in step i. above and Relationship Attribute  search criteria  provided to get the final match list and display the contact and their relationship attribute information.

Thanks in advance.

With regards,

Saurabh Kumar Pandey.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Saurabh,

could you please be a bit more precise about the relationship between the BOs? Esp: are there associations between the BOs?

If there is an association between the two BOs you can create a custom query which could solve your issue.

Best regards,

Ludger

HorstSchaude
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Saurabh,

As the on BO is the SAP BO BusinessPartner and the other one is a customer BO I assume that the custom BO is a kind of enhancement of the SAP BO and will refer to the resp. BusinessPartner via the same ID (or any other key)

Therefore Ludgers argument makes the key:

You can define an association 1:1 from the custom BO to the BusinessPartner and build your query on arguments which are accessble via this association.

You will only get hits if the BusinessPartnwer instance meets the search criteria.

HTH,

    Horst