Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Ismail Mayat 4511 posts 10091 karma points MVP 2x admin c-trib
    Oct 06, 2014 @ 12:29
    Ismail Mayat

    All content with multi tree node picker


    We are using Umbraco 6.1.6. We have quite a few doctypes and these have data types based on multi tree node picker and we have content based on these doc types.  What I want to do is get all content that uses my derived multi tree node picker data type.  What is the quickest way of doing this im thinking some kind of sql query?  Basically I just need the content node ids.  Has anyone ever done something similar?



  • Jamie Howarth 306 posts 773 karma points c-trib
    Oct 06, 2014 @ 12:37
    Jamie Howarth
    SELECT ct.nodeId FROM cmsContent ct
    INNER JOIN cmsContentType ctt on ct.contentType = ctt.nodeId
    INNER JOIN cmsPropertyType ptt on ptt.contentTypeId = ctt.nodeId
    INNER JOIN cmsDataType dtt on dtt.nodeId = ptt.dataTypeId
    WHERE dtt.nodeId = -90

    Replace -90 with the datatypeId that you want for your MNTP and that will give you a list of all the content page IDs that use the given datatype.

Please Sign in or register to post replies

Write your reply to: