on 12-24-2014 8:29 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.