Multiple search criteria returns an AND result

[Former Member]

Hi,

In our production system, when searching for opportunities using the Employee Responsible criteria, we add multiple employee responsible to search.

Result: System returns zero opportunities (because it is considering AND condition)

In our QAS system, the same search will show me opportunities of all employee responsible entered at the same time e.g. if i searched for OPPS of employee 1, 2 & 3, it will show me opps of all 3 employees.

Any suggestions how this is controlled ?

Haseeb.

[Maggie]

Hello Hasseb,

Would you please check, is note 1658632 applied in your PROD system?

Best regards,

Maggie

[Former Member]

Hi Maggie,

I checked but it's not implemented and is also not valid for our release.

Haseeb.

[Former Member]

Another observation:

• Search Opps. with employee 1: shows 10 results
• Search opps. with employee 1 & 2: shows 5 results --> while employee 2 is not involved in any of those opportunities.

[Maggie]

Hi,

You can set a break point at class cl_crm_report_acc_dynamic method database_access to see how the result is fetched from DB. In parameter it_where, you will see the built search criteria. Then you can find how the search criteria is built by checking the call stack.

Best regards,

Maggie