View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07655Bug reportsExpression Managerpublic2013-03-11 21:12
Reporterwiz561 Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary07655: Cannot use "OR" in expression manager
Description

I 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 Reproduce

Create 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 Information

As 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.
Bug heat2
Complete LimeSurvey version number (& build)130311
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionMysql 5
Server OS (if known)Ubuntu Linux
Webserver software & version (if known)Nginx
PHP Version5

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-03-11 21:12

administrator   ~24642

This is a usage error on your part. Please consult the documentation on conditions thoroughly, especially http://docs.limesurvey.org/Setting+conditions&structure=English+Instructions+for+LimeSurvey#The_multiple_options_questions

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