I'm creating my own entry id in the SQL statement: SELECT min(ROWNUM) as Entry_ID,
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, April 16, 2007 1:09 PM To: [email protected] Subject: Re: View Forms and Reports Lisa, You should be able to do this. However there are a few conditions that must be true for it to work correctly. What do DB value you have mapped to the 'Request ID' in the ARS form? A) This value must be "stable". ( The same value will always be returned for a given row in the view. ) B) This value must be unique in the set of data that the view exposes to ARS. ( No other row should have that same value for it's 'Request ID'.) C) This value must be 15 characters or less in length. My guess is that you violated one of the above conditions. ( Most likely part A, or C.) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 4/16/07, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > ** > > I created a SQL View and also created a View Form in Remedy to get the > data from the SQL View. When I try to run a simple report in Remedy > against the new View Form I am getting "ARERR (302) Entry does not > exist in the database" > > Does that mean we cannot run a simple .csv report from a View Form > linked to a SQL View? > > Thanks in advance! > > We are running: > ARsystem 6.3 patch 21 > Oracle > > Lisa Kemes ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
