Hi,
If you use $-signs, you are typically referencing your current
transaction, not columns in the database.
I think your query should read:
'Status'="Enabled" AND 'SubmitDate' >= $TIMESTAMP$-24*60*60
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
