If this comes across as me being lazy then it's probably not far from the truth. Some times I just don't have the patience or time to sieve through the forums.
I am trying to sort documents in a view based on the number of responses they have. Sounds easy enough, but having a hard time figuring it out. Whenever I work with views that show responses it's always a case of re-learning the ancient art of "special text" and response-only columns. Nothing could be less intuitive.
Imagine on the codestore homepage I want a section that shows most popular blog entries, based on the number of comments posted to them. Mike Golding used to have one on Notestips.com and I'd always assumed it was simply a view. Having tried to reproduce it I'm starting to think there must have been an agent involved. I'd take a look myself but I'm still waiting on Mike to send over the NSF so I can host the old site for him.
Is the only way of doing it to have some code (WQS of the child document) update a numeric "NumberOfResponses" field on the parent each time a response is added? Or can a view do it?
As much as I hate asking noddy questions like this I always do it in the hope other people will benefit from the answer.