Re: search result
** L.J, I am not familiar with the submitting a query email, but how can I get the esclation to generate the csv after I generate a report macro?"L. J. Head" <[EMAIL PROTECTED]> wrote: ** Have you tried submitting a query email?I've never used one...but the old email engine provided capability to email the remedy server with a query and it would return the results in the body of the emailor you could generate a report macro...and have the escalation generate that csv and then email the csv to them L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 3:15 PMTo: arslist@ARSLIST.ORGSubject: search result ** I want to include a search result from a form in a notification and email a user on a daily basis. The search result I am getting from a form is between 150 to 200 records. The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. __20060125___This posting was submitted with HTML in it___
search result
** I want to include a search result from a form in a notification and email a user on a daily basis. The search result I am getting from a form is between 150 to 200 records. The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___
Re: Remedy Notification
** Roger, Is it all filters and esclations on the system that I need to export?Roger Justice <[EMAIL PROTECTED]> wrote: ** Export your filter and escalation workflow and search for the email address. -Original Message-From: [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tue, 10 Oct 2006 11:33 AMSubject: Remedy Notification ** Hi List, server ARS 5.1.2 SQL and Windows A user receives a daily report coming from remedy notification and he doesn't want to receive the email any longer. I checked every single notification (filter and escalation) coming out from the form where the report is generated. I don't see his name or the notification anywhere. The email says From [EMAIL PROTECTED] Is there anywhere else I should check besides the filters and escalations associated to that form? Any suggestion will be appreciated. Thanks, All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125___This posting was submitted with HTML in it___ Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more.__20060125___This posting was submitted with HTML in it___ Stay in the know. Pulse on the new Yahoo.com. Check it out. __20060125___This posting was submitted with HTML in it___
Remedy Notification
** Hi List, server ARS 5.1.2 SQL and Windows A user receives a daily report coming from remedy notification and he doesn't want to receive the email any longer. I checked every single notification (filter and escalation) coming out from the form where the report is generated. I don't see his name or the notification anywhere. The email says From [EMAIL PROTECTED] Is there anywhere else I should check besides the filters and escalations associated to that form? Any suggestion will be appreciated. Thanks, All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125___This posting was submitted with HTML in it___
I need guide
** I am new ARS Administrator and the company I am working for utilizes all customed applications. I am not given any training on their system and it makes my work difficult. Is it normal for companies to put new people to work with out giving any training on the system? Please advise me on how should I handle this. Thank you in advance. Get your email and more, right on the new Yahoo.com __20060125___This posting was submitted with HTML in it___
Re: Question about search result
** That makes sence. Thank you all!!Frank Caruso <[EMAIL PROTECTED]> wrote: ** Because you are saying less than or equal to "9/20/2006 12:00:00 AM". You need to change query to something like <"9/21/2006" or "9/20/2006 12:00:00 AM"+(60*60*1) On 9/29/06, Addis Solomon <[EMAIL PROTECTED]> wrote: ** When I define an advance search saying 'Create date' >= "09/10/06" and 'Create date' <= "09/20/06", The result is not including the the 20th date. In other words the result is only for < 20 but not including the 20th date. Does anybody know why it is doing this? I greatly appreciate your help. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. __20060125___This posting was submitted with HTML in it___
Question about search result
** When I define an advance search saying 'Create date' >= "09/10/06" and 'Create date' <= "09/20/06", The result is not including the the 20th date. In other words the result is only for < 20 but not including the 20th date. Does anybody know why it is doing this? I greatly appreciate your help. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___
Re: 1 = 2
** That was the problem! there wasn't no value assigned to field ID 2 on the destination. Thank you arslist you guys are my mentor. David Morgan <[EMAIL PROTECTED]> wrote: Hi MikeThe "ARERR [307] Required field (without a default) not specified: 2" Seems to indicate that the filter is firing, and that the push isoccurring, but that the destination form requires a setting for Field ID2. The data is not supplied in the push, or defaulted in the form. Trysetting Field ID 2 to something sensible and re-try the push.RegardsDave 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: arslist@ARSLIST.ORG> 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 hasbeen> configured to disallow unqualified searches.> You must specify some search criteria to perform a search on thisform"> > > 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 whetheror> 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:> arslist@ARSLIST.ORG> .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 linkto> push values from one form to another. Can any one tell me what arethe 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 submittedwith> 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 myown.> __20060125___This posting was submitted with HTMLin> it___> > -> Do you Yahoo!?> Get on board. You're invited to try the new Yahoo! Mail.> __20060125___This posting was submitted with HTMLin> 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 myown.> __20060125___This posting was submitted with HTMLin> 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> > **> No luck. I tried everything I am still getting the sameerror> messageWarren Baltimore> <[EMAIL PROTECTED]> wrote: class=replbq> style="PADDING-L
Re: 1 = 2
** No luck. I tried everything I am still getting the same error messageWarren 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 NoRequests 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 ornot 1 = 2 in a Push Fields If causes a table scan.Mike WhiteOffice: 813-978-2192 E-mail: [EMAIL PROTECTED] "Mimi Lakew" < [EMAIL PROTECTED]To: arslist@ARSLIST.ORG .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 1and 2 stand for?ThanksHow low will we go? Check out Yahoo! Messenger's low PC-to-Phone callrates. __20060125___This posting was submitted with HTML in it___-- Warren R. Baltimore IIRemedy DeveloperUW Medicine IT ServicesSchool of MedicineUniversity of WashingtonBox 3582201325 Fourth Ave, Suite 2000Seattle, WA 98101The 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 IIRemedy DeveloperUW Medicine IT ServicesSchool of MedicineUniversity of WashingtonBox 3582201325 Fourth Ave, Suite 2000 Seattle, WA 98101The 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 __20060125___This posting was submitted with HTML in it___
Re: 1 = 2
** 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 NoRequests 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 ornot 1 = 2 in a Push Fields If causes a table scan.Mike WhiteOffice: 813-978-2192 E-mail: [EMAIL PROTECTED] "Mimi Lakew" <[EMAIL PROTECTED]To: arslist@ARSLIST.ORG .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 topush values from one form to another. Can any one tell me what are the 1and 2 stand for?ThanksHow low will we go? Check out Yahoo! Messenger's low PC-to-Phone callrates. __20060125___This posting was submitted withHTML in it___-- Warren R. Baltimore IIRemedy DeveloperUW Medicine IT ServicesSchool of MedicineUniversity of WashingtonBox 3582201325 Fourth Ave, Suite 2000Seattle, WA 98101The 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___
big problem
** Hi everybody, I accidentally modified the wrong data through active link. Is there anyway I can recover from that? I appreciate your help. Thanks Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___
Run Macro
** Hi everybody, I am opening an active link and there is a Run Macro action in it. I am not familiar with Run Macro action and all I see is the name of the macro and Parameter Name which is "%" and Value which is $SERVER$. I want to see what is in the macro so I can make modifications. How can I see what is in the macro? Also is it possible for me to see macros created by other developers or admins? I greatly will appreciate your help!! Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___
Requiered field
** Can anybody tell me if it is possible to change an Optionl field to Requiered field in some criterias please? Thanks!! Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. __20060125___This posting was submitted with HTML in it___
Fwd: How to verify if the current value entering exists on the database
** Thank you all, you guys are great help!!! Jerry, I think you confused me with somebody else. God blessNote: forwarded message attached. All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125___This posting was submitted with HTML in it___--- Begin Message --- ** Can anybody help me how can I check if the current value entering already exists on the database? Thanks in advance for your help All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125___This posting was submitted with HTML in it___--- End Message ---
Re: How to verify if the current value entering exists on the database
** Kelly, I followed instruction # 2 however, the lastcount is counting all the records that are on the form instead of only values that matched the current value. Any recommendation?Kelly Deaver <[EMAIL PROTECTED]> wrote: ** There are several ways, depending on what you are trying to accomplish. I'm going to call the field you are interested in FieldA in my examples. 1. If you are trying to assure that no two records have the same value in a particular field (FieldA), create a unique index for that field. In the Admin tool, open the form and select form>form properties. On the Index tab, move the desired field to the right column and check the "unique" box below. Save. When the user submits a new record, it will say that entry violates a unique ID on FieldA. 2. Add a field, FieldB, to number field to check the result of an active link you are going to create.Create an active link that runs on loose focus, run if - FieldA != Null. Select a set field of the field action. Query the form name of the same form (not CURRENT SCREEN) where $FieldA$ = 'FieldA'. Set the no match = set the field to null. Set multiple match = Use first matching request. Set Field - FieldB = $LASTCOUNT$. This will tell you how many already submitted records match the current value in FieldA. You can then create an error message if FieldB not NULL that tells the user in more detail what you want them to change. 3. Do the same thing with a filter to check on submit and block the submit action if you like. 4. If you aren't trying to block, but rather find matches, you can do the same as #2 except instead of setting multiple match to Display a List. -Kelly DeaverDirector, ITSM PracticeXinify[EMAIL PROTECTED] Original Message Subject: How to verify if the current value entering exists on thedatabaseFrom: Addis Solomon <[EMAIL PROTECTED]>Date: Sun, August 27, 2006 12:27 pmTo: arslist@ARSLIST.ORG** Can anybody help me how can I check if the current value entering already exists on the database? Thanks in advance for your help All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. __20060125___This posting was submitted with HTML in it___
How to verify if the current value entering exists on the database
** Can anybody help me how can I check if the current value entering already exists on the database? Thanks in advance for your help All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125___This posting was submitted with HTML in it___
