View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04041Bug reportsStatisticspublic2010-01-27 22:46
Reporterjstraw Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.87+ 
Summary04041: I am unable to filter statistics by date range.
Description

If I enter anything other than nothing or "0" for Submission Date "Later Than," the query returns nothing.

Additional Information

This problem us preventing deployment of the Limesurvey tool.

TagsNo tags attached.
Attached Files
screenA.jpg (173,247 bytes)
screenB.jpg (91,935 bytes)   
screenB.jpg (91,935 bytes)   
screenC.jpg (191,032 bytes)
html.jpg (23,947 bytes)   
html.jpg (23,947 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
BrowserFirefox 3.5 or IE 8
Database type & versionMySQL client version: 5.0.51a
Server OS (if known)Linux (Debian)
Webserver software & version (if known)Apache
PHP VersionPHP Version 5.2.6-1+lenny4

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-01-12 17:00

  ~10751

I can reproduce the issue with the attached simple sample survey.
I copied the submit date from the responses to use the correct date format.

jstraw

jstraw

2010-01-13 16:38

reporter   ~10768

I don't understand what you're saying in your second sentence.

Is it possible that the date format that is set on "page 2 of 2" in "Edit Survey Settings" can affect this?

jstraw

jstraw

2010-01-13 17:13

reporter   ~10769

I seem to be able to filter results by date if I format the search with a mm.dd.yyyy format but not with any other format, even if I've changed the date format on the survey settings. I'm not sure what the date format on survey settings effects.

c_schmitz

c_schmitz

2010-01-13 17:43

administrator   ~10770

Last edited: 2010-01-13 17:43

The right format should be yyyy-mm-dd - but with next version it will have a datepicker and use your preferred format set in your user settings.
Also it seem that logically the 'later than' and 'earlier than' labels are exchanged.

Both issues will be fixed for the next 1.87plus version.

jstraw

jstraw

2010-01-13 17:52

reporter   ~10771

"Also it seem that logically the 'later than' and 'earlier than' labels are exchanged."

This seems to be the core issue.

Where do I find the latest build? How do I track version history for fixes in the latest builds? Where do I find information about how do do an upgrade in place?

jstraw

jstraw

2010-01-13 19:14

reporter   ~10772

This is excellent, thank you.

I've updated the four files and I've noticed something...though I know the actual implementation in the next revision may already address this.

The html presentation is now a little broken and I'm attaching a screen shot.

Thanks again.

c_schmitz

c_schmitz

2010-01-14 01:06

administrator   ~10773

Last edited: 2010-01-14 01:07

Thank you. I updated the template to resolve this problem.
Usually we release Updates every week (mostly Tuesdays)
Use the ComfortUpdate feature in Global Settings to quickly update.

jstraw

jstraw

2010-01-14 01:50

reporter   ~10774

Thanks again.

Issue History

Date Modified Username Field Change
2010-01-11 17:50 jstraw New Issue
2010-01-11 17:50 jstraw Status new => assigned
2010-01-11 17:50 jstraw Assigned To => user372
2010-01-11 17:50 jstraw File Added: limesurvey_survey_19681.csv
2010-01-11 17:50 jstraw Browser => Firefox 3.5 or IE 8
2010-01-11 17:50 jstraw Database & DB-Version => MySQL client version: 5.0.51a
2010-01-11 17:50 jstraw Operating System (Server) => Linux (Debian)
2010-01-11 17:50 jstraw Webserver => Apache
2010-01-11 17:50 jstraw PHP Version => PHP Version 5.2.6-1+lenny4
2010-01-11 18:05 jstraw File Added: screenA.jpg
2010-01-11 18:05 jstraw File Added: screenB.jpg
2010-01-12 16:01 jstraw File Added: screenC.jpg
2010-01-12 17:00 user372 Note Added: 10751
2010-01-12 17:00 user372 Assigned To user372 => c_schmitz
2010-01-13 16:38 jstraw Note Added: 10768
2010-01-13 17:13 jstraw Note Added: 10769
2010-01-13 17:43 c_schmitz Note Added: 10770
2010-01-13 17:43 c_schmitz Note Edited: 10770
2010-01-13 17:46 c_schmitz Status assigned => resolved
2010-01-13 17:46 c_schmitz Fixed in Version => 1.87+
2010-01-13 17:46 c_schmitz Resolution open => fixed
2010-01-13 17:52 jstraw Note Added: 10771
2010-01-13 19:14 jstraw Note Added: 10772
2010-01-13 19:15 jstraw File Added: html.jpg
2010-01-14 01:06 c_schmitz Note Added: 10773
2010-01-14 01:07 c_schmitz Note Edited: 10773
2010-01-14 01:50 jstraw Note Added: 10774
2010-01-27 22:46 c_schmitz Status resolved => closed