What database table contains the list of "multiple URL&

Posted by Community Admin on 04-Aug-2018 14:57

What database table contains the list of "multiple URL"s allowed for a single page?

All Replies

Posted by Community Admin on 09-Oct-2013 00:00

Basically I have 5000+ pages in Sitefinity.  When I try to create a multiple URL for a new landing page, for example ~/WelcomeHome, I'm getting a warning that some other page already has it.

I need to know what table to look in to see what page is already associated with the ~/WelcomeHome URL so I can delete the multiple url value from that page and assign it to my new page.

Posted by Community Admin on 09-Oct-2013 00:00

This should help:

SELECT * FROM [dbo].[sf_url_data]
    WHERE  url = '~/WelcomeHome'

The [dbo].[sf_url_data].[id2] column will relate to the [dbo].[sf_page_node].[id]

SELECT * FROM [BostonReedDev].[dbo].[sf_page_node]
  WHERE ID = 'GUID from id2 col'


Posted by Community Admin on 09-Oct-2013 00:00

Excellent.  That is exactly what I needed.  I found it!  Thank you.

This thread is closed