Using an escalation to kick off an event??
Good morning, afternoon and evening all, I have an odd thing I am trying to do with an escalation. I need to insert a record into a form (lets call is X) to kick off an event. The problem is that this form X is somewhat a busy one so if I do any qualifications, (for example if the subject like %RED%) and if no request match create a new request, if any match take no action, I get one new record for each record that does not match (and a number will not). Too bad I cannot use my qualification to add a record (Then I would put in a fake record). What I want to do is just create one record, into this form once a day. So any ideas? [Description: Description: Description: Cox Enterprises, Inc]http://www.coxenterprises.com/ Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.commailto:howard.rich...@coxinc.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: image001.gif
Re: Using an escalation to kick off an event??
Howard, Many years ago, I created a single form that I use to trigger reports, uploading data, etc. That is if I find a single record in that form, a push is triggered to create a record in another form. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Monday, August 12, 2013 3:43 PM To: arslist@ARSLIST.ORG Subject: Using an escalation to kick off an event?? ** Good morning, afternoon and evening all, I have an odd thing I am trying to do with an escalation. I need to insert a record into a form (lets call is X) to kick off an event. The problem is that this form X is somewhat a busy one so if I do any qualifications, (for example if the subject like %RED%) and if no request match create a new request, if any match take no action, I get one new record for each record that does not match (and a number will not). Too bad I cannot use my qualification to add a record (Then I would put in a fake record). What I want to do is just create one record, into this form once a day. So any ideas? [cid:image001.gif@01CE9772.EDC723C0]http://www.coxenterprises.com/ Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.commailto:howard.rich...@coxinc.com _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: image001.gif
Re: Using an escalation to kick off an event??
Howard, Create a Regular form Y, put a single record in it. Have your Escalation fire on form Y, matching on that record, and have the action be a push to form X. On Mon, Aug 12, 2013 at 1:42 PM, Richter, Howard (CEI - Atlanta) howard.rich...@coxinc.com wrote: ** Good morning, afternoon and evening all, ** ** I have an odd thing I am trying to do with an escalation. ** ** I need to insert a record into a form (lets call is X) to kick off an event. ** ** The problem is that this form X is somewhat a busy one so if I do any qualifications, (for example if the subject like “%RED%”) and if no request match create a new request, if any match take no action, I get one new record for each record that does not match (and a number will not). ** ** Too bad I cannot use my qualification to add a record (Then I would put in a fake record). ** ** What I want to do is just create one record, into this form once a day. ** ** ** ** So any ideas? ** ** ** ** ** ** ** ** [image: Description: Description: Description: Cox Enterprises, Inc]http://www.coxenterprises.com/ Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.com ** ** _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Using an escalation to kick off an event??
Howard, As LJ and others have described, one way is to have a form that has a single record and just run the escalation on it. You can push to any form so escalate on the dummy form and push wherever you want your new record. OR Set the qualification to something like 1=0 which will match nothing (and is efficient in all DBs - yes, Oracle has fixed their table scan issue on this) and put your logic in the ELSE branch of the escalation which fires when NOTHING matches the escalation condition. So, two ways to get what you need. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Monday, August 12, 2013 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: Using an escalation to kick off an event?? ** Howard, Create a Regular form Y, put a single record in it. Have your Escalation fire on form Y, matching on that record, and have the action be a push to form X. On Mon, Aug 12, 2013 at 1:42 PM, Richter, Howard (CEI - Atlanta) howard.rich...@coxinc.commailto:howard.rich...@coxinc.com wrote: ** Good morning, afternoon and evening all, I have an odd thing I am trying to do with an escalation. I need to insert a record into a form (lets call is X) to kick off an event. The problem is that this form X is somewhat a busy one so if I do any qualifications, (for example if the subject like %RED%) and if no request match create a new request, if any match take no action, I get one new record for each record that does not match (and a number will not). Too bad I cannot use my qualification to add a record (Then I would put in a fake record). What I want to do is just create one record, into this form once a day. So any ideas? Error! Filename not specified.http://www.coxenterprises.com/ Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.commailto:howard.rich...@coxinc.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Using an escalation to kick off an event??
Hi Howard,
I usually do exactly what Doug describes.
The one issue with it is that it is mandatory to have an IF action as well. It
will never run, but this does not matter very much what you put there. Maybe a
message that directs future admins to the ELSE action...
A qualification of ('1' 1) would be fast in any environment as well.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Howard,
As LJ and others have described, one way is to have a form that has a single
record and just run the
escalation on it. You can push to any form so escalate on the dummy form and
push wherever you want
your new record.
OR
Set the qualification to something like 1=0 which will match nothing (and is
efficient in all DBs - yes, Oracle
has fixed their table scan issue on this) and put your logic in the ELSE
branch of the escalation which fires
when NOTHING matches the escalation condition.
So, two ways to get what you need.
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Monday, August 12, 2013 12:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using an escalation to kick off an event??
**
Howard,
Create a Regular form Y, put a single record in it. Have your Escalation fire
on form Y, matching on that record, and have the action be a push to form X.
On Mon, Aug 12, 2013 at 1:42 PM, Richter, Howard (CEI - Atlanta)
howard.rich...@coxinc.commailto:howard.rich...@coxinc.com wrote:
**
Good morning, afternoon and evening all,
I have an odd thing I am trying to do with an escalation.
I need to insert a record into a form (lets call is X) to kick off an event.
The problem is that this form X is somewhat a busy one so if I do any
qualifications, (for example if the subject like %RED%) and if no request
match create a new request, if any match take no action, I get one new record
for each record that does not match (and a number will not).
Too bad I cannot use my qualification to add a record (Then I would put in a
fake record).
What I want to do is just create one record, into this form once a day.
So any ideas?
Error! Filename not specified.http://www.coxenterprises.com/
Howard Richter, Remedy Administrator
6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524
Email = howard.rich...@coxinc.commailto:howard.rich...@coxinc.com
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: Using an escalation to kick off an event??
All, Thanks the simple approach is the best. Hope to see you at RUG. Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, August 12, 2013 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Using an escalation to kick off an event?? ** Howard, Many years ago, I created a single form that I use to trigger reports, uploading data, etc. That is if I find a single record in that form, a push is triggered to create a record in another form. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Monday, August 12, 2013 3:43 PM To: arslist@ARSLIST.ORG Subject: Using an escalation to kick off an event?? ** Good morning, afternoon and evening all, I have an odd thing I am trying to do with an escalation. I need to insert a record into a form (lets call is X) to kick off an event. The problem is that this form X is somewhat a busy one so if I do any qualifications, (for example if the subject like %RED%) and if no request match create a new request, if any match take no action, I get one new record for each record that does not match (and a number will not). Too bad I cannot use my qualification to add a record (Then I would put in a fake record). What I want to do is just create one record, into this form once a day. So any ideas? http://www.coxenterprises.com/ Description: Description: Description: Cox Enterprises, Inc Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years image001.gif
Re: Using an escalation to kick off an event??
Doug, I forgot about that one. That is what happens when you get old and don't do much coding anymore. Thanks and take care, Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Monday, August 12, 2013 4:32 PM To: arslist@ARSLIST.ORG Subject: Re: Using an escalation to kick off an event?? ** Howard, As LJ and others have described, one way is to have a form that has a single record and just run the escalation on it. You can push to any form so escalate on the dummy form and push wherever you want your new record. OR Set the qualification to something like 1=0 which will match nothing (and is efficient in all DBs - yes, Oracle has fixed their table scan issue on this) and put your logic in the ELSE branch of the escalation which fires when NOTHING matches the escalation condition. So, two ways to get what you need. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Monday, August 12, 2013 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: Using an escalation to kick off an event?? ** Howard, Create a Regular form Y, put a single record in it. Have your Escalation fire on form Y, matching on that record, and have the action be a push to form X. On Mon, Aug 12, 2013 at 1:42 PM, Richter, Howard (CEI - Atlanta) howard.rich...@coxinc.com wrote: ** Good morning, afternoon and evening all, I have an odd thing I am trying to do with an escalation. I need to insert a record into a form (lets call is X) to kick off an event. The problem is that this form X is somewhat a busy one so if I do any qualifications, (for example if the subject like %RED%) and if no request match create a new request, if any match take no action, I get one new record for each record that does not match (and a number will not). Too bad I cannot use my qualification to add a record (Then I would put in a fake record). What I want to do is just create one record, into this form once a day. So any ideas? http://www.coxenterprises.com/ Error! Filename not specified. Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Using an escalation to kick off an event??
Thanks Misi
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Monday, August 12, 2013 4:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using an escalation to kick off an event??
Hi Howard,
I usually do exactly what Doug describes.
The one issue with it is that it is mandatory to have an IF action as well. It
will never run, but this does not matter very much what you put there. Maybe a
message that directs future admins to the ELSE action...
A qualification of ('1' 1) would be fast in any environment as well.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Howard,
As LJ and others have described, one way is to have a form that has a
single record and just run the escalation on it. You can push to any
form so escalate on the dummy form and push wherever you want your new
record.
OR
Set the qualification to something like 1=0 which will match nothing
(and is efficient in all DBs - yes, Oracle has fixed their table scan
issue on this) and put your logic in the ELSE branch of the escalation
which fires when NOTHING matches the escalation condition.
So, two ways to get what you need.
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Monday, August 12, 2013 12:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using an escalation to kick off an event??
**
Howard,
Create a Regular form Y, put a single record in it. Have your
Escalation fire on form Y, matching on that record, and have the action be a
push to form X.
On Mon, Aug 12, 2013 at 1:42 PM, Richter, Howard (CEI - Atlanta)
howard.rich...@coxinc.commailto:howard.rich...@coxinc.com wrote:
**
Good morning, afternoon and evening all,
I have an odd thing I am trying to do with an escalation.
I need to insert a record into a form (lets call is X) to kick off an event.
The problem is that this form X is somewhat a busy one so if I do any
qualifications, (for example if the subject like %RED%) and if no
request match create a new request, if any match take no action, I get
one new record for each record that does not match (and a number will not).
Too bad I cannot use my qualification to add a record (Then I would
put in a fake record).
What I want to do is just create one record, into this form once a day.
So any ideas?
Error! Filename not specified.http://www.coxenterprises.com/
Howard Richter, Remedy Administrator
6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email =
howard.rich...@coxinc.commailto:howard.rich...@coxinc.com
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
__
_ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers
Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
