i have seen something very similar .. we had to publish a webservice with unique records however on our form we had duplicates records.
as a workaround..we created a SQL view in the DB (using distinct sql query ).. Created a View form on arserver and then finally created a Webservice on the view form and it worked perfectly.. Thanks, Sam On Fri, Jul 16, 2010 at 3:30 PM, Chintan Shah <[email protected]> wrote: > ** Hello, > > I have a table field that represents a view form. Now, I need to get only > unique rows in that table. > > The problem is for a particular ID(on view form) there could be multiple > email addresses and I want to get DISTINCT email in table field before > walking through it and extracting required infor. I dont see any option > available under "Table/Tree Property" for doing this. > > In a nutshell, here's scenario. > 1. View form pointing to an external DB that holds multiple email addresses > as separate rows for a particular ID(this ID is different from primary key > of table). > 2. A table field that queries this view form with qualification: $ID$='ID'. > 3. Now, this returns a result set that has multiple rows in it with column > name of NAME,EMAIL. > I can do table walk and get required information, but how do I > extract only unique rows? > > e.g. if result set is as below > ID NAME EMAIL SOME OTHER COLUMN > 1 A X Z > 1 B Y Z > 1 A X P > > how can I refine it to just A-X, B-Y? Regardless of value in SOME OTHER > COLUMN, I need to use only A-X,B-Y. > > Basically, I am looking for SQL equivalent of DISTINCT in Remedy that can > be used with Table Field qual. > > Any help is appreciated. > > Thanks > Chintan. > > _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"
