The following statements would fire the same, but the first statement would be
cleaner to read, and more efficient as it would not cause a full query of the
table by causing the database to run a "not equal to" search bypassing your
indexes. ( 'TR.lesson_status' = "Completed") vs. ('DB.lesson_status' !=
"Completed" AND 'lesson_status' = "Completed")
Richard McCabe
________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of David Sanders
Sent: Thursday, February 21, 2008 6:51 PM
To: [email protected]
Subject: Re: Interview questions
So what's wrong with
AND ( 'lesson_status' = "Completed" ) AND ( 'DB.lesson_status' != "Completed"
)
When do you expect that to fire when you don't want it to??
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application
See the ESS Concepts Guide
<http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf>
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/>
________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Pargeter, Christie
Sent: Thursday, February 21, 2008 10:09 PM
To: [email protected]
Subject: Re: Interview questions
Because an API we have can write to this record multiple times...but we only
want the workflow to go off the first time lesson_status is changed.
________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Thad K Esser
Sent: Thursday, February 21, 2008 1:38 PM
To: [email protected]
Subject: Re: Interview questions
**
How is using 'TR.lesson_status' better than just 'lesson_status'?
Thad Esser
Remedy Developer
Work: 503-220-6192
"Perfection is achieved, not when there is nothing more to add, but when there
is nothing left to take away." - Antoine de Saint-Exupéry
"Pargeter, Christie" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]>
02/21/2008 01:23 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: Interview questions
Here is a piece of workflow that I have in my system today that uses TR and it
should.
( 'RecordUploadStatus' = "Uploaded") AND ( 'Emp_EntryID' != $NULL$ ) AND (
'ClassNameID' != $NULL$ ) AND ( 'TR.lesson_status' = "Completed" ) AND (
'DB.lesson_status' != "Completed" )
__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"
