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

Vote:
 

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?

#223315
May 25, 2020 9:12
Vote:
 

This should work:

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

Thanks!

#223367
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.