[Arsperl-users] Database fields vs ars fields
Brought to you by:
jeffmurphy
|
From: Bowman, B. A <Bow...@st...> - 2006-03-09 16:45:11
|
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 |