[Arsperl-users] Database fields vs ars fields

[Bowman, B. A <Bow...@st...>]

Hello all,

I've got questions concering the fields in a form versus how they are =
stored in the database.  I've found some inconsistancies.

When using the ars_perl commands:

	@fieldidlst =3D ars_GetListField($c,$schema,0,1);

and=20

	%field_hash=3Dars_GetFieldTable($c,$schema);

I can get a good list of the fields in a form.

When comparing this list to the view and table in Oracle, I have =
different results.

Lets take the example that I'm working with: We are using the SAM =
(Software Asset Management) Remedy product. for it's AST:Asset form, I =
am trying to pull back the field:

'Application ID' which has a database name of 'Application GUID' or =
'Application_GUID' in SQL.  It's database ID is '400081600'

This field is in the form, but it is not in the Oracle table "AST_ASSET" =


It also does not appear in the table designaetd in the arschema lookup =
table (T2022) which (I beleive) would be 'C400081600'.

When loking in the Remedy Admin tool, the field looks like any other =
field, but for some reason, it is not stored in the same place with the =
other fields.

Why is this different and where can I find this field to get it's data =
in Oracle?


Thanks,

Brent

 =20