Brien,

Let me see if I can explain.  When you are trying to set the field to a 
"Static" value, then the CONDITIONS that you're trying to use in the action are 
not really used because they're irrelavent to the value that you're setting; 
it's basically like using a SET FIELDS action on the CURRENT FORM.  Your second 
scenario actually has a value that DEPENDS on the conditions, so it works as 
expected.  

Now that you have a value in that field (any value will do), then you know if 
that value in that field is !=$NULL$ then you have a unique record for your 
search.

Good luck,
Gp

George Payne
Corporate Applications Developer
Electric Reliability Council of Texas
(512) 248-3940
gpa...@ercot.com
________________________________________
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On 
Behalf Of Brien Dieterle [brien.diete...@cgcmail.maricopa.edu]
Sent: Thursday, October 28, 2010 7:58 PM
To: arslist@ARSLIST.ORG
Subject: set fields behavior if no requests match  filter

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"

Reply via email to