If, through the front-end, I filter a user list using a date field and the returned filtered list requires multiple pages, there's no way to view the second and subsequent pages of results. What happens is clicking the "next" or other page number on the filtered output causes the date filter to be removed.

Note that this problem seems to be specific to date fields. Filters on dropdown lists for example seem to be retained for second and subsequent pages of output.

Am I missing something, or is this a bug?

Post edited by: krileon, at: 2010/11/25 17:07

It's not been convenient to take the site offline recently, so I don't have the SQL that you requested. However, I think the answer lies in the address bar of the browser.

My site has 101 users. I ran a user search looking for only those who joined in the past year. The URL was reported as:

http://<mysite>/index.php?option=com_comprofiler&task=usersList&Itemid=3&limitstart=0&search=&listid=2&lastvisitDate__minval=&lastvisitDate__maxval=&lastupdatedate__minval=&lastupdatedate__maxval=&name=&firstname=&lastname=&email=&username=&cb_mobile=&cb_expcomp=&cb_expyears__minval=&cb_expyears__maxval=&cb_exppp=&cb_expinst=&cb_expfaid=&cb_expvhf=&cb_expchild=&cb_expother=&cb_memclass=&cb_memjoined__minval=25%2F11%2F2009&cb_memjoined__maxval=&cb_memsubs__minval=&cb_memsubs__maxval=&cb_memexp__minval=&cb_memexp__maxval=

A list of 56 users split over 2 pages was correctly returned.

I then clicked the next (page) button. The following address was reported by the browser:

http://<mysite>/index.php?option=com_comprofiler&task=usersList&listid=2&Itemid=3&cb_memjoined__minval=2009-11-25&limit=30&limitstart=30

A list of 101 users split over 4 pages was incorrectly returned, ie. the filter was, for practical purposes, removed.

I note however that between the initial filtered search and the "next page", the date representation in the query string changed from

&cb_memjoined__minval=25%2F11%2F2009

to

&cb_memjoined__minval=2009-11-25

When I edited the date format for this parameter in the second case to match the first, I correctly got the second page of the 56 user filtered-list that I expected.

So, it looks like the date parameters are being mangled in the query for second and subsequent pages. Can you shed any light on why this would be happening please?

Post edited by: jhaines, at: 2010/11/25 16:48

Thanks and sorry for the initial confusion.

Julian