Tim, I had encountered similar issue and I created a Database view using Distinct Clause in the SQL for the DB view, created a view form based on the DB View and finally a Webservice on the view form. Getlist operation on the view form is going to you unique records.
hope this helps... Thanks, Sam On Fri, Aug 6, 2010 at 8:20 PM, Tim Rondeau <tim.rond...@phaseforward.com>wrote: > ** > > Trying to create a webservice that gives back all categories, but I need to > get the distinct list for example. > > > > We have: > > > > Account > > Account > > Account > > Build > > Build > > Build > > > > I only want back > > > > Account > > Build > > > > Then will look up Sub-Category and then Action > > > > > > > > 7.1 Patch 7 Windows > > > > > > Thanks > > > > Tim > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"