I would also recommend querying the "ARSCHEMA" table to get the "View Name" and then in the next action use that view name.
Example: Action 1: SELECT ViewName FROM ARSCHEMA WHERE NAME = '$SCHEMA$' Action 2: UPDATE $ViewName$ SET ........WHERE.... Thanks Mahesh On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing <[email protected]> wrote: > ** > > That is always a chance…but I would trust archgid more than I would trust > me doing it manually….and I agree with your assessment, TID should NEVER be > used in direct SQL….I ALWAYS recommend using View names instead of table > ids….still fragile, but less so that table id J > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Guillaume Rheault > *Sent:* Wednesday, July 28, 2010 9:50 AM > > *To:* [email protected] > *Subject:* Re: ARS v7.5 - importing forms changed Table ID > > > > ** > > interesting, I forgot about that one... > I've used archgid to change field IDs only. Never tried for a form/table > ID. Not sure if I would use it though...if it's one of those features that > are not heavily used, you may end up finding an undocumented feature! > > Guillaume > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [ > [email protected]] on behalf of LJ LongWing [[email protected]] > *Sent:* Wednesday, July 28, 2010 11:46 AM > *To:* [email protected] > *Subject:* Re: ARS v7.5 - importing forms changed Table ID > > ** > > You could use archgid, it can change table ID’s too….it goes through the > system and updates all appropriate references…..while I’ve never used it for > forms, I have used it for fields successfully in the past. Do a search for > recent posts regarding where to get the latest version from the jar files > J > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Susan Palmer > *Sent:* Wednesday, July 28, 2010 9:22 AM > *To:* [email protected] > *Subject:* ARS v7.5 - importing forms changed Table ID > > > > ** > > Hi Everyone, > > > > We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five > months was enough time to waste on that. Yes, we tried everything ... > that's not my question here today. > > > > Sooooo, we decided to build a new server (vm) and start from scratch with a > brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in > this process at all. > > > > Then I exported forms and other workflow objects and did the imports. Kind > of a long job because the new server database is on a very slow SAN (nothing > I can fix right now). > > > > It had not occurred to me that I would loose my original Table ID > associated with that form on another server. This is a problem since there > is workflow with SQL statements which of course I can change. But, we also > have numerous programs pulling data from Remedy that use the Table ID's > created by another development group. This would require them to change > their programs, possibly dblinks etc. Not a prospect I'm looking > forward to. > > > > I've only imported data in a couple of forms so far (12 hours worth) and > don't want to proceed if I'm going to delete it anyway. I'm using rrrChive > for the data and thankfully it's bringing over the correct field 1 values. > I do have to figure out how to use rrrChive to include a date modified > parameter to get updates. > > > > Has anyone been successful at changing a Table ID and how did you do it? > Were there any ramifications? > > > > Appreciate your help, thanks, > > > > Susan > > > > Oracle 10g > > ARS 7.5P3 > > Solaris 10 > > > > Susan Palmer > > ShopperTrak > > 200 W Monroe St Floor 11 > > Chicago, IL 60606 > > 312-529-5325 > > [email protected] > > > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
