ARS 6.3 patch 20 HD 6 Windows 2003 Oracle 10g I created a Remedy view form so that I could access an Oracle view and pull the data into a new remedy form. The Oracle view consists of 3 oracle tables linked together by field DocNum. The Oracle view has a sequence number that gets pushed to the request id field of the new remedy form. Sequence number was added so that I have a unique value to push to the Remedy view form.
Here's what happens. I open the Remedy View form and search on Request Id 9862 (sequence number from oracle). The fields in the View form fill in from the query, but the fields listed in the results list does not match the data displayed on the View form fields. The request id field is the same on the View form and the results list, however, but all the other fields displayed on the results list (5 of them, including DocNum) are different that the data displayed in the fields. If I search on a DocNum instead of Request Id the data appears in the results list, but the DocNum is different than what I searched on. Again, the request id is correct but the other fields in the results list are not the same as those in the fields. How can this be fixed so that the results list fields data matches the data displayed on the field on the form? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
