If you just need to know the name and what views it is in, I would just
run something like this in SQL:
select
f.fieldid,
f.fieldname,
s.[name] as formname,
v.vuiname as viewname
from field f
inner join arschema s
on s.schemaid = f.schemaid
inner join vui v
on s.schemaid = v.schemaid
inner join field_dispprop fp
on s.schemaid = fp.schemaid
and f.fieldid = fp.fieldid
where s.[name] = 'HPD:Help Desk'
and f.fieldid = '1000000715'
Obviously, this can be tweaked to provide more or less data, but I find
it very useful to go straight to the database to find some things like
this.
I hope this helps,
Shawn Pierson
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Melissa
Sent: Friday, March 07, 2008 9:04 AM
To: [email protected]
Subject: Find a field by ID
**
This may be a silly question, but how can I find a field by the ID
number if it's not in the view? Looking for a field on HPD:HelpDesk by
the Field ID and it's not in the FindID drop down.
Thanks!
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___
Private and confidential as detailed here:
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the
link, please e-mail sender.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
