View Issue Details

IDProjectCategoryView StatusLast Update
07655Bug reports[All Projects] Expression Managerpublic2013-03-11 21:12
Reporterwiz561Assigned Toc_schmitz 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Target VersionFixed in Version 
Summary07655: Cannot use "OR" in expression manager
DescriptionI have an array of questions where the user can answer "Satisfied", "Dissatisfied", or "N/A". In the next array, I have a group of "If you're disatisfied, display array". When using the EM, it puts "ANDS" and not "OR"'s. If I edit the SQL table and replace the AND with OR's, it works correctly.
Steps To ReproduceCreate an array of questions... IE:

Were you happy with the paint brand?

Sherwin Williams
Dutch Boy
Some Brand
Some other Brand

Create a heading for the array as "Satisfied", "Dissatisfied", or "N/A".

Create another array:

Why were you dissatisfied:

Color was wrong
Paint smelled bad
Some other thing
Something else

For the rows, use the same..."Satisfied", "Dissatisfied", or "N/A".

Finally, in the second array, "Set Condition" where "Previous Group:Previous Array Question" equals "Dissatisfied". Do this for every question in the first array. The combination used is "AND" and I want it to be "OR".
Additional InformationAs mentioned above, I went into the SQL table and replaced the "AND" with "OR". Here's my "Relevance equation"...

((CRA1_CRASQ1.NAOK == "DIS") and (CRA1_CRASQ10.NAOK == "DIS") and (CRA1_CRASQ11.NAOK == "DIS") and (CRA1_CRASQ12.NAOK == "DIS") and (CRA1_CRASQ13.NAOK == "DIS") and (CRA1_CRASQ14.NAOK == "DIS") and (CRA1_CRASQ15.NAOK == "DIS") and (CRA1_CRASQ16.NAOK == "DIS") and (CRA1_CRASQ17.NAOK == "DIS") and (CRA1_CRASQ18.NAOK == "DIS") and (CRA1_CRASQ19.NAOK == "DIS") and (CRA1_CRASQ2.NAOK == "DIS") and (CRA1_CRASQ20.NAOK == "DIS") and (CRA1_CRASQ3.NAOK == "DIS") and (CRA1_CRASQ4.NAOK == "DIS") and (CRA1_CRASQ5.NAOK == "DIS") and (CRA1_CRASQ6.NAOK == "DIS") and (CRA1_CRASQ7.NAOK == "DIS") and (CRA1_CRASQ8.NAOK == "DIS") and (CRA1_CRASQ9.NAOK == "DIS"))

When I replace the AND with OR, it works fine, but for some reason, it gets reset to AND in mysql and breaks. I believe I should be able to use OR instead of AND, but can't.
TagsNo tags attached.
Complete LimeSurvey version number (& build)130311
I will donate to the project if issue is resolvedNo
Database & DB-VersionMysql 5
Operating System (Server)Ubuntu Linux
Webserver software & versionNginx
PHP Version5




2013-03-11 21:12

administrator   ~24642

This is a usage error on your part. Please consult the documentation on conditions thoroughly, especially

Issue History

Date Modified Username Field Change
2013-03-11 20:44 wiz561 New Issue
2013-03-11 21:12 c_schmitz Note Added: 24642
2013-03-11 21:12 c_schmitz Status new => closed
2013-03-11 21:12 c_schmitz Assigned To => c_schmitz
2013-03-11 21:12 c_schmitz Resolution open => unable to reproduce