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?
This should work:
SELECT pkId FROM tblContent WHERE ContentAssetsID = (SELECT ContentGUID FROM tblContent WHERE pkId = 37808);
Thanks!
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?