World is now on Opti ID! Learn more

AI OnAI Off

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

Johan Lott
Johan Lott
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
Tomas Hensrud Gulla
Tomas Hensrud Gulla
Vote:
 

This should work:

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

Thanks!

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