[CLOSED] ListIt2, filtering and pagination

[frankmanl]

I can't figure out how to filter results from ListIt2 in combination with pagination.
example (list of concerts, ordered by performance date): http://tijdelijkewebsite.beaufort-extra ... t2-showall
The tag I use in this page is

Code: Select all

{ListIt2agenda orderby="custom_speeldatum" pagelimit="8" showall="0"}

I only want to display items where custom_speeldatum is bigger than today (speeldatum = date of performance).
When I use pagination (as set up in the default templates) I get empty page after empty page until somewhere at page 164 or 165 the first concert is mentioned. It seems pagination is done before my filter is executed.
When I remove the pagelimit (pagination) I get one page with all concerts I want, but on one very long list.
So, how can I display only the concerts I want, and still have pagination without empty pages??

Frank

BTW - this filter is on performance date, but I look for a solution that also works for e.g. displaying all concerts in April, or with entrance price between 10 and 20 ...

[Stikki]

By altering SQL via UDT, but thats not something im giving help with.

[frankmanl]

ListIt2 seems not to be the module I need, I solved it with News module in stead.
Topic closed.