This is for Oracle. Adjust your where clause as desired (to limit to a
particular form add s.name = 'HPD:Help Desk').
select s.name, f.fieldid, f.fieldname, f.foption, s.schematype
from arschema s, field f
where s.schemaid = f.schemaid
and f.foption != 4
and s.schematype = 1
order by 1
Comments:
//AR_FIELD_OPTION_REQUIRED 1 /* tags for field definition option */
//AR_FIELD_OPTION_OPTIONAL 2
//AR_FIELD_OPTION_SYSTEM 3 /* system field; read-only to ALL users */
//AR_FIELD_OPTION_DISPLAY 4 /* display-only field; no data will be */
/* stored for this field in the DB */
//schema type 1-regular, 2-join, 3-Viewform, 4-DisplayOnly
Thad Esser
Remedy Developer
"Did you ever wonder why we had to run for shelter when the promise of a
brave new world unfurled beneath a clear blue sky?" - Pink Floyd
|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Bala Patel <[email protected]>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|[email protected]
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|07/23/2009 11:46 AM
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Print Field and Fields
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"Action Request System discussion list(ARSList)" <[email protected]>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
**
Hi List,
Does anyone know how to perform a SQL statement to get the column names and
field id's for a form in Remedy?
Thanks,
Bala Patel
ARS 7.03
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_
*IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely for
the entity or individual to whom it is addressed. If you are not the intended
recipient, you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message is strictly prohibited.
Nothing in this email, including any attachment, is intended to be a legally
binding signature.
*
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
