Sign in Register
Go to solution
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

    Copy Link
  • Sebastiaan Janssen 5060 posts 15522 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

     

    Copy Link
  • 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

    Copy Link
  • Lee Kelleher 4026 posts 15836 karma points MVP 13x 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.

     

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    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

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

    Sounds great. Good Idea to usexpath also.

    - Sune

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft