We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 24482
    • 9 Posts
    Apologies if this is in the wrong thread, but I really can’t find out how to do this!

    Ok, so basically, I have got a container called genres which has lots of documents (genres) in it. Each genre is using the genre template.

    On the genre template, I am trying to add a SQL statement to my ditto snippet:
    [!Ditto? &parents=`2` &orderBy=`menutitle ASC` &tpl=`playlistItem` !]

    At the moment, it’s only showing documents that are in the genre container. I also need it to look through the modx_site_tmplvar_contentvalues table and make sure that the value is ’hiphop’ or [*alias*].

    Hope I’m making sense, if I’m not - please ask me to can clarify certain points.

    Many thanks in advance.