How many records do you have in that form? What is the query you are using to query the data in that form? Are the columns used in the criteria of that query indexed in the source data?
Joe ________________________________ From: gok's <[email protected]> To: [email protected] Sent: Mon, February 28, 2011 3:45:48 PM Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas Thanks for response Sabyson I worked as you said but when I query any records it is taking a lot of time some times time out error because I need to get related tasks as well and moving the tables which my manger don't want to do it. So i am trying with stored proc to set a parameter value to get the records but is it possible to display the related tasks in the task tab in CHG:Change form. Sabyson Fernandes wrote: > > You can look into creating a Database link between the 6.3 ARSystem > database and the 7.5 ARSystem database. Then create a database SQL view in > the 7.5 database that points to the 6.3 database change form. You can then > create a view form that points to this DB view and you can access the 6.3 > change data from within Remedy 7.5 . > > Sometimes DB links are slow, so for best results I would just copy the > relevant tables into a separate database within the same database instance > as your 7.5 database and create the view form on top of that. > > Hope this helps. > > Saby > > --- On Sat, 2/26/11, gok's <[email protected]> wrote: > >> From: gok's <[email protected]> >> Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help >> me with any ideas >> To: [email protected] >> Date: Saturday, February 26, 2011, 8:15 PM >> My manager didn't want to move the >> data structures in to the 7.5 database he >> want it keep out side but .....user want see only >> CHG:Change tickets from >> that 6.3 data....... >> >> I want to see only to view the CHG:Change tickets in 7.5 >> user tool. >> >> >> >> >> >> Joe Martin D'Souza wrote: >> > >> > If the database doesn't have a running AR Server, why >> not just upgrade it >> > to >> > AR System Server 7.5 by installing one and choosing >> the upgrade option >> > against that database? >> > >> > That way the data structures will be of the same >> version.. >> > >> > I do not have a complete idea of what you are trying >> to achieve - meaning >> > if >> > you want to access this database to just view or >> modify or ?? So if you >> > can >> > give a little more of what you are trying to achieve I >> or someone here >> > might >> > have some better views on how to help you.. >> > >> > Joe >> > >> > -----Original Message----- >> > From: gok's >> > Sent: Saturday, February 26, 2011 1:20 PM Newsgroups: >> >> > public.remedy.arsystem.general >> > To: [email protected] >> > Subject: trying to query ARRemedy 6.3 data from >> ARserver 7.5.....help me >> > with any ideas >> > >> > Hi All, >> > >> > I am trying to query or to search by based on CHG >> request id from ARSystem >> > 6.3 to ARSystem 7.5. here ARSystem_6_3 database didn't >> have any ARServer >> > and >> > Mid-tier so I am trying to use Java API ..Here I want >> some information >> > regarding whether I can get the chg ticket information >> like related tasks >> > and attachments to ARSystem 7.5. >> > >> > >> > Thanks for replies >> > >> > >> >_______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org >> > attend wwrug11 www.wwrug.com ARSList: "Where the >> Answers Are" >> > >> > >> >> -- >> View this message in context: >>http://old.nabble.com/trying-to-query-ARRemedy-6.3-data-from-ARserver-7.5.....help-me-with-any-ideas-tp31021215p31021745.html >>l >> Sent from the ARS (Action Request System) mailing list >> archive at Nabble.com. >> >> >_______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers >> Are" >> > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > -- View this message in context: http://old.nabble.com/trying-to-query-ARRemedy-6.3-data-from-ARserver-7.5.....help-me-with-any-ideas-tp31021215p31035969.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
