No worries.
Phil Bautista
President / CEO
Bull Creek Data Corporation
www.bullcreek.com
Remedy Approved Consultant (RAC)
512-731-0304
-----Original message-----
From: Mike White [EMAIL PROTECTED]
Date: Thu, 21 Sep 2006 16:02:10 -0400
To: [email protected]
Subject: Re: 1 = 2
:-) Didn't mean to offend. By "exactly", I only meant that that was my point -
:-) the "2" in his error dudn't refer to the 1 = 2 in his Push Fields If, but
:-) instead was a Field ID (Submitter) which is a required field that must be
:-) set by default value, via workflow (include in push Field fields) or
:-) manually (depending on the nature of the application.
:-)
:-) Absolutely subsequent filter processing can error for other reasons,
:-) causing the entire transaction to be backed-out.
:-)
:-) Cheers!
:-)
:-) Mike White
:-) Office: 813-978-2192
:-) E-mail: [EMAIL PROTECTED]
:-)
:-)
:-)
:-) "[EMAIL PROTECTED]
:-) ek.com" <Bautista To:
[email protected]
:-) Sent by: "Action cc:
:-) Request System Subject: Re: 1 = 2
:-) discussion
:-) list(ARSList)"
:-) <[EMAIL PROTECTED]
:-) ORG>
:-)
:-)
:-) 09/21/2006 15:30
:-) Please respond to
:-) arslist
:-)
:-)
:-)
:-)
:-)
:-)
:-) Not exactly. The filter is starting to fire, but in (Phase 3 ?) it gets
:-) backed out since the Submitter field is not populated by the workflow and
:-) the field doesn't contain a default value on the form. So while you think
:-) it is "firing" it is only "starting to fire" and gets "backed out".
:-) Another option may be that the initial push fields specified may be OK (but
:-) will fail at the end because...), the push fields action triggers another
:-) piece of workflow that actually attempts to push data to a completely
:-) different form (not specified in the workflow in question)
:-)
:-) Filter logging should point out the culprit. Been there, seen it, got a
:-) closet full of T-shirts.
:-)
:-) Phil Bautista
:-) President / CEO
:-) Bull Creek Data Corporation
:-) www.bullcreek.com
:-) Remedy Approved Consultant (RAC)
:-) 512-731-0304
:-) -----Original message-----
:-) From: Mike White [EMAIL PROTECTED]
:-) Date: Thu, 21 Sep 2006 15:02:17 -0400
:-) To: [email protected]
:-) Subject: Re: 1 = 2
:-)
:-) :-) Exactly.
:-) :-)
:-) :-) Mike White
:-) :-) Office: 813-978-2192
:-) :-) E-mail: [EMAIL PROTECTED]
:-) :-)
:-) :-)
:-) :-)
:-)
:-) :-) "David Morgan"
:-)
:-) :-) <[EMAIL PROTECTED] To:
:-) [email protected]
:-) :-) RONE.COM> cc:
:-)
:-) :-) Sent by: "Action Subject: Re: 1 = 2
:-)
:-) :-) Request System
:-)
:-) :-) discussion
:-)
:-) :-) list(ARSList)"
:-)
:-) :-) <[EMAIL PROTECTED]
:-)
:-) :-) ORG>
:-)
:-) :-)
:-)
:-) :-)
:-)
:-) :-) 09/21/2006 15:03
:-)
:-) :-) Please respond to
:-)
:-) :-) arslist
:-)
:-) :-)
:-)
:-) :-)
:-)
:-) :-)
:-) :-)
:-) :-)
:-) :-)
:-) :-) Hi Mike
:-) :-)
:-) :-) The "ARERR [307] Required field (without a default) not specified: 2"
:-) :-) Seems to indicate that the filter is firing, and that the push is
:-) :-) occurring, but that the destination form requires a setting for Field
:-) ID
:-) :-) 2. The data is not supplied in the push, or defaulted in the form. Try
:-) :-) setting Field ID 2 to something sensible and re-try the push.
:-) :-)
:-) :-) Regards
:-) :-) Dave Morgan
:-) :-)
:-) :-)
:-) :-) > -----Original Message-----
:-) :-) > From: Action Request System discussion list(ARSList)
:-) :-) > [mailto:[EMAIL PROTECTED] On Behalf Of Addis Solomon
:-) :-) > Sent: 21 September 2006 18:45
:-) :-) > To: [email protected]
:-) :-) > Subject: Re: 1 = 2
:-) :-) >
:-) :-) > --0-1523106300-1158860712=:64783
:-) :-) > Content-Type: text/plain; charset=iso-8859-1
:-) :-) > Content-Transfer-Encoding: 8bit
:-) :-) >
:-) :-) >
:-) :-) > No luck. I tried everything I am still getting the same error
:-) message
:-) :-) > Warren Baltimore <[EMAIL PROTECTED]> wrote: ** What are
:-) the
:-) :-) > settings for the qualification on the if tab? Try setting them to:
:-) :-) >
:-) :-) > If No Requests Match: Create a New Request
:-) :-) > If Any Requests Match: Take No Action
:-) :-) >
:-) :-) > See if that works!
:-) :-) >
:-) :-) > Warren
:-) :-) >
:-) :-) >
:-) :-) > On 9/21/06, Addis Solomon <[EMAIL PROTECTED]> wrote: ** I am
:-) :-) > using ARS 5.1.2 on SQL server and Windows
:-) :-) > I am getting the following error messege from the client side
:-) :-) > "ARERR [307] Required field (without a default) not specified : 2"
:-) :-) Do
:-) :-) > you know why?
:-) :-) >
:-) :-) > If i leave the qualification blank then I get
:-) :-) >
:-) :-) > "ARERR [361] An unqualified search was issued and the server has
:-) :-) been
:-) :-) > configured to disallow unqualified searches.
:-) :-) > You must specify some search criteria to perform a search on this
:-) :-) form"
:-) :-) >
:-) :-) >
:-) :-) > Warren Baltimore <[EMAIL PROTECTED]> wrote:
:-) :-) > ** It's something that is no longer reqd. to get the create new in
:-) a
:-) :-) > push field. Just leave the qualification blank.....
:-) :-) >
:-) :-) > On 9/20/06, Mike White <[EMAIL PROTECTED] > wrote:
:-) :-) > It's an intentionally-false condition to cause the Push Field's "If
:-) No
:-) :-) > Requests Match" action to be taken - usually to create a record
:-) :-) > unconditionally (Create a New Request).
:-) :-) >
:-) :-) > There have been a few interesting discussions on arslist about
:-) whether
:-) :-) or
:-) :-) > not 1 = 2 in a Push Fields If causes a table scan.
:-) :-) >
:-) :-) > Mike White
:-) :-) > Office: 813-978-2192
:-) :-) > E-mail: [EMAIL PROTECTED]
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) > "Mimi Lakew"
:-) :-) > < [EMAIL PROTECTED] To:
:-) :-) > [email protected]
:-) :-) > .COM> cc:
:-) :-) > Sent by: "Action Subject: 1 = 2
:-) :-) > Request System
:-) :-) > discussion
:-) :-) > list(ARSList)"
:-) :-) > <[EMAIL PROTECTED] .
:-) :-) > ORG>
:-) :-) >
:-) :-) >
:-) :-) > 09/20/2006 17:45
:-) :-) > Please respond to
:-) :-) > arslist
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) > **
:-) :-) > I have seen 1=2 on the "push field if" bar for push action active
:-) link
:-) :-) to
:-) :-) > push values from one form to another. Can any one tell me what are
:-) :-) the 1
:-) :-) > and 2 stand for?
:-) :-) >
:-) :-) > Thanks
:-) :-) >
:-) :-) >
:-) :-) > How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
:-) :-) > rates. __20060125_______________________This posting was submitted
:-) :-) with
:-) :-) > HTML in it___
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) > --
:-) :-) > Warren R. Baltimore II
:-) :-) > Remedy Developer
:-) :-) > UW Medicine IT Services
:-) :-) > School of Medicine
:-) :-) > University of Washington
:-) :-) > Box 358220
:-) :-) > 1325 Fourth Ave, Suite 2000
:-) :-) > Seattle, WA 98101
:-) :-) >
:-) :-) >
:-) :-) > The opinions expressed in this e-mail are in no way those of the
:-) :-) > University of Washington, or the State of Washington. They are my
:-) :-) own.
:-) :-) > __20060125_______________________This posting was submitted with HTML
:-) :-) in
:-) :-) > it___
:-) :-) >
:-) :-) > ---------------------------------
:-) :-) > Do you Yahoo!?
:-) :-) > Get on board. You're invited to try the new Yahoo! Mail.
:-) :-) > __20060125_______________________This posting was submitted with HTML
:-) :-) in
:-) :-) > it___
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) >
:-) :-) > --
:-) :-) > Warren R. Baltimore II
:-) :-) > Remedy Developer
:-) :-) > UW Medicine IT Services
:-) :-) > School of Medicine
:-) :-) > University of Washington
:-) :-) > Box 358220
:-) :-) > 1325 Fourth Ave, Suite 2000
:-) :-) > Seattle, WA 98101
:-) :-) >
:-) :-) > The opinions expressed in this e-mail are in no way those of the
:-) :-) > University of Washington, or the State of Washington. They are my
:-) :-) own.
:-) :-) > __20060125_______________________This posting was submitted with HTML
:-) :-) in
:-) :-) > it___
:-) :-) >
:-) :-) >
:-) :-) > ---------------------------------
:-) :-) > Get your email and more, right on the new Yahoo.com
:-) :-) >
:-) :-) >
:-) :-)
:-) ________________________________________________________________________
:-) :-) __
:-) :-) > _____
:-) :-) > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
:-) :-) > --0-1523106300-1158860712=:64783
:-) :-) > Content-Type: text/html; charset=iso-8859-1
:-) :-) > Content-Transfer-Encoding: 8bit
:-) :-) >
:-) :-) > **
:-) :-) > <BR>No luck. I tried everything I am still getting the same
:-) :-) error
:-) :-) > message<BR><B><I>Warren Baltimore
:-) :-) > <[EMAIL PROTECTED]></I></B> wrote: <BLOCKQUOTE
:-) :-) class=replbq
:-) :-) > style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px
:-) :-) > solid">** <DIV>What are the settings for the qualification on the
:-) if
:-) :-) > tab? Try setting them to:</DIV> <DIV> </DIV> <DIV>If No
:-) :-) > Requests Match: Create a New Request</DIV> <DIV>If Any
:-) Requests
:-) :-) > Match: Take No Action</DIV> <DIV> </DIV> <DIV>See if
:-) that
:-) :-) > works!</DIV> <DIV> </DIV> <DIV>Warren<BR><BR> </DIV>
:-) :-) > <DIV><SPAN class=gmail_quote>On 9/21/06, <B
:-) :-) class=gmail_sendername>Addis
:-) :-) > Solomon</B> <<A
:-) :-) > href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>>
:-) :-) > wrote:</SPAN> <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT:
:-) :-) 1ex;
:-) :-) > MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">** <DIV>I
:-) am
:-) :-) > using ARS 5.1.2 on SQL server and Windows</DIV> <DIV>I am getting
:-) the
:-) :-) > following error
:-) :-) > messege from the client side </DIV> <DIV> "ARERR [307]
:-) Required
:-) :-) > field (without a default) not specified : 2" Do you know why?</DIV>
:-) :-) > <DIV> </DIV> <DIV>If i leave the qualification blank then I get
:-) :-) > </DIV> <DIV> </DIV> <DIV>"ARERR [361] An unqualified search
:-) was
:-) :-) > issued and the server has been configured to disallow unqualified
:-) :-) > searches.<BR>You must specify some search criteria to perform a
:-) search
:-) :-) on
:-) :-) > this form"<BR><BR><BR><B><I>Warren Baltimore <<A onclick="return
:-) :-) > top.js.OpenExtLink(window,event,this)"
:-) :-) > href="mailto:[EMAIL PROTECTED]"
:-) :-) > target=_blank>[EMAIL PROTECTED]</A>></I></B> wrote:</DIV>
:-) :-) > <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
:-) :-) > #1010ff 2px solid">** It's something that is no longer reqd. to get
:-) :-) the
:-) :-) > create new in a push field. Just leave the qualification
:-) :-) blank.....
:-) :-) > <DIV><SPAN class=e id=q_10dd16da7e92f3d6_1><BR><BR> <DIV><SPAN
:-) :-) > class=gmail_quote>On 9/20/06, <B class=gmail_sendername>Mike
:-) :-) > White</B> <<A onclick="return
:-) :-) top.js.OpenExtLink(window,event,this)"
:-) :-) > href="mailto:[EMAIL PROTECTED]"
:-) :-) target=_blank>[EMAIL PROTECTED]
:-) :-) > </A>> wrote:</SPAN> <BLOCKQUOTE class=gmail_quote
:-) style="PADDING-
:-) :-) > LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px
:-) :-) > solid"><BR>It's an intentionally-false condition to cause the Push
:-) :-) Field's
:-) :-) > "If No<BR>Requests Match" action to be taken - usually to create a
:-) :-) record
:-) :-) > <BR>unconditionally (Create a New Request).<BR><BR>There have been a
:-) :-) few
:-) :-) > interesting discussions on arslist about whether or<BR>not 1 = 2 in a
:-) :-) Push
:-) :-) > Fields If causes a table scan.<BR><BR>Mike
:-) :-) > White<BR>Office: 813-978-2192 <BR>E-mail: <A
:-) :-) > onclick="return top.js.OpenExtLink(window,event,this)"
:-) :-) > href="mailto:[EMAIL PROTECTED]"
:-) :-) >
:-) :-)
:-) target=_blank>[EMAIL PROTECTED]</A><BR><BR><BR><BR> &nbs
:-) :-) p;
:-) :-) >
:-) :-)
:-)
:-) :-) &n
:-) :-) > bsp; "Mimi
:-) :-) >
:-) :-) >
:-) :-)
:-) Lakew"<BR> &n
:-) :-) bs
:-) :-) > p; <
:-) :-) >
:-) :-)
:-) [EMAIL PROTECTED] To: 
:-) :-) ;&
:-) :-) > nbsp; <A onclick="return
:-) :-) > top.js.OpenExtLink(window,event,this)"
:-) :-) href="mailto:[email protected]";
:-) :-) >
:-) :-)
:-) target=_blank>[email protected]</A><BR> &
:-) :-) nb
:-) :-) >
:-) :-)
:-) sp; &nb
:-) :-) sp
:-) :-) > ;
:-) :-) >
:-) :-)
:-) .COM> &nbs
:-) :-) p;
:-) :-) > cc:
:-) :-) >
:-) :-)
:-) <BR> &n
:-) :-) bs
:-) :-) > p; Sent by:
:-) :-) > "Action
:-) :-) > Subject: 1 =
:-) :-) >
:-) :-)
:-) 2<BR> &
:-) :-) nb
:-) :-) > sp; Request
:-) :-) >
:-) :-) >
:-) :-)
:-) System<BR> &n
:-) :-) bs
:-) :-) > p; discussion
:-) :-) >
:-) :-)
:-) <BR> &n
:-) :-) bs
:-) :-) > p;
:-) :-) >
:-) :-)
:-) list(ARSList)"<BR>
:-) :-) &n
:-) :-) > bsp;
:-) :-) > <[EMAIL PROTECTED]
:-) :-) >
:-) :-)
:-) .<BR> &
:-) :-) nb
:-) :-) > sp;
:-) :-) >
:-) :-)
:-) ORG><BR><BR><BR>  
:-) :-) ;&
:-) :-) > nbsp;
:-) :-) > 09/20/2006
:-) :-) >
:-) :-)
:-) 17:45<BR> &nb
:-) :-) sp
:-) :-) > ; Please
:-) respond
:-) :-) >
:-) :-)
:-) to<BR>
:-) :-) &n
:-) :-) > bsp; arslist
:-) :-) > <BR><BR><BR><BR><BR><BR><BR>**<BR>I have seen 1=2 on the "push field
:-) :-) if"
:-) :-) > bar for push action active link to <BR>push values from one form to
:-) :-) > another. Can any one tell me what are the 1<BR>and 2 stand
:-) :-) > for?<BR><BR>Thanks<BR><BR><BR>How low will we go? Check out Yahoo!
:-) :-) > Messenger's low PC-to-Phone call<BR>rates.
:-) :-) > __20060125_______________________This posting was submitted with
:-) :-) <BR>HTML
:-) :-) > in it___<BR><BR><BR><BR><BR></BLOCKQUOTE></DIV><BR><BR
:-) :-) clear=all><BR>--
:-) :-) > <BR>Warren R. Baltimore II<BR>Remedy Developer<BR>UW Medicine IT
:-) :-) > Services<BR>School of Medicine<BR>University of Washington<BR>Box
:-) :-) > 358220<BR>1325 Fourth Ave, Suite 2000<BR>Seattle, WA
:-) :-) > 98101<BR><BR></SPAN></DIV>The opinions expressed in this e-mail are
:-) in
:-) :-) no
:-) :-) > way those of the University of Washington, or the State of
:-) :-) > Washington. They are my own.
:-) :-) > __20060125_______________________This posting was submitted with HTML
:-) :-) in
:-) :-) > it___ </BLOCKQUOTE><SPAN class=ad><BR> <div> <HR SIZE=1> Do you
:-) :-) > Yahoo!?<BR>Get on
:-) :-) > board. <A onclick="return top.js.OpenExtLink(window,event,this)"
:-) :-) >
:-) :-) href="http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo
:-) .
:-) :-) co
:-) :-) > m/mailbeta" target=_blank>You're invited</A> to try the new Yahoo!
:-) :-) Mail.
:-) :-) > __20060125_______________________This posting was submitted with HTML
:-) :-) in
:-) :-) > it___ <div></div> <div></div></SPAN></BLOCKQUOTE></DIV><BR><BR
:-) :-) > clear=all><BR>-- <BR>Warren R. Baltimore II<BR>Remedy Developer<BR>UW
:-) :-) > Medicine IT Services<BR>School of Medicine<BR>University of
:-) :-) > Washington<BR>Box 358220<BR>1325 Fourth Ave, Suite 2000 <BR>Seattle,
:-) :-) WA
:-) :-) > 98101<BR><BR>The opinions expressed in this e-mail are in no way
:-) those
:-) :-) of
:-) :-) > the University of Washington, or the State of
:-) :-) Washington. They
:-) :-) > are my own. __20060125_______________________This posting was
:-) :-) submitted
:-) :-) > with HTML in it___ </BLOCKQUOTE><BR><p> 
:-) :-) > <hr size=1>Get your email and more, right on
:-) the
:-) :-) <a
:-) :-) > href="http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview
:-) ">
:-) :-) new
:-) :-) > Yahoo.com</a>
:-) :-) > __20060125_______________________This posting was submitted with HTML
:-) :-) in
:-) :-) > it___
:-) :-) >
:-) :-) > --0-1523106300-1158860712=:64783--
:-) :-)
:-) :-)
:-)
_______________________________________________________________________________
:-)
:-) :-)
:-) :-) UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
:-) :-)
:-) :-)
:-)
_______________________________________________________________________________
:-)
:-) :-) UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
:-)
:-)
_______________________________________________________________________________
:-)
:-) UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
:-)
:-)
_______________________________________________________________________________
:-) UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
