Doug,
I just exported one of the default view forms 'AR System Metadata: field'.
Looking at it I found this section
<compoundForm>
<viewForm>
<tableName>field</tableName>
<keyFieldName>recordId</keyFieldName>
</viewForm>
</compoundForm>
tableName is the view/table that the view form is based on
keyFieldName is the 'requestID' of the view form.
In your case, you stated you need to move your table to a new DB. Depending
on the value in here.you may be looking at a local view of a remote
table..if that's the case then you will need to change the view definition
(at the db, not in Remedy)..but this information above should be able to at
least tell where your form is pointed (which you should already know by
looking at it through the DevStudio)..if you need to change this value I
believe you could change it here.then re-import it.I'm sure that's not
supported by BMC, but I believe it works J
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Anderson, Doug
Sent: Monday, January 23, 2012 7:42 AM
To: [email protected]
Subject: Re: Moving the database to which a view form links?
**
Hi Fred, LJ, et al.,
Fred, we're on MS SQL. I see the table name in the View Info tab of the form
properties but it gives no clue as to the database & server.
LJ, you suggested the XML version of the table definition would show the
old connection. I exported to xml and there is no evidence of the database
name or the database server name in the resulting file.
I exported workflow database calls to discover the old server name.
However, knowing that doesn't help me change it in an ARS-friendly way.
Thanks again for any suggestions on where/how to change the view form's
target database.
Doug
Original message:
Date: Fri, 20 Jan 2012 22:20:00 +0000
From: "Grooms, Frederick W" <[email protected]>
Subject: Re: Moving the database to which a view form links?
In the Admin tool the Form Properties -> View Information tab lists the
source for the data (in the Table Name field).
What database are you using?
Fred
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Anderson, Doug
Sent: Friday, January 20, 2012 3:42 PM
To: [email protected]
Subject: Moving the database to which a view form links?
**
Hi All,
I've inherited a view form that points to a table in a non-ARS database.
That database needs to move to a different server. I've never had to do this
before.
This is on ARS 7.1 patch 6.
I've looked through the manuals & I see where the path is set when creating
a view form. What I don't see is where & how to change that path for an
existing view form.
I've queried the schema_view table and don't see it there. I've exported a
def file and don't see it there.
How does one do this? Must I re-create the view form (and everything that
references it)?
Thanks for any clues,
Doug Anderson
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
