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_ _______________________________________________________________________________ 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>>
