This is the general format for inserting redirect records (through the host->SQL page)

INSERT INTO {databaseOwner}[{objectQualifier}urp_Redirect]
([PortalId]
,[RedirectOrder]
,[HttpAlias]
,[RedirectUrl]
,[MatchType]
,[KeepQueryString]
,[DestTabPath]
,[DestTabId]
,[DestUrl]
,[DestType]
,[IsRegex])
VALUES
(0
,1
,null
,'/test-url-1'
,'relative'
,1
,null
,null
,'http://example.com/tested/redirected'
,'url'
,0)

INSERT INTO {databaseOwner}[{objectQualifier}urp_Redirect]
([PortalId]
,[RedirectOrder]
,[HttpAlias]
,[RedirectUrl]
,[MatchType]
,[KeepQueryString]
,[DestTabPath]
,[DestTabId]
,[DestUrl]
,[DestType]
,[IsRegex])
VALUES
(0
,2
,null
,'/test-url-2'
,'relative'
,1
,null
,55
,'/tested/redirected'
,'tab'
,0)

Syntax Example 1
Will redirect from your-site/test-url-1 to example.com/tested/redirected

Syntax Example 2
Will redirect from your-site/test-url-2 to your-site/home/tested/redirected (assuming tabid 55 = the home page on your dnn install).

In both cases, it is assumed the 'your-site' is a portal alias for portal Id 0 in your DNN install.

Note: you must clear the cache or restart the application after inserting the records.

Last edited May 16, 2014 at 4:59 AM by brucerchapman, version 1

Comments

No comments yet.