Hi Bal, I suggest to use a table input step in conjunction with a stream lookup step and you will have the flexibility you want.
Regards Francois From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Baljinder S. Samrai Sent: Wednesday, November 6, 2013 1:58 PM To: [email protected] Subject: Atrium Integrator Spoon Question ** Hoping someone has done this before. It should be a common query in my opinion. In a database lookup step, I need to query only CIs where (MarkAsDeleted="No") OR (MarkAsDeleted is null) The answer may be simple, but, I'm just not seeing it. I don't see a way of doing an OR in the database lookup step. Any help would be appreciated. ---bal samrai __________ Information from ESET Mail Security, version of virus signature database 9012 (20131106) __________ The message was checked by ESET Mail Security. http://www.eset.com _ARSlist: "Where the Answers Are" and have been for 20 years_ ________________________________ Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)86 208 0237 | Midridge Office Estate, International Business Gateway, cnr New Road & Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
