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"
