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 nkst...@sandia.gov<mailto:nkst...@sandia.gov> ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla Sent: Monday, April 08, 2013 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** We're on SQL latest. r From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K Sent: Monday, April 08, 2013 4:52 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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 nkst...@sandia.gov<mailto:nkst...@sandia.gov> ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla Sent: Monday, April 08, 2013 3:38 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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] [cid:image002.jpg@01CE3472.C6127EA0] Mobile: 512-917-1739 Time Zone: Central Email: ray.pa...@insona.com<mailto:ray.pa...@insona.com> [http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif] Professional Profile<http://www.linkedin.com/pub/1/544/598> INSONA Corporation <http://www.INSONA.com>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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.jpg>>
<<inline: image002.jpg>>
<<inline: image003.gif>>
