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

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.

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:

expand_less 0 expand_more

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:

expand_less 0 expand_more

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:

expand_less 0 expand_more

Thanks!

#223367

May 26, 2020 11:09

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