Kathy,
Like Rick says using $NULL$ forces a table scan. Also using != always forces
a table scan. You could maybe try a RUN IF of ('Assignee' = "Joe Smith") or
('Assignee' = "Jane Doe") or ('Assignee' = "<one of 7 other names>").
Are you wanting to run this against only open Help Desk records? If so you
could add 'Status' < "Closed". That would narrow down the search
significantly. Your RUN IF would then look something like:
(('Status' < "Closed") AND (('Assignee' = "Joe Smith") or ('Assignee' =
"Jane Doe") or ('Assignee' = "<one of 7 other names>").))
Roger Medsker
Remedy Consultant
Bluestem Consulting Group, LLC
[EMAIL PROTECTED]
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Thursday, June 19, 2008 2:08 PM
To: [email protected]
Subject: Re: Qualification for Modifying Pre-existing Records
** Get rid of your $NULL$ qualifications - they will always force a table
scan. Perhaps if you could add something to the qual that would narrow down
the number of rows - preferably on an indexed field?
Rick
On Thu, Jun 19, 2008 at 11:57 AM, Kathy Morris <[EMAIL PROTECTED]>
wrote:
** Hello,
I am running an escalation on the Help Desk form that runs at a specific
time with a RUN IF qualification of ( 'ztmpSub' = $NULL$ ) AND ( 'Assignee'
!= $NULL$ )
Then push some X into the group field if (Assignee = Joe Smith) or
(Assignee=Jane Doe) or about 7 other names.
I want to be able to modify selected old records at a specific time. When
the escalation runs, this hoses the server. Within the qualification, is
there a better way to narrow down the search results?
_____
Get
<http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00050000000011>
the Moviefone Toolbar. Showtimes, theaters, movie news, & more!
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
