-- Drew ique index? Not sure if it will work on a view form.
Drew Comayagua > > On Fri, Jul 16, 2010 at 2:53 PM, jham36 <[email protected]> wrote: >> I'm thinking that a join form might work. I'm going to check the >> documentation on inner and outer joins. Maybe join the view form to >> itself. Then use the join form in your table field. >> >> James >> >> On Jul 16, 4: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 atwww.arslist.org >>> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > > > > -- > Drew > -- Drew _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
