I would go with creating a DB view too as its simpler and not too hard to maintain..
Joe ________________________________ From: Sam Rx <[email protected]> To: [email protected] Sent: Fri, July 16, 2010 6:26:21 PM Subject: Re: SQL equivalent of DISTINCT in Remedy ** 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
