Claire:
Are we talking about enumerated fields, such as Status?
I think it is in field_enum_values for the value translation from the number to the actual value.
You might try the following code:
Select enumid, value from field_enum_values where schemaid = (select schemaid from arschema where name ='<formname>') and fileid = <field dictionary field id> ;
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sanford, Claire
Sent: Monday, September 18, 2006 9:22 AM
To: [email protected]
Subject: HD 6.0 - Field Attributes
Does anyone know where Remedy stores the attributes for a field?
Ie 0=New, 1=Assigned?
Is this in a table somewhere??? Our DBA is trying to pull the data without using the ARODBC and he can't seem to find the value instead of just the integer.
Thanks!
ARS 6.3
HD 6
Oracle 10 something
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
