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

Don't miss out Virtual Happy Hour today (April 26).

AI OnAI Off

Home / Forums / Developers (Main Products) Forum / Developer to developer /

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

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

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

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.