The only way I can think of doing this totally in Remedy would be to walk your existing, now hidden, table (preferably server side) writing unique records to a new Remedy form then displaying the new form records in the table the users see.
Messy but we've probably all done this at some stage!! A better way would be to create a new database view using Natalie's SQL as a guide then create a Remedy view form using your new view. The only complication with this could be the generation of a key field for the Remedy view form. Using the view form for your table will give you the result you need. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ray Palla Sent: 08 April 2013 23:51 To: [email protected] Subject: Re: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** Yup; You're on the right idea, Natalie. Fact is that the table is part of a multi-join and being displayed in another form. I really don't want to use the Direct SQL option for pulling the data for reasons of performance and simple logic. I'm hoping Remedy has a native method for "DISTINCT". Hope. the root of all naivety? J Thanks much for the option. r From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Stroud, Natalie K Sent: Monday, April 08, 2013 5:12 PM To: [email protected] Subject: Re: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** Ray: I don't know if it's possible or even advisable to make Remedy query directly in SQL, but SQL does have the SELECT DISTINCT statement that would do what you are asking. The SQL query would run something like SELECT DISTINCT Assignee FROM Table_name underlying your form. If your table then had 200 tickets assigned to 13 unique Assignees, you'd get the 13 assignees. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA [email protected] ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ray Palla Sent: Monday, April 08, 2013 3:58 PM To: [email protected] Subject: Re: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** We're on SQL latest. r From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Stroud, Natalie K Sent: Monday, April 08, 2013 4:52 PM To: [email protected] Subject: Re: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** What is your underlying DB, SQL or Oracle? Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA [email protected] ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ray Palla Sent: Monday, April 08, 2013 3:38 PM To: [email protected] Subject: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** Monday, Monday; So I have a ticket form with a results list. The query is simple. ('Assignee' != $NULL$) The results list gives me multiples of the same Assignee. Other than grouping the Assignees, is there another way to get a single row for the 'Assignee' field? r Ray Palla Sr. IT/Remedy Consultant http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg Mobile: 512-917-1739 Time Zone: Central Email: <mailto:[email protected]> [email protected] http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif Professional Profile <http://www.linkedin.com/pub/1/544/598> <http://www.INSONA.com> INSONA Corporation 1201 Berry Lane <http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX +77074%2CUSA&hl=en> Georgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image001.jpg>>
<<image002.jpg>>
<<image003.gif>>
