Hi guys,

I am fairly new to Remedy. I am currently using the Java API and have run into problems with the ARGetListSQL function in the com.remedy.arsys.api.Util. The method expects a valid SQL statement. I was able to run something like "SELECT * FROM <MYSCHEMANAME>". But when I try to retrieve data for a particular field using the FieldID it doesn't work.
Say I have field called "Customer" with internal ID "10008". If I try "SELECT 10008 FROM <MYSCHEMANAME>" it fails (well actually it returns a result array containing 10008 in all rows), only if I do "SELECT Customer FROM <MYSCHEMANAME>" I get what I want.

Now my problem is that I haven't found a way to obtain the field name (i.e. Customer) on the basis of the internal field ID (say 10008).

Help would be greatly appreciated !

Thanks,

MacD