Hi,

At the API level fields are typically identified by form name and id, so
if you wanted the other way around -- it would have been very simple --
get the field object using the key (form name & field id), once you have
it, do a getter on Name property! In pre-7.1 API, it is
FieldFactory.findByKey method and in 7.1, it would simply be
ARServerUser.getField.

Now, if you have field name and want to lookup for its id --- here is
what you do: you get all the fields of the form, iterate over each
field, find the one that matches name & get its id. To do this
FieldFactory.findObjects is of interest in pre7.1. In 7.1, it would be
ARServerUser.getListFieldObjects.  Of course if you wanted more direct
way, you could do GetListSQL API call along the lines of (however I
usually prefer the API calls rather than direct SQL):

SELECT f.fieldName, s.schemaId, f.fieldId  
FROM field f,  arschema s 
WHERE f.schemaId = s.schemaId 
   AND s.name = 'User' 
   AND f.fieldName = 'Request ID'

Regards
Appajee

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Reply via email to