Sackgesicht VIP
Total posts: 1,636
25 Aug 2012 20:27

The date range filter is not returning the correct number of records.

Example :

if a start a date range from 25/08/2012 to 25/08/2014 i would expect to include dates starting from 25/08/2012 -- but they are not included. Maybe you have to check for correct inclusion of dates.

Another problem is, that it just returns only a part of the records.

A SQL test gave me a result of 663 records, while Cobalt reported only 64 pages a 5 records. (Another thing is, that we dont have a display of total records, so that we need to go to the last page to see haw many records are there to finally find out what our number is. -- Yes i know, it can be displayed with the total variable, as per documentation, but i consider it important to see the actually number even in the standard templates.)

Anyway, the fact is that the returned number of records is not correct.

Last Modified: 02 Mar 2014


Sergey
Total posts: 13,748
26 Aug 2012 06:30

Anyway, the fact is that the returned number of records is not correct.

DO you think I can reproduce it on last backup you gave me?

Anyway, the fact is that the returned number of records is not correct.

(Another thing is, that we dont have a display of total records, so that we need to go to the last page to see haw many records are there to finally find out what our number is. -- Yes i know, it can be displayed with the total variable, as per documentation, but i consider it important to see the actually number even in the standard templates.)

To show total, you may add anywhere in your template

total;?>

Sackgesicht VIP
Total posts: 1,636
26 Aug 2012 20:07

DO you think I can reproduce it on last backup you gave me?

I believe so

Hidden text

Powered by Cobalt