Hi Marco,
I experienced a similar thing under version 6.3 (multiple patch levels).
Under an Active Link, LASTCOUNT always returned the result I'd expect, but
under a Filter sometimes I would get the number I'd expected, while other times
I'd get a seemingly random number. The odd thing was that I could execute the
same Filter on the same search several times in a row, and it would alternate
between the correct number and an incorrect one.
After digging in the server logs, it turned out that when LASTCOUNT was
expanded from a Filter, the number expanded was whatever the count was from the
last search performed from any Filter on the server. If the last search
happened to be performed by the Filter that I was testing, I'd get the correct
result. If the last search happened to be a search performed from an unrelated
Filter, I'd get an incorrect result.
A workaround I ended up using was to do a set fields, where the value being set
was obtained from SQL similar to the following:
SELECT COUNT(Case_ID_)
FROM HPD_HelpDesk
WHERE Status=2
Eric Cleereman
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
Behalf Of Marco Rasile
Sent: Wednesday, December 20, 2006 2:12 PM
To: arslist@ARSLIST.ORG
Subject: Different result from Set Field If and User Tool Query
**
Good Afternoon Listers,
I have an issue that I've never come across before. I am using the following
Set Field If Qualification in a Filter:
((( 'Task Status' != "Completed") AND ( 'Task Status' != "Cancelled") AND (
'Task Status' != "Not Required")) OR ( $zTmp_ForceNewTaskCreation$ = "Yes"))
AND ( 'Project Number' = $Project Number$) AND ( 'InFlow' = "Yes")
However, it is returning a LASTCOUNT of 10 when triggered in the Filter, which
is not the result we were expecting. We were expecting 1 returned result. So
to test it, we put this in the User Tool Advanced Search and got the expected 1
returned record. Why would the results differ? Has anyone ever seen this
before?
Regards,
Marco Rasile
Manager - Applications Development (IP Garage)
Bell Canada
220 Simcoe Street
Toronto, ON, M5T 1T4
Home Office: 905-826-5082
Office: 416-353-1902
Fax: 416-260-9839
[EMAIL PROTECTED]
__20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
