If you are using the imbedded Archiving solution for AR System and you are doing an Archive Type of 'Copy to Archive', then creating a join does not make since because the data would still be in the original data form, so no need to a join. However, it you are doing a 'Copy to Archive and Delete form Source' then building a join is a good idea, however, doing a Join and choosing "Request ID" as the join criteria would not work.
The problem is when the data moves to the Archive form the "Request ID" form the original data form is copied into a field called " Original Request ID" and the "Request ID" on the Archive form would never match the "Request ID" on the Original data form, as it gets a new "Request ID" when the record is moved to the Archive. Second, for a join on fields to work there has to be matching data in those fields on both forms. What we did was to include a field called "Form Name" that held the name of the original data form in it and then we did the join criteria on that field. However, you really need to be careful on doing reports off of this join form. I will give you duplicates. For example on one of the Data form to Archive form joins we have the following counts: A_Test_Data: 4,450,400 A_Test_Archive: 34 A_Test_JN: 151,313,600 If you do the math the 151,313,600 equals 4,450,400 x 34. So you really need to make sure when you are doing reports to use a lot of qualifications to eliminate getting duplicate records returned. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: [email protected] We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of jham36 Sent: Tuesday, June 09, 2009 4:13 PM To: [email protected] Subject: Re: Archiving and reporting/searching? I don't think it matters. You can choose any field. I have not tested it, but it should work and should be easy for you to test. I would choose RequestID as the join criteria and an inner join. On Jun 9, 4:41 pm, SUBSCRIBE arslist Melissa <[email protected]> wrote: > What would you use as the join critieria? > > jham36 <[email protected]> > Sent by: "Action Request System discussion list(ARSList)" > <[email protected]> > 06/09/2009 03:39 PM > Please respond to > [email protected] > > To > [email protected] > cc > > Subject > Re: Archiving and reporting/searching? > > How about a join form between the live data and the archived data? > Perform all searches and reports against that. > > James > > On Jun 9, 3:32 pm, SUBSCRIBE arslist Melissa<[email protected]> wrote: > > We are starting to look into how to handle archiving and are running > into > > road blocks with how to be able to search/report on all the data, but > > still archive old data. What are other organizations doing? Does > anyone > > have any white papers or such they can share? We are using ARS 7.1. > > > TIA! > > Melissa > > _______________________________________________________________________________> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:[email protected] ARSlist: "Where the Answers > > Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
