I’m struggling with what I thought would be an easy one
How can I select ALL resources on site that have at least ONE tag from the groups provided?
The above returns ALL resources - tagged or not.
It seems that you need to write your own sql-subquery to get the desired result. Something like:
&where=`["EXISTS (SELECT 1 FROM `modx_tagger_tag_resources` r INNER JOIN `modx_tagger_tags` t INNER JOIN `modx_tagger_groups` tg WHERE r.tag = t.id AND t.group = tg.id AND tg.id IN (1,2,3) AND r.resource = modResource.id)"]`
Thanks @halftrainedharry - I would have NEVER sorted that one out like that. Much appreciated!