Thanks -- another question.
I want to use the Results page to provide a listing of posts for a given month. I've altered the SQL to this:
SELECT C2.ContentGroup, C2.ContentPageSetOrder
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2 ON C2.ContentPagesetParentID = C1.ContentID
WHERE C1.ContentGroup = 'BlogPost' AND C1.ContentDate > d1 AND C1.ContentDate < d2
GROUP BY C2.ContentPageSetOrder
ORDER BY C2.ContentPageSetOrder DESC
adding the ContentDate parameters to the query. d1 and d2 are configured properly and available (returning 2013-04-01 00:00:00 and 2013-06-01 00:00:00 respectively to the results page), but the query doesn't filter the results.
Thoughts??
