In a Filter I don't think it really matters. In an Active Link it depends on what you want to see if you have multiple values returned and want a list. Using the View form will bring up the search results fields for that form while an SQL will bring back the SQL you specified. If you have different requirements on fields to see in the pick list window I would use SQL (i.e. In one place you need fields a,b,c and in another you need fields a,d,e). Other than that I use the standard set fields.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Friday, January 29, 2010 9:58 AM To: [email protected] Subject: View vs SQL ** Hi All, I have a set fields filter with a Read Value for Field From a view form in Remedy. The view form references a single database table. Is there any advantage to using the view form rather than just using a SQL statement. My guess is that if you don't know SQL use the view. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark ____________________________________________ Mark Brittain Remedy Developer NaviSite [email protected] (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
