You nailed it Carey! Thank you!!! Now off to the ER to have my forehead bandaged. :P
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, June 30, 2008 10:03 AM To: [email protected] Subject: Re: OT: ACD Integration Brian, Just a guess.... In the User tool, turn on Active Link logs. You likely have workflow that is setting additional fields with some value on "Query". -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Mon, Jun 30, 2008 at 12:44 PM, Brian Gillock <[EMAIL PROTECTED]> wrote: > ** > > Hey List, > > We are working on an integration with Apropos 6.5.1. In our > script that pops the incident form and performs a query, we are getting > extra qualifications in it. The query we are passing is 'Incident*+ = > "INC000000000003" which as the API docs state works in the advanced search > bar. The function we are using is > > > > Set EntryList = ARForm.Query(query) > > > > When I view the SQL logs, it is actually querying as follows: > > SELECT > T983.C1,C1000000161,C1000000000,C7,C1000000164,C1000000169,C1000000018,C1000 000019,C1000000082,C1000000560,C1000003009,C1000000869,C1000000217,C10000002 18 > FROM T983 WHERE ((T983.C1000000161 = 'INC000000000003') AND (T983.C301788500 > = 'SYS:SLM:EventSchedule_Clone') AND (T983.C301610100 = > 'SYS:SLM:Measurement_Clone') AND (T983.C1000000161 = 'INC000000000003')) > ORDER BY 2 DESC, 1 ASC > > > > > > Which is causing a type mismatch error, can't search text in a varchar. > When I remove the extra qualification and run the query from the SQL console > it works. Can someone tell me why it's adding.. > > AND (T983.C301788500 = 'SYS:SLM:EventSchedule_Clone') AND (T983.C301610100 = > 'SYS:SLM:Measurement_Clone') AND (T983.C1000000161 = 'INC000000000003')) > ORDER BY 2 DESC, 1 ASC > > > > > > Windows Server 2003 > > SQL Server 2005 > > ARS 7.1 patch 2 > > ARUser 7.1 > > > > > > Thank you! > > Brian ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
