**

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




.

**

"Logical order" isn't important. What is import is the finding the
integer that refers to the property you want. For instance, a little
detective work shows that 20 refers to field label and while 4 refers
to a visible property. In your example...

20\4\10\Request ID

...cues the parsing engine that the next item is a field label, which
is visible and is 10 characters long.

It's better, of course, to use the APIs to get this data, since Remedy
could change how things are stored whenever they like -- it's
proprietary. The APIs shield you from this complexity and allow you to
retrieve the data in a meaningful structure.

--Tim

--- Joe DeSouza wrote:
> **
>
> 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\429496
>
295\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
>
>

>
> 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

**

Sure thing, Dave.

I know from experimentation that the field label can be found after
20\4\. Once I find it I look to the right until I find another
backslash. The integer that follows 20\4\ and the field label string
itself is a number that indicates the length of the string.

The INSTR and SUBSTR functions are simply string functions like STRSTR
and SUBSTR in ARS. Because Remedy has been known to store property
data in the PROPLONG column (a CLOB field), we can't use the simple
INSTR and SUBSTR functions. Instead, we have to use dbmslob.INSTR and
dbmslob.SUBSTR.

--Tim


--- Dave Saville wrote:
> **
>
> 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
>
>

> 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

**
Tim,

Thanks, useful information. Don't think it would make sense for them to change the way the information is structured. If they do, it would make it more difficult for them to revise their upgrade script for a new version to convert all that information to a new pattern.

While on this topic the same can be said about the way the run-if statements are stored in the workflow bits (AL's, filters, Escalations and qualifications in Menus). Theres a pattern there too and I do not think it has changed over the previous version, just additions have been made to fit in the new data types and other additions on KEYWORDS etc...

None-the-less, going the API way would definitely mean less pains...

Joe DeSouza,
CyberMAK Information Systems
Kuwait.


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

From: arslist@ARSLIST.ORG
Date: Sunday, September 22, 2002 11:37:45 AM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Field IDs and Names

**

"Logical order" isn't important. What is import is the finding the
integer that refers to the property you want. For instance, a little
detective work shows that 20 refers to field label and while 4 refers
to a visible property. In your example...

20\4\10\Request ID

....cues the parsing engine that the next item is a field label, which
is visible and is 10 characters long.

It's better, of course, to use the APIs to get this data, since Remedy
could change how things are stored whenever they like -- it's
proprietary. The APIs shield you from this complexity and allow you to
retrieve the data in a meaningful structure.

--Tim

--- Joe DeSouza < joe.cybermak@MAKHARAFI.NET> wrote:
> **
>
> 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\429496
>
295\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
>
>

>
> 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




.

**

On Sat, 21 Sep 2002 14:20:54 +0300, Joe DeSouza wrote:

>**
>
>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\429496
>295\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...

Yes, I knew that much as I have tried to decode this stuff in the
past. I did ask Remedy once and got the reply that all the info was
in the *.h files. If it is I could not find it :-(

To my mind the \20\4 code that the examples seem to use to find the
names occur in more places than in front of the names. Also I have
seen different \codes in front of what I know to be field names in
various views.

--
Regards

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

**

On Sat, 21 Sep 2002 22:21:07 -0700, Tim Widowfield wrote:

>**
>
>"Logical order" isn't important. What is import is the finding the
>integer that refers to the property you want. For instance, a little
>detective work shows that 20 refers to field label and while 4 refers
>to a visible property. In your example...



The murk cleareth. I got as far as finding the 20s, and knew the next
but one was the length, but never twigged that the second digit was
visibility state so was confused by 20\severalthings and kinda gave
up at that point as I had more important things to do :-)

Thanks for the clarification.

--
Regards

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

**

To be exact, the "4" isn't a property but the datatype. So the line "20\4\10\Request ID" means something like "Property 20, Datatype 4 (Character) datalength 10". After that the actual string of length 10 follows. You can find some clues on what follows after the datatype by looking at the ar.h file and the ARValueStruct (if i'm correct).

Regards,

Hugo

-----Original Message-----
From: Tim Widowfield [mailto:widowfield@YAHOO.COM]
Posted At: zondag 22 september 2002 7:21
Posted To: ARS List
Conversation: Field IDs and Names
Subject: Re: Field IDs and Names


**

"Logical order" isn't important. What is import is the finding the
integer that refers to the property you want. For instance, a little
detective work shows that 20 refers to field label and while 4 refers
to a visible property. In your example...

20\4\10\Request ID

...cues the parsing engine that the next item is a field label, which
is visible and is 10 characters long.

It's better, of course, to use the APIs to get this data, since Remedy
could change how things are stored whenever they like -- it's
proprietary. The APIs shield you from this complexity and allow you to
retrieve the data in a meaningful structure.

--Tim

--- Joe DeSouza wrote:
> **
>
> 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\429496
>
295\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
>
>

>
> 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

**

You're absolutely correct... I was trying to do it from memory. :-o

Also, button labels are stored in 110 (PropInfo.ARDPROPBUTTONTEXT)
instead of 20 (PropInfo.ARDPROPLABEL), which confused me quite a bit
at first when I was writing GetLabels.py.

(See http://www.widowfield.com/jython/jythonsamples.html)

--Tim

--- ARS-List wrote:
> **
>
> To be exact, the "4" isn't a property but the datatype. So the line
> "20\4\10\Request ID" means something like "Property 20, Datatype 4
> (Character) datalength 10". After that the actual string of length 10
> follows. You can find some clues on what follows after the datatype
> by looking at the ar.h file and the ARValueStruct (if i'm correct).
>
> Regards,
>
> Hugo
>
> -----Original Message-----
> From: Tim Widowfield [mailto:widowfield@YAHOO.COM]
> Posted At: zondag 22 september 2002 7:21
> Posted To: ARS List
> Conversation: Field IDs and Names
> Subject: Re: Field IDs and Names
>
>
> **
>
> "Logical order" isn't important. What is import is the finding the
> integer that refers to the property you want. For instance, a little
> detective work shows that 20 refers to field label and while 4 refers
> to a visible property. In your example...
>
> 20\4\10\Request ID
>
> ...cues the parsing engine that the next item is a field label, which
> is visible and is 10 characters long.
>
> It's better, of course, to use the APIs to get this data, since
> Remedy
> could change how things are stored whenever they like -- it's
> proprietary. The APIs shield you from this complexity and allow you
> to
> retrieve the data in a meaningful structure.
>
> --Tim
>
> --- Joe DeSouza wrote:
> > **
> >
> > 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\429496
> >
>
295\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
> >
> >
>

> >
> > 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
>
>

> 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