Thanks Eric, I found the problem. I got fooled by running it on a Join Form with differing Field IDs, thus I got the 'zTmp_ForceNewTaskCreation' and $ zTmp_ForceNewTaskCreation$ mixed up.
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] ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cleereman (IT) Sent: December 20, 2006 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Different result from Set Field If and User Tool Query 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___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
