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.