OnDemand Users Group

Support Forums => ODWEK, Java and REST APIs => Topic started by: Karthikkumark on November 26, 2013, 02:05:36 PM

Title: How to set multiple AND / OR operator in odwek.
Post by: Karthikkumark on November 26, 2013, 02:05:36 PM
Hi All,

We are using this query to fetch the docuemnt from the Oracle DB.

SELECT      *
FROM       DOCTABA
WHERE       F_DOCCLASSNUMBER in ('1','19')

AND
       A31  =    ?060427090?     

AND
       A120 =    ?ab?       

OR   
       A119 =    ?Q?

Now we need to get the same result when we search in CMOD using ODWEK.
When i tried i found only following code "odFolder.setOrSearchCriteria(false)".  I think this will set AND / OR for entire criteria not for the individual criteria.

Thanks,
Karthik k
Title: Re: How to set multiple AND / OR operator in odwek.
Post by: pankaj.puranik on November 26, 2013, 03:54:50 PM
See this post on a similar topic.

http://ODUG.net/index.php?topic=963.0