Charlie, Run the same query you have in your Set Field If action from within the User tool against the form that you are using to pull information from.
Check to see if you are getting any results.. If you are getting multiple results, this is what I would suggest. Have a display only integer field that sets LASTCOUNT. On your query, set this field. If there are no results returned, your LASTCOUNT would be 0. If there is a single row, it should be 1 or if multiple, whatever the number of rows it is.. This would better achieve what you want to achieve.. My guess about the reason why you are getting the 'no match error' is that the ARS displays that on both if there are no matching entries, as well as if there are multiple records and you have it to display the multiple match error.. Cheers Joe From: Charlie Wilson Sent: Thursday, October 07, 2010 12:03 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Filter Set Fields If No Requests Match null ** ARS 7.5 p6 I am having trouble with a filter. Any tips would be greatly appreciated. 1. Filter fires, qualifies as expected. 2. If action, set fields, source=server/other form I am certain the record(s) do not exist on the source form. However, I get two different results when.. If No Request Match: Set Fields to $NULL$ If Multiple Request Match: Set Fields to $NULL$ The set filter action completes and the field is set to a value. This should not happen. It should be set to NULL. When I make this one change... If No Request Match: Display No Match Error If Multiple Requests Match: Display Multiple Match Error The "no match error" is raised. This helps confirm for me that the set fields action does not qualify. Does this sound like some type of bug? Or, do I not properly understand the "Set Fields to $NULL$"? It seems plain as day what should happen. Thanks, Charlie _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
