Answered how to debug getResources

- 64 Posts
culd | steffan Reply #1, 14 years, 10 months ago

Hi all,

I'm having trouble debugging getResources since the sql query isn't added to the error log.

[[!get Resources? &parents=\`7\` &limit=\`5\` &tpl=\`Slideshow-SlideItem\` &depth=\`2\` &hideContainers=\`1\` &includeTVs=\`1\` &processTVs=\`1\` &showHidden=\`1\` &includeContent=\`1\` &sortbyTV=\`indekijker\` &sortdirTV=\`ASC\` &sortby=\`id\` &sortdir=\`ASC\` &where=\`{"indekijker:=":1}\` &debug=\`1\`

The 'indekijker' field is a checkbox-tv on which I'd like to restrict the query.

Does anyone know what I'm doing wrong?

Kind regards

steffan
This question has been answered by multiple community members. See the first response.
[ed. note: culd | steffan last edited this post 14 years, 10 months ago.]
- MODX Staff
- 10,725 Posts
opengeek Reply #2, 14 years, 10 months ago
Add
```
&debug=`1`
```
to the Snippet call and it will log the SQL being used.
Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek
discuss.next
discuss.answer
- 64 Posts
culd | steffan Reply #3, 14 years, 10 months ago

I did that and it has always worked while debugging but this time it doesn't do anything...
discuss.prev discuss.next
discuss.answer
- MODX Staff
- 10,725 Posts
opengeek Reply #4, 14 years, 10 months ago

First, wrap your snippet calls in code tags to preserve them when posting here.

Second, you can't use the where property to select Resource by TV values; you'll have to use the tvFilters property.
Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek
discuss.prev
discuss.answer
- 64 Posts
culd | steffan Reply #5, 14 years, 10 months ago

Thanks, it's working now. I still don't understand why my query isn't logged but that's an issue for next time