Thanks Joe and James. Excellent suggestions. Larry
On Wed, Aug 21, 2013 at 4:53 PM, Joe D'Souza <[email protected]> wrote: > ** > > Directly in the DB and then to keep the rest of the stuff more at ARS > level, build a view form on top of that view. Then do a join the ARS way. > So the only external dependency would be the creation of that distinct > listing by way of the view. (Create view as select distinct…..)**** > > ** ** > > So step one would be create that view. Step two would be create a view > form in the Remedy system feeding off from that DB view that you created. > And Step 3 would be to create the join.**** > > ** ** > > ALTERNATELY you could create the entire view at DB level including the > inner join as James suggested and then create a View form on top of that. > That however would mean that the view would depend on 2 forms so changes on > any of those two forms could impact that DB view.**** > > ** ** > > Personally I would go with the less impact – create view of the form that > needs that distinct listing (first method described here).. That method > would impact the view only if you make changes to the form that the view is > based out of by renaming field names.**** > > ** ** > > Cheers**** > > ** ** > > Joe**** > > ** ** > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *L G Robinson > *Sent:* Wednesday, August 21, 2013 4:37 PM > *To:* [email protected] > *Subject:* Re: Join form question**** > > ** ** > > ** **** > > Hi Joe,**** > > ** ** > > Thanks for the reply. This "create a view containing distinct values of B" > sounds intriguing. Is that something I can do with Dev Studio or do I have > to create that directly on the DB? I didn't see anything in the view > properties in Dev Studio.**** > > ** ** > > Thanks.**** > > Larry**** > > ** ** > > On Wed, Aug 21, 2013 at 4:06 PM, Joe D'Souza <[email protected]> wrote:*** > * > > ** **** > > It appears like you are looking for a join between A and distinct of B, > which is only possible if you customize your system such that you actually > create a view containing distinct values of B, and then use that to create > a join with A.**** > > **** > > Otherwise as far as the AR System is concerned that second or third or > fourth row it might see of 100 if you had that many, are separate rows. No > way for it to know that you are seeking for distinct values.**** > > **** > > Joe**** > > **** > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *L G Robinson > *Sent:* Wednesday, August 21, 2013 2:14 PM > *To:* [email protected] > *Subject:* Join form question**** > > **** > > ** **** > > Hi Folks,**** > > **** > > I need some help with a join. I'm not sure if this is possible or not.**** > > **** > > In simple terms, I have two forms, Form A and Form B**** > > **** > > They have one field in common, lets call it X.**** > > **** > > Form A has the following values for X:**** > > 100**** > > 200**** > > 300**** > > **** > > Form B has two fields X and Y.**** > > There may be multiple entries in Form B where X is repeated:**** > > **** > > X Y**** > > 100 20**** > > 100 20**** > > 100 30**** > > 200 30**** > > 200 30**** > > 200 40**** > > 300 20**** > > **** > > Is there a way to join these two forms together so that if I search for > Y=20 I will get this:**** > > **** > > X**** > > 100**** > > 300**** > > **** > > instead of this:**** > > **** > > X**** > > 100**** > > 100**** > > 300**** > > **** > > I have tried a number of variations on inner/outer and switching primary > but I haven't been able to get what I want.**** > > **** > > Thanks for any suggestions you may have.**** > > Larry**** > > **** > > ARS: 7.6.04 SP3 201201302357 on Solaris 10**** > > Oracle 11.2.0.3.0**** > > **** > > **** > > Larry Robinson**** > > Remedy Developer/Admin**** > > NC State University**** > > Raleigh, NC**** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > > ** ** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

