Sorry, you are correct, it's being set with static text. I'll try a value from the form <hanging my head in shame!>
That should work correct? Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, November 08, 2010 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: set fields behavior if no requests match filter And the "another field" is being set with a value from the form like requestid (and not static text)? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of lisakemes Sent: Monday, November 08, 2010 4:14 PM To: arslist@ARSLIST.ORG Subject: Re: set fields behavior if no requests match filter I'm having a hard time even getting to stage one where you are looking for a duplicate value on the same field on the same form. When I create my Filter, I have one Action as well - Set Fields. The Server Name is the correct server name, and the Read Value for Field From is my Form A. I do a Set Field If: 'requestid' != $requestid$ AND 'Field 1' = $Field 1$ AND 'Field 1' != $NULL$, then set another field (like your nonUnique field) to something, save the filter and the Server Name and Read Value for Field From options go back to CURRENT TRANSACTION. It sounds like we are doing the exact same thing, not sure why I can't even get to the stage to at least get my filter to run. I thought you can read a value from the same form. Lisa ARS 7.1 Windows 2003 Oracle 10g AR WUT 7.5 Brien Dieterle wrote: > > Is it normal for a set fields operation, which is set to "Set Fields > to $NULL$" if no records match, to actually set the fields anyway if > no records match? I didn't think so. Here is the scenario: > > I have Form A with a 'Field 1' character field and a 'NotUnique' > character field. I want a set fields operation to, on modify, check to > see if there are any other records in Form A that have the same value > as 'Field 1'. I know this is a great case for a unique index, but > lets just assume that isn't an option. > > So my Filter executes on modify and has one action- set fields. It > uses the Data Source of Server and Form A as the source. The > qualification is something like this: 'requestid' != $requestid$ AND > 'Field 1' = $Field 1$ AND 'Field 1' != $NULL$. In this way I don't > care if there are Nulls that "match", just actual values, and I > prevent matching my own record. > > If no requests match: set fields to $Null$ if multiple requests match: > use first matching request Set Field: NotUnique = "True" > > So what happens is NotUnique is set to "True" ALL the time, no matter > what. Very, very strange. Here is the kicker: If I change the Set > Field to: > > Set Field: NotUnique = $Request ID$ > > THEN, it works exactly as expected. For duplicate records NotUnique > contains the Request ID of the offending record. If there is no > duplicate, it is null. My guess is it is still broken and trying to > set the field despite no matches, but since there really isn't any > value to get, it sets it to null. Whereas, in the former case I am > using a static string "True" instead of a field name. > > 7.5 patch 1 > > Brien _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"