Thanks Carey, this worked!! ----------------------------------------- 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, It will not be stable. (And that is your problem.) Here is what ARS does.. When you do a search a list of 'Request ID' values (and matching Results lists columns) are returned for each row. ( This is the data that populates the Results list in the provided clients. ) When you want to see the "Details" for a record from the Results list then the matching 'Request ID' value is used to select from the ARS form where 'Request ID' = "value1". In your case that second select looks like... SELECT <bla... bla> from FOO where 'Request ID' = '1'. (or some other similar value) However that view likely does not return any records for such a search. Trace the SQL and you should see what I mean. So the root is that you need to be able to do a select statement based on ONLY the 'Request ID' value and get the same data set back each time. You might try this... Maybe it will work, maybe not... please test it out and watch the SUM values carefully. SELECT min(Entry_ID) as Entry_ID , Vendor as VendorName, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM TIP_MONTHLY_BILLING_DATA Group by Vendor, JOURNAL_ENTRY_DATE I think that should return the smallest Entry_ID value from the Group by conditions. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, April 16, 2007 1:19 PM To: [email protected] Subject: Re: View Forms and Reports 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
