Some of the joins that Remedy creates when you create joins are extremely inefficient as far as performance is concerned. I wish I had a ready example but I don't
We had re-written these to more efficient UNION joins after creating them from the Admin interface. Re-writing the join doesn't break the original form so long as the join has all the fields referenced. All queries including updates worked after I had this done.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of LJ LongWing Sent: Wednesday, September 01, 2010 5:13 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms ** I know there is some sort of limit on modifying/deleting records if there is a join/union involved..don't know the specifics.but best case scenario.you can try and let us know the outcome J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, September 01, 2010 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms ** Even if it is a union you can.. Been there done that.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of LJ LongWing Sent: Wednesday, September 01, 2010 4:49 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms ** As long as it isn't a UNION, I think you can.. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, September 01, 2010 2:28 PM To: arslist@ARSLIST.ORG Subject: View Forms ** I have a rather complicated Join that I would like to do on 2 AR Forms. If I create a View (joining 2 AR Forms on the database) and put a View Form on top of it, would I still be able to change the data from the AR View Form? Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-602-9460 cell lisa.ke...@te.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
