Which operator can be used for NOT EXISTS function in BO

building reports webintelligence
1

Hi,

I’m new to Business Objects and I am trying to modify a report where i need to add one more condition to the existing SQL. But i don’t know which operator can be used to add that condition.
Below is the condition I want to use.

AND NOT EXISTS (SELECT ‘X’ FROM Table1
WHERE Table1.HEALTH_PROFESSIONAL =
‘Yes’ AND Table2.CASE_NMBR =
Table1.PR_ID);

Here table2 is mentioned in the main query.
Please someone help me with this!!!

Regards,
Kartik

krajuk :india: (BOB member since 2012-09-01)

2

Welcome to B:bob:B!

I’ll assume this is a WebI question and move it to that forum.

Nick Daniels :uk: (BOB member since 2002-08-15)