Create, read, update or delete redirects.

Table-Specific Information

Select

The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:

SELECT * FROM Redirects

SELECT * FROM Redirects WHERE Id = '123'

SELECT * FROM Redirects WHERE Target = '/pqr.jsp'

SELECT * FROM Redirects WHERE Path = '/abc.php'

Insert

You must specify path and target to create a Redirect.

INSERT INTO Redirects (path, target) VALUES ('/abc.php', '/pqr.jsp')

Update

You must specify the id to update a Redirect. For example:

UPDATE Redirects SET Path = '/abc.php' WHERE Id = '77171130'

Delete

You must specify the Id of the Redirect to delete it.

DELETE FROM Redirects WHERE Id = '555695'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The ID for the redirect.
Path	String	False		The old path to be redirected.
Target	String	False		The target location where the user will be redirected.