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)

Vote:
 

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
Vote:
 

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.