Try our conversational search powered by Generative AI!

Find out what page or block a content assets folder belongs to with sql


In erlier versions of Episerver we used this sql to find out what page a pagefile-id belonged to:

SELECT pkID FROM tblPage WHERE ExternalFolderID = 37808

What is the equivalent sql in Episerver 11 to find out what content ID (page or block) a content assets folder belongs to?

May 25, 2020 9:12

This should work:

SELECT pkId FROM tblContent WHERE ContentAssetsID = (SELECT ContentGUID FROM tblContent WHERE pkId = 37808);
May 25, 2020 11:14


May 26, 2020 11:09
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.