Hi I want to transfer only sites which are enabled and have been created in the last 24 hrs to be transfered from SIT:Site form to a table in External database (oracle). I have defined the below query in the data query section of the AR form data mapping but transfers all records. $Status$="Enabled" and $SubmitDate$ >= $TIMESTAMP$-8460. On enabling the SQL logs it still shows no query defined and transfer all records. I have below questions 1) Is possible to put a criteria on the data exchange happening from AR System to External DB 2) If its possible then do I need to build the query using some special syntax Environment. ARS 7.6.03 CMDB 7.6.03 ITSM 7.6.03 DB - Oracle 10g AIE -7.6.03 OS - Windows 2008
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
