View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06769Bug reportsSurvey participants (Tokens)public2012-10-24 17:302012-10-30 14:52
Reporterbradummer Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06769: In tokens list, searching by more than one criteria does not work
Description

In the tokens list, if you try and search for more than one criteria using AND between the criteria, it always returns 0 results. For example, I'd like to search for all tokens that aren't bounced and haven't completed the survey. I've tried a number of different combinations and none of them work. I have about 5,500 tokens in the table most of which are Email Status = OK and Completed? = N. If I search for:

[Email status] [Equals] OK

then I get about 5,000 results. If I search for:

[Completed?] [Equals] N

then I get about 5,100 results. If I search for both of them:

[Email status] [Equals] OK
[AND]
[Completed?] [Equals] N

I get 0 results. I've tried crafting the searches different ways (e.g. [Email Status] [Not equal] bounced, etc.) and nothing else works, so I believe the problem is with the way that the criteria are ANDed together. Let me know if you need more details.

Steps To Reproduce

Follow steps outlined in description above

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)121024
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionMySQL 5.0
Server OS (if known)CentOS
Webserver software & version (if known)Apache 2.2.3
PHP Version5.2.17

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-10-25 00:58

administrator   ~21637

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10016
c_schmitz

c_schmitz

2012-10-25 15:36

administrator   ~21675

LimeSurvey 2.00+ Build 121025 released - please update.
Make sure that you clean your browser cache after update. If the issue should still persist please re-open this issues and add details how to reproduce.
Thank you.
bradummer

bradummer

2012-10-25 16:19

reporter   ~21685

So it's better, but I think there is still a problem. Using the same token list I described earlier, if I set these two criteria:

[Uses left] [Equals] 1
[AND]
[Email status] [Equals] OK

then I get the correct result. So now that's working correctly. However if I reverse the criteria like this:

[Email status] [Equals] OK
[AND]
[Uses left] [Equals] 1

then I get 0 results. I haven't tested any other combos- please let me know if you'd like me to do any other testing.
c_schmitz

c_schmitz

2012-10-25 21:55

administrator   ~21691

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10027
c_schmitz

c_schmitz

2012-10-25 21:55

administrator   ~21692

OK, fixed now.
c_schmitz

c_schmitz

2012-10-30 14:52

administrator   ~21778

New 2.00+ version released - please update.

Related Changesets

LimeSurvey: master 432dda2b

2012-10-24 15:58:30

c_schmitz

Details Diff 		Fixed issue 06769: In tokens list, searching by more than one criteria does not work Affected Issues
06769
mod - application/controllers/admin/tokens.php Diff File
mod - application/helpers/common_helper.php Diff File
mod - application/models/Tokens_dynamic.php Diff File

LimeSurvey: master 524e498d

2012-10-25 12:55:10

c_schmitz

Details Diff 		Fixed issue 06769: In tokens list, searching by more than one criteria does not work Affected Issues
06769
mod - scripts/admin/tokens.js Diff File

Issue History

Date Modified Username Field Change
2012-10-24 17:30 bradummer New Issue
2012-10-25 00:57 c_schmitz Assigned To => c_schmitz
2012-10-25 00:57 c_schmitz Status new => assigned
2012-10-25 00:58 c_schmitz Status assigned => resolved
2012-10-25 00:58 c_schmitz Fixed in Version => 2.00+
2012-10-25 00:58 c_schmitz Resolution open => fixed
2012-10-25 00:58 c_schmitz Changeset attached => LimeSurvey master 432dda2b
2012-10-25 00:58 c_schmitz Note Added: 21637
2012-10-25 15:36 c_schmitz Note Added: 21675
2012-10-25 15:36 c_schmitz Status resolved => closed
2012-10-25 16:19 bradummer Note Added: 21685
2012-10-25 16:19 bradummer Status closed => feedback
2012-10-25 16:19 bradummer Resolution fixed => reopened
2012-10-25 21:55 c_schmitz Changeset attached => LimeSurvey master 524e498d
2012-10-25 21:55 c_schmitz Note Added: 21691
2012-10-25 21:55 c_schmitz Note Added: 21692
2012-10-25 21:55 c_schmitz Status feedback => resolved
2012-10-25 21:55 c_schmitz Resolution reopened => fixed
2012-10-30 14:52 c_schmitz Note Added: 21778
2012-10-30 14:52 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)