Try something like this: Criteria crit = new Criteria(); crit.addJoin(RULE_APP_MAPPeer.RULE_SEQ, RULEPeer.RULE_SEQ); crit.addAscendingOrderBy(RULEPeer.RULE_GROUP_ID); crit.add(RULE_APP_MAPPeer.APP_SEQ, 1000); Criteria.Criterion a = crit.getNewCriterion(RULEPeer.RULE_NAME, '%Ano%', Criteria.LIKE); Criteria.Criterion b = crit.getNewCriterion(RULEPeer.RULE_ID, '%101', Criteria.LIKE); crit(a.or(b));
Tom -----Original Message----- From: dandamudi sudhakar [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:51 PM To: [EMAIL PROTECTED] Subject: db2 and criteria Hi I need a query something like the one following using crietria obj. SELECT RULE.RULE_SEQ, RULE.RULE_ID, RULE.RULE_NAME, RULE.RULE_DESC, RULE.TERMS_USED, RULE.FACTS_USED, RULE.RULE_GROUP_ID, RULE.STATUS_ID, RULE.USER_ID_CREATED, RULE.DATE_CREATED, RULE.USER_ID_UPDATED, RULE.DATE_UPDATED, RULE.RULE_GROUP_SEQ, UPPER(RULE.RULE_GROUP_ID) FROM RULE, RULE_APP_MAP WHERE RULE_APP_MAP.APP_SEQ=1000 AND (RULE.RULE_NAME LIKE '%Ano%' OR RULE.RULE_ID LIKE '%101%' ) AND RULE_APP_MAP.RULE_SEQ=RULE.RULE_SEQ ORDER BY UPPER(RULE.RULE_GROUP_ID) ASC I am not getting any idea how to do that. Can any body help me Thanks Sudhakar Dandamudi _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
