Posted by sethcohn on August 23, 2007 at 9:39pm
(also posted at http://drupal.org/node/169955, but I realized this is a better place to ask)
Is there an easy way to generate a clean list of taxonomy terms used in the most recently created nodes?
Playing with views, I could create a list of terms used, but not a list with duplicates removed, multiple terms split apart (ie no commas), etc.
I'm thinking along the lines of 'Recent Topics Discussed', so I don't want the cruft of doubles/etc, just a way for someone to see XYZ was discussed, and a single link (via taxonomy) to items using that term.
Seems simple enough, but for some reason I don't see an 'out of the box' way to generate it...
Comments
An answer
christefano pointed to suggestedterms, which almost but not quite does the right thing. It's 'recent' is actually recently created tids, NOT recently used ones. The two are quite different. (Imagine a popular but low # tid)
But the pointer inspired me to dig into the SQL and figure it out.
http://drupal.org/node/169955#comment-264700
Bonus points for someone finding a better/faster SQL answer,
and extra bonus points for turning it into a generic view filter or 2