Our monthly Virtual Happy Hour is happening this week, Fri Feb 23!

Try our conversational search powered by Generative AI!

Get page name from Content ID (direct from database)


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?



Mar 14, 2018 12:58

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

  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

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.