I don't have a where clause at the moment, i'm using classnames to fetch the articles. This repeater handles both the list of articles and the actual article pages themselves. It looks a bit like this:
<cms:CMSRepeater id="newsList" runat="server" ClassNames="cms.news" TransformationName="cms.news.newslist" selectedItemTransformationName="cms.news.default" DelayedLoading="true" >
<HeaderTemplate>
<div class="articles">
</HeaderTemplate>
<FooterTemplate>
</div>
</FooterTemplate>
</cms:CMSRepeater>
I have a unipager on the page linked to this repeater:
<cms:UniPager ID="UniPager1" runat="server" PageControl="newsList" HidePagerForSinglePage="true" PagerMode="Querystring" PageSize="1">
<PageNumbersTemplate><a href="<%# Eval("PageURL") %>" class="btn paging-number"><%# Eval("Page") %></a></PageNumbersTemplate>
<PreviousPageTemplate><a href="<%# Eval("PreviousUrl") %>" class="btn paging-previous"><i class="icon-left"></i></a></PreviousPageTemplate>
<NextPageTemplate><a href="<%# Eval("NextUrl") %>" class="btn paging-previous"><i class="icon-right"></i></a></NextPageTemplate>
<LayoutTemplate>
<div class="box-titleBar">
<div class="paging">
<asp:PlaceHolder runat="server" ID="plcPreviousPage"></asp:PlaceHolder>
<asp:PlaceHolder runat="server" ID="plcPageNumbers"></asp:PlaceHolder>
<asp:PlaceHolder runat="server" ID="plcNextPage"></asp:PlaceHolder>
</div>
<h3>News</h3>
</div>
</LayoutTemplate>
</cms:UniPager>
And I have a queryrepeater that generates links with the archive month that looks like this:
<cms:QueryRepeater ID="QueryRepeater1" runat="server" QueryName="cms.news.months" TransformationName="cms.news.months" ></cms:QueryRepeater>
Thanks
Chris