You beat me to it! I was milling through the database looking at Create Table statements trying to find which table linked the field ID up with the View ID, then I was going to compose something like what you did. Man, I was just too slow! I feel inferior now :\ I couldn't find field_dispprop soon enough...
Oh well, next time I will know it! Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Friday, March 07, 2008 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Find a field by ID ** 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: arslist@ARSLIST.ORG 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 hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
