sql query get document uniqueid by url - Using Umbraco and getting started - our.umbraco.com

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Nathan 67 posts 146 karma points

Mar 10, 2017 @ 08:06

0

SQL query: Get document uniqueId by URL

Hi,

I need a SQL query to get the uniqueId of a page within the BO content tree by its URL.

Have looked into the database and have not found where the page URLs are stored.

Something like:

select uniqueId, url from documentTable left join table2 on documentTable.url = table2.url

Thanks

Copy Link
Dennis Adolfi 1082 posts 6449 karma points MVP 6x c-trib

Mar 11, 2017 @ 08:43

0

Hi Dan.

Unfortunately I don't think this is possible. URLs are not stored in any database table, because they are set programmatically using UrlService's and ContentFinder's. https://our.umbraco.org/documentation/reference/routing/request-pipeline/icontentfinder

Instead of working with SQL queries, maybe you should have a look at the UmbracoHelper methods and programmatically generate some sort of report, if that's what you are looking on achieving? https://our.umbraco.org/documentation/reference/querying/umbracohelper/

Best of luck!

Copy Link
is working on a reply...

Please Sign in or register to post replies

Write your reply to:

Editor

Preview

Draft