Axton:
Where are the other three rows?
James McKenzie
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, September 12, 2006 9:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Approvals
Version, version, version:
This is from 5.6.
SQL> ed
Wrote file afiedt.buf
1 select fieldid, fieldname from field where fieldname like
'%Approval%' and schemaid in (
2* select schemaid from arschema where
name = 'CHG:Change')
SQL> /
FIELDID FIELDNAME
----------
----------------------------------------
260000001 Approval
Status
260007054 Approval Required?
260007055
zTmpApprovalStatusDB
260007056 Error in Approval
Process
260007057 zApprovalProcessName
350107005
btnStartApproval
350307001 tabApprovals
10 rows selected.
Axton Grams
On 9/12/06, Mary
Lavin <[EMAIL PROTECTED]>
wrote:
**
Approval Required is a status within the Approval Status field.
Mary M. Lavin
Information Technology Department
Business Applications Section
John Atherly <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG >09/12/2006 04:35 AM
Please respond to
arslist@ARSLIST.ORG
Toarslist@ARSLIST.ORG cc SubjectRe: Approvals
260000001 is Approval Status field number
John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120
Dylan
<[EMAIL PROTECTED]
.NET> To
Sent by: "Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)" Subject
<[EMAIL PROTECTED] Approvals
ORG>
09/11/2006 04:58
PM
Please respond to
[EMAIL PROTECTED]
RG
I've come into ownership of a heavily modified CHG:Change form. I'm trying
to set it up so that the approval process will restart if a field is
modified. I saw on the knowledgebase that I can restart it if the Approval
Required field is reset. I don't have an Approval Required field on my form
though and I'm wondering if someone renamed it and used it for something
else before I got ahold of it. So does anyone know the ID of that field? Or
is there another way I can get the approval process restarted on a CHG
ticket? The approval documentation is pretty vague on restarting the
process.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___