You can create a flag on form like 'Unique?'-->Yes or No. Then in web-service, add the unique flag in qualification.
Now,if records are A A A then change one of records to say A Unique=Yes Thanks Chintan. --- On Sat, 8/7/10, Sam Rx <sam...@gmail.com> wrote: From: Sam Rx <sam...@gmail.com> Subject: Re: WebService get distinct categories back To: arslist@ARSLIST.ORG Date: Saturday, August 7, 2010, 10:27 AM ** 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"_ _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"
