**

Hi All
Does anyone know how to produce a list of Field IDs, Label Names and
Database Names for a form?

Thanks
Pete

**

Pete,

Use Les Ganton's ARS Utilities and for $99 report on
any Remedy Object and a ton more!!

Here is the link to download eval:
http://members.rogers.com/l.ganton/welcome.html

Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of Peter Joran
Sent: Friday, September 20, 2002 12:02 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Field IDs and Names


**

Hi All
Does anyone know how to produce a list of Field IDs, Label Names and
Database Names for a form?

Thanks
Pete



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Peter

You will need to perform a SQL join on tables arschema and field. (Join on
the schemaid)

'arschema' has the schema/form names and schemaid
'field' has the schemaid, field id and field name.

SQL from MS Access

SELECT ARADMINARSCHEMA.NAME, ARADMINARSCHEMA.SCHEMAID,
ARADMINFIELD.FIELDID, ARADMINFIELD.FIELDNAME
FROM ARADMINARSCHEMA INNER JOIN ARADMINFIELD ON ARADMINARSCHEMA.SCHEMAID
= ARADMINFIELD.SCHEMAID;

Email me if you have any questions.

Take Care

Dale Jones
Director of Remedy Consulting
ARFOCUS/DCS
Raleigh, North Carolina
dale@dcsseattle.com
www.arfocus.com
www.dcsseattle.com
Mobile Phone 919-523-6034
Raleigh Office 919-866-1781
Seattle Head Office 1-800-345-1275
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of Peter Joran
Sent: Friday, September 20, 2002 3:02 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Field IDs and Names


**

Hi All
Does anyone know how to produce a list of Field IDs, Label Names and
Database Names for a form?

Thanks
Pete



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Hi Pete

Try ARUtilities.
http://members.rogers.com/l.ganton/welcome.html

Les

>
> From: Peter Joran
> Date: 2002/09/20 Fri PM 03:02:03 EDT
> To: ARSLIST@LISTSERV.QMXS.COM
> Subject: Field IDs and Names
>
> **
>
> Hi All
> Does anyone know how to produce a list of Field IDs, Label Names and
> Database Names for a form?
>
> Thanks
> Pete
>
>
>
>
>

1

**

Pete,

You didn't say what database you on, The inner join won't work with oracle.

Mike


-----Original Message-----
From: Dale Jones (DCS) [mailto:dale@DCSSEATTLE.COM]
Sent: Friday, September 20, 2002 3:31 PM
To: ARSLIST@listserv.qmxs.com
Subject: Re: Field IDs and Names


**

Peter

You will need to perform a SQL join on tables arschema and field. (Join on
the schemaid)

'arschema' has the schema/form names and schemaid
'field' has the schemaid, field id and field name.

SQL from MS Access

SELECT ARADMINARSCHEMA.NAME, ARADMINARSCHEMA.SCHEMAID,
ARADMINFIELD.FIELDID, ARADMINFIELD.FIELDNAME
FROM ARADMINARSCHEMA INNER JOIN ARADMINFIELD ON ARADMINARSCHEMA.SCHEMAID
= ARADMINFIELD.SCHEMAID;

Email me if you have any questions.

Take Care

Dale Jones
Director of Remedy Consulting
ARFOCUS/DCS
Raleigh, North Carolina
dale@dcsseattle.com
www.arfocus.com
www.dcsseattle.com
Mobile Phone 919-523-6034
Raleigh Office 919-866-1781
Seattle Head Office 1-800-345-1275
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of Peter Joran
Sent: Friday, September 20, 2002 3:02 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Field IDs and Names


**

Hi All
Does anyone know how to produce a list of Field IDs, Label Names and
Database Names for a form?

Thanks
Pete



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

If using oracle, try

SELECT ARADMIN.ARSCHEMA.NAME, ARADMIN.ARSCHEMA.SCHEMAID,
ARADMIN.FIELD.FIELDID, ARADMIN.FIELD.FIELDNAME
FROM ARADMIN.ARSCHEMA, ARADMIN.FIELD WHERE ARADMIN.ARSCHEMA.SCHEMAID
= ARADMIN.FIELD.SCHEMAID;




once you determine what the schema id:

SELECT ARADMIN.ARSCHEMA.NAME, ARADMIN.ARSCHEMA.SCHEMAID,
ARADMIN.FIELD.FIELDID, ARADMIN.FIELD.FIELDNAME
FROM ARADMIN.ARSCHEMA, ARADMIN.FIELD WHERE ARADMIN.ARSCHEMA.SCHEMAID
= ARADMIN.FIELD.SCHEMAID AND ARADMIN.ARSCHEMA.SCHEMAID=?;

? = ID number


Mike

-----Original Message-----
From: Dale Jones (DCS) [mailto:dale@DCSSEATTLE.COM]
Sent: Friday, September 20, 2002 3:31 PM
To: ARSLIST@listserv.qmxs.com
Subject: Re: Field IDs and Names


**

Peter

You will need to perform a SQL join on tables arschema and field. (Join on
the schemaid)

'arschema' has the schema/form names and schemaid
'field' has the schemaid, field id and field name.

SQL from MS Access

SELECT ARADMINARSCHEMA.NAME, ARADMINARSCHEMA.SCHEMAID,
ARADMINFIELD.FIELDID, ARADMINFIELD.FIELDNAME
FROM ARADMINARSCHEMA INNER JOIN ARADMINFIELD ON ARADMINARSCHEMA.SCHEMAID
= ARADMINFIELD.SCHEMAID;

Email me if you have any questions.

Take Care

Dale Jones
Director of Remedy Consulting
ARFOCUS/DCS
Raleigh, North Carolina
dale@dcsseattle.com
www.arfocus.com
www.dcsseattle.com
Mobile Phone 919-523-6034
Raleigh Office 919-866-1781
Seattle Head Office 1-800-345-1275
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of Peter Joran
Sent: Friday, September 20, 2002 3:02 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Field IDs and Names


**

Hi All
Does anyone know how to produce a list of Field IDs, Label Names and
Database Names for a form?

Thanks
Pete



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Field labels are VUI-dependent, so if you want to get those, too,
you'll need to look in the FIELDDISPPROP table. Warning: It isn't
friendly to humans in there. ;-)

Attached are some Oracle scripts that show how to retrieve the label
name for a given schema, view, and field ID.

--Tim

--- "DeBord, Mike - contractor" wrote:
> **
>
> If using oracle, try
>
> SELECT ARADMIN.ARSCHEMA.NAME, ARADMIN.ARSCHEMA.SCHEMAID,
> ARADMIN.FIELD.FIELDID, ARADMIN.FIELD.FIELDNAME
> FROM ARADMIN.ARSCHEMA, ARADMIN.FIELD WHERE ARADMIN.ARSCHEMA.SCHEMAID
> = ARADMIN.FIELD.SCHEMAID;
>
>
>
>
> once you determine what the schema id:
>
> SELECT ARADMIN.ARSCHEMA.NAME, ARADMIN.ARSCHEMA.SCHEMAID,
> ARADMIN.FIELD.FIELDID, ARADMIN.FIELD.FIELDNAME
> FROM ARADMIN.ARSCHEMA, ARADMIN.FIELD WHERE ARADMIN.ARSCHEMA.SCHEMAID
> = ARADMIN.FIELD.SCHEMAID AND ARADMIN.ARSCHEMA.SCHEMAID=?;
>
> ? = ID number
>
>
> Mike
>
> -----Original Message-----
> From: Dale Jones (DCS) [mailto:dale@DCSSEATTLE.COM]
> Sent: Friday, September 20, 2002 3:31 PM
> To: ARSLIST@listserv.qmxs.com
> Subject: Re: Field IDs and Names
>
>
> **
>
> Peter
>
> You will need to perform a SQL join on tables arschema and field.
> (Join on
> the schemaid)
>
> 'arschema' has the schema/form names and schemaid
> 'field' has the schemaid, field id and field name.
>
> SQL from MS Access
>
> SELECT ARADMINARSCHEMA.NAME, ARADMINARSCHEMA.SCHEMAID,
> ARADMINFIELD.FIELDID, ARADMINFIELD.FIELDNAME
> FROM ARADMINARSCHEMA INNER JOIN ARADMINFIELD ON
> ARADMINARSCHEMA.SCHEMAID
> = ARADMINFIELD.SCHEMAID;
>
> Email me if you have any questions.
>
> Take Care
>
> Dale Jones
> Director of Remedy Consulting
> ARFOCUS/DCS
> Raleigh, North Carolina
> dale@dcsseattle.com
> www.arfocus.com
> www.dcsseattle.com
> Mobile Phone 919-523-6034
> Raleigh Office 919-866-1781
> Seattle Head Office 1-800-345-1275
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of Peter Joran
> Sent: Friday, September 20, 2002 3:02 PM
> To: ARSLIST@LISTSERV.QMXS.COM
> Subject: Field IDs and Names
>
>
> **
>
> Hi All
> Does anyone know how to produce a list of Field IDs, Label Names and
> Database Names for a form?
>
> Thanks
> Pete
>
>

>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@arslist.org
> You may also control your subscription options, including
> UNSUBSCRIBE, at
> www.ARSLIST.org
>
>

>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@arslist.org
> You may also control your subscription options, including
> UNSUBSCRIBE, at
> www.ARSLIST.org
>
>

> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@arslist.org
> You may also control your subscription options, including
> UNSUBSCRIBE, at www.ARSLIST.org




Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!




http://sbc.yahoo.com

**

If you have ARS 5.0.1 you can just use the Data Dictionary Menu. You can
keep track of all forms and the field name and IDs in a remedy form. It
might take up front work but once done you have many options to future use.,

If you are not up on ARS 5.x the other solutions are there for you.

Basia

Peter Joran wrote:

>**
>
>Hi All
>Does anyone know how to produce a list of Field IDs, Label Names and
>Database Names for a form?
>
>Thanks
>Pete
>
>
>
>
>
>.
>
>
>

**

On Fri, 20 Sep 2002 13:18:04 -0700, Tim Widowfield wrote:

>**
>
>Field labels are VUI-dependent, so if you want to get those, too,
>you'll need to look in the FIELDDISPPROP table. Warning: It isn't
>friendly to humans in there. ;-)
>
>Attached are some Oracle scripts that show how to retrieve the label
>name for a given schema, view, and field ID.

Would you like to explain these for those of us Oracally challenged?
:-)

--
Regards

Dave Saville
Please note new email address dave.saville@ntlworld.com

**
This isnt as complicated as it is made to sound.

Its really simple actually if you want to take just a 'ariel' view. The whole funda behind this table FIELDDISPPROP is to store the 'property' information for every field that is created in a ARS form. The property information is stored in a column called propShort and has info typical to what is shown below:

15\3\41\2\3600\29100\22275\31200\20\4\10\Request ID\28\6\4\29\6\1\27\8\16\61\40\16\60\40\1\4\6\0\7\40\2147483648\143\40\4294967295\170\40\0\21\41\2\0\400\7537\2100\151\41\2\8100\0\18675\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\

Ok, so that wasn't too short was it! :-)

The '\' separates various parameters such as X-coordinate, Y-coordinate, field display length, Display name, etc stored in a fixed logical order, which the ARS API calls via the Admin tool intepretes when opening any view of the form and displays on your screen when you display the properties of any field.

I have not really found it of any use so far of knowing what that logical order in which it stores the information, but I'm sure if you are interested the guys at Remedy may help with some info... Hmmmm is Doug listening to this thread?? :-) For interest sake it may be interesting know how the values in this field propShort is intepreted by the ARS engine...

My 1 and a half cent....

Joe DeSouza,
CyberMAK Information Systems
Kuwait.

Quote of the month:
You see things that are and say, "Why?" but I dream things that never were and say, "Why not?!!"

-------Original Message-------

From: arslist@ARSLIST.ORG
Date: Saturday, September 21, 2002 02:19:37 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Field IDs and Names

**

On Fri, 20 Sep 2002 13:18:04 -0700, Tim Widowfield wrote:

>**
>
>Field labels are VUI-dependent, so if you want to get those, too,
>you'll need to look in the FIELDDISPPROP table. Warning: It isn't
>friendly to humans in there. ;-)
>
>Attached are some Oracle scripts that show how to retrieve the label
>name for a given schema, view, and field ID.

Would you like to explain these for those of us Oracally challenged?
:-)

--
Regards

Dave Saville
Please note new email address dave.saville@ntlworld.com




.