Hi Jaya,
I also faced issue in limiting data using the queries but I was trying to import in Remedy from external data source. It was simply failing for some query (I do not remember), then I tweaked the query and made it simpler, to my surprise it worked that way. What I would suggest here is first you check only with Status = Enabled and see if AIE is able to find differentiate between Enabled and Disabled Site. Next you try with only other part of query that is $SubmitDate$ >= $TIMESTAMP$-8460. This way you will be able to identify which Query AIE does not understand. In my case AIE was able to differentiate both queries independently but not when using together. If this is case with you also probably you need to differentiate records at Remedy form only using an escalation (an option). Thanks, Ashutosh Tripathi | Remedy Application Management Services DLF IT Park, 5th Block, 4th Floor, Manapakkam, Chennai- 600089 | India VOIP: 36164 | M: +91 98 84 72 08 90 mailto:ashutosh.tripa...@logica.com <mailto:name.surn...@logica.com> | http://www.logica.com/ <http://www.logica.com/> <http://www.logica.com/> Logica Pvt Ltd, registered in India (registered number U30007KA1998PTC023830) Registered Office: 124-125, Divyasree Technopolis, Yemlur P.O.,Off Airport Road, Bangalore 560037, India From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Monday, November 28, 2011 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: Limiting AIE data exchange ** looks there is some bug with AIE 7.6.03 version that its not considering the qualifaction for AIE data exchange. I have opened any issue with BMC but they have as usual collects logs and screenshot but have not been able to confirm if its a syntax issue or a product issue. Anyone else who has any experince of limiting data exchange in AIE using the data query on AR form Regards Jaya From: Misi Mladoniczky <m...@rrr.se> To: arslist@ARSLIST.ORG Sent: Monday, November 28, 2011 2:01 PM Subject: Re: Limiting AIE data exchange 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 <m...@rrr.se> > To: arslist@ARSLIST.ORG > 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 <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 <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 <http://www.arslist.org/> >> attend wwrug12 www.wwrug12.com <http://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" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ Think green - keep it on the screen. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
