How can I generate a NOT EXISTS query in BO. I am currently using the subquery relational option in order to generate a NOT IN nevertheless this is not good enough regarding response time in Oracle. I am therefore thinking to use NOT EXISTS instead but I can not find a way of creating such a query the only way I have found is to overwrite the SQL.
Thanks
L
lion (BOB member since 2004-01-12)
BusObj doesn’t support that operation directly in the query panel, as you have found out. However, you can put anything that is legal in your RDBMS’s SQL language in a pre-defined condition in Designer. So if your condition is something that is used frequently, you would be best served going that route. You could include a prompt to make it more flexible, or hard-code the condition if desired.
Even if it isn’t used frequently, you can still accomplish the task that way. AFAIK, there is no way to do it in the query panel.
Dave Rathbun 
(BOB member since 2002-06-06)
I created a report using NOT EXISTS syntax with the help of this BOB topic
majaf 
(BOB member since 2002-11-19)