Hi,
Strange that they changed this convention...
In other places, such as in a filter/actl set-/push-fields search, you can
also select fields. You can choose both the $-fields and '-fields. The
$-fields is just fixed data, and the '-fields represents columns in the
database.
For example ('Submitter' = $USER$) would translate to something like
('Submitter' = "miz") if I am logged in.
And ($Submitter$ = $USER$) will be something completely different, ("miz"
= "miz") if my name is in the current records Submitter-field.
The latter will match everything in the database...
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 Misi
>
> This doesnt work either :-(, on the AIE data exchange there is an option
> to select AR form fields and the Syntax there comes as $field$
>
> Regards
> jaya
>
> From: Misi Mladoniczky <[email protected]>
> To: [email protected]
> Sent: Monday, November 28, 2011 12:43 PM
> Subject: Re: Limiting AIE data exchange
>
> 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"
>
> _______________________________________________________________________________
> 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"
