Copied to clipboard

Flag this post as spam?

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


  • Fengelz 106 posts 221 karma points
    Feb 04, 2010 @ 15:14
    Fengelz
    0

    Template tracking

    Hi 

    I was wondering if it's possible in Umbraco, to track on a specific template, which documents it is being used on?

    If not, has anyone perhaps created a package with this functionality?

     

    best regards Sune Fengel

  • Sebastiaan Janssen 4899 posts 14655 karma points MVP admin hq
    Feb 04, 2010 @ 15:41
    Sebastiaan Janssen
    1

    Not that I know of, to find out which of your templates are in use, do an SQL query like this:

     

    SELECT * FROM cmsTemplate WHERE nodeId IN (SELECT templateId FROM cmsDocument)

    Or, if you want to know which documents one template is being used on:

    SELECT * 
    FROM cmsTemplate 
     LEFT JOIN cmsDocument 
     ON cmsTemplate.nodeId = cmsDocument.templateId 
    WHERE nodeId = YOURNODEID

     

  • Fengelz 106 posts 221 karma points
    Feb 04, 2010 @ 15:46
    Fengelz
    0

    Thanks.

    Maybe I'll make a package that could provide this overview.

    Could be useful for cleaning up a site.

    - Sune

  • Lee Kelleher 3945 posts 15163 karma points MVP 10x admin c-trib
    Feb 04, 2010 @ 15:54
    Lee Kelleher
    0

    Maybe drop Richard Soeteman an email? ... I think this would be well-suited in the Content Maintenance Dashboard Package.

    Cheers, Lee.

     

  • Richard Soeteman 3875 posts 12037 karma points MVP
    Feb 04, 2010 @ 19:32
    Richard Soeteman
    1

    Hi Lee and others,

    Yes would be a nice feature, on the list for the next release now ;-). For now you can use the suggestion @sebastiaan gave or use xpath to retrieve nodes that contains the template.

    Cheers,

    Richard

  • Fengelz 106 posts 221 karma points
    Feb 05, 2010 @ 13:27
    Fengelz
    0

    Sounds great. Good Idea to usexpath also.

    - Sune

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies