AND and OR search criteria.

[pankaj.puranik]

I see that it is possible to use either AND or OR condition.
I have a case where I want to do a search as 'Brand = XYZ AND account number = 2345 OR hhNumber = 678.

Is it not possible to do it in one go? Or I would have to break the query into two and then merge the results?

Thanks
Pankaj.

[Alessandro Perucchi]

Hello Pankaj,

Well if you use the method ODFolder.setOrSearchCriteria(boolean), then the whole search criteria will be either

A AND B AND C AND ...

or

A OR B OR C OR ...

with ODFolder.search().

If you want to do something more complex than "everything AND" or "everything OR", then you will need to use the method

ODFolder.search(String), ODFolder.search(String,  ODCallback), ODFolder.search(String, String, String), ODFolder.search(String, String, String, ODCallback), ODFolder.seach(String, String, String, String) or ODFolder.search(String, String, String, String, ODFallback), then you can do anything you want with SQL queries.

Hope that helps a bit :-)

Sincerely yours,
Alessandro

[jfunk]

Good day,

It depends on whether each of the columns is an individual index or not.  If hhNumber is an index and either Brand or account number is an index, then you may want to break this up with a UNION clause.  That is because in DB2 one of two conditions can occur.  The first is index nullification, i.e. table space scan.  The second is a multi-index join.  The first is not palitable while the second may not be.  I would test this first with SQL separate from OnDemand determining what occurs and the performance.  If the UNION is faster, then using the Keyboard option, inject the query using the UNION.

Jeff