Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

Get page name from Content ID (direct from database)

Sam West
Sam West
Vote:
0

Hi All,

I know this is easily done from code, but i'm looking directly at the database with SQL.

I have the content ID and I want to find the page name from this, and if possible the page type name too.

Does anyone have a query that would get me this? Or even which tables I should be looking in?

Thanks,

Sam

#189277
Mar 14, 2018 12:58
Scott Reed
Scott Reed
Vote:
0

You can query the tblWorkContent table, this gives all versions for a content item

SELECT Name
  FROM [SJA_Development_Episerver].[dbo].[tblWorkContent]
  where fkContentID = 23 AND Status = 4

Will get the current published version for the content id 23, however if you're looking for non published items you main need to get the latest saved version instead. I suggest you look at this table and understand it based on your needs

#189278
Mar 14, 2018 13:21
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.