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"

Reply via email to