Good to here that. Mark it as an answer so other people can discover it.
I don't think categories field exists, if you have some custom field sure you can use sql syntax:
You can look at xml/json returned - your field should be in there and if so then do where=fieldname=value
My assumption is that you want to get documents for given category. This probably can be done in 2 request:
- get all of the documents for given category
~/rest/cms.documentcategory?topn=10&format=json&where=categoryid=123
- then you can put these documentid in to SQL where : documentid in (123, 456) and encode
~/rest/content/currentsite/en-us/all/specialpages/?format=json&where=documentid+in+%28123%2C+456%29
OR you can do it vice versa: first get all of your documents of given type (like we did before), then check which of them under given category i.e you get back 2 documents with documentid in (123,456)
.
`~/rest/cms.documentcategory?topn=10&format=json&where=categoryid=123&where=documentid+in+%28123%2C+456%29`
P.S. There has been some discussion about that
P.P.S. On the other hand there are other ways of document classification for example document tags, i.e. you can tag your document with some ID:
So you encode DocumentTags = 'zzz' : DocumentTags+%3D+%27zzz%27%0D%0A
and add it to your query string and it will work!