I do have around 85,370 records .... But I switched to use the vendor form hope this works.
Joe DeSouza wrote: > > 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" > -- 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-tp31021215p31046539.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"
