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"

Reply via email to