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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
