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
* 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.