Answered Using Tagger to list resources with particular tags

I'm trying to work out how to use Tagger to list resources with certain tags.

From the documentation it appears that I need to use something like:

[[!getResources? &where=`[[!TaggerGetResourcesWhere? &tags=`Books,Vehicles` &where=`{"isfolder": 0}`]]`]]

But the TaggerGetResourcesWhere call returns

["EXISTS (SELECT 1 FROM `lxp7_tagger_tag_resources` r WHERE r.tag IN (0) AND r.resource = modResource.id)"]

When I try and run the SELECT statement on the database it comes back with: Unknown column 'modResource.id' in 'where clause'

Any clues?

Thanks
Mike

Do you have tags: Books & Vehicles in Tagger?

If not, the query is correct

Thanks for responding,

No I've changed the tags to match the tags on a couple of my resources.

My getResources call is returning all the resources though instead of just 2.

Any ideas?

Quote from: thingstodo at Feb 04, 2015, 01:43 PM

Solved. Typo!

Please post your final implementation so users with the same issue can see what the "type" actually was.