**
I had basically the exact same question, search for "set fields
behavior if no requests match filter" to find it.
Don't do a push fields. Just do a set fields against your own form
but use a query like:
requestid' != $requestid$ AND $Prefix$ = 'Prefix AND 'Prefix' !=
$NULL$. In this way I don't care if there
are Nulls that "match", just actual values, and I prevent matching
my own record.
Set Field: zTmpPrefix = $Request ID$
Then your second filter is set to error out whenever ztmpPrefix !=
$NULL$
Brien
On 11/9/2011 3:58 PM, Jase Brandon wrote:
**
Hello All,
Windows 2008
7.6.04 SP1
I have a field named 'Prefix' on COM:COMPANY. I need to make sure
that on submit that the value for 'Prefix' does not already exist.
I have two filters -
Filter #1
Fires on submit, exec order 0, the Run IF = 'Prefix' != $NULL$
One If Action - Push Field to COM:COMPANY (same form) IF =
$Prefix$ = 'Prefix'
Push field action ="" 'zTmpPrefix' = $Prefix$. (I added a char
field 'zTmpPrefix')
I see this working perfectly in the logs as shown below. I see it
find the value "ALT" and do the push fields action without any
problem.
Filter #2
Fires on Submit, exec order 999.
The Run IF = 'ZTmpPrefix' != $NULL$.
I also tried 'zTmpPrefix' = $Prefix$ to no avail.
This fails and doesn't fire my error message. I know I am missing
something horribly simple, but I've spent two hours on this and
wanted to reach out to the gang. :-)
Please see log below. This is where I got frustrated with the
filters and tried with AL's - same result. I've tried using `! on
the filters, every trick I know. Any ideas? I'm admittedly tired
and wanted to see if someone could help a brother out. :-)
Thanks,
Jase Brandon
<ACTL> Checking ++QTS:COM:COMPANY Customer Prefix
is Unique (0)
<ACTL> -> Passed qualification -- perform if
actions
<ACTL> 0: Push Fields
<ACTL> To Schema COM:Company on Server @
<ACTL> (536870917) = ALT
<ACTL> Checking +QTS:Com:Company Require Customer Type (0)
<ACTL> -> Failed qualification
<ACTL> Checking COM:CPY:Company_010_CompanyIndexChk (10)
<ACTL> -> Passed qualification -- perform if actions
<ACTL> 0: Set Fields
<ACTL> z1D Char01 (1000000058) = ""
<ACTL> Checking COM:CPY:Company_011_CompanyIndexChkMsg (11)
<ACTL> -> Failed qualification
<ACTL> Checking ++QTS:COM:COMPANY Customer Prefix is
Unique Error (999)
<ACTL> -> Failed qualification
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
|
