Hi, I have two data providers.

[YashBadiani]

Hi,

I have two data providers.

I want to achieve 'not exists' functionality between them.

For ex :-

If i have two database tables A(C1,C2,C3),B(C2,C3).

Consider the following SQL query :

select * from A where not exists
(select * from B where B.C2=A.C2 and B.C3=A.C3)

I have two data providers(DP1 & DP2) say with the same definitions as for the two tables mentioned above.

Can i achieve the 'not exists' functionality between them in business objects?

Please let me know if this is feasible.

Thank You,
Yash

 

[blom0344]

As you are probably aware of, linking dataproviders is very much like a full outer join between the datasets. You can influence the full outer effect by using complex filters with IsNull logic, but that is the extend of the modification.

A correlated subquery with 'not exists' is altogether something different, using Boolean logic instead of join strategy.....
Don't think you can simulate this within BO reporter...

T. Blom
Information analyst
tbl@shimano-eu.com