Skip to Content
0
Dec 13, 2011 at 12:40 PM

Dynamic Order Query - search by Business partner

42 Views

Hi experts,

I have a general question regarding dynamic search for orders.

I try it to explain.I'd like to search orders by businesspartners (example 'assigned_to' and 'customer')

If I search only for assigned_to, everthing works fine.

(During the runtime the selection paramter will be extend in preprocess methods to parter + partner function)

If I add a new parameter for example customer it will extend again to partner + partner function.

The result is not what I expected, because (I assume) that the query create statment was build in this way partner in (....) and partner_function in ( ...). I'd like to get results where assigned partner = '12' AND customer = '23'. In this case I got assigned partner = '12' OR customer = '23'

Any ideas, how I can solve this.?

Thansk in advance

Paul