View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
07655 | Bug reports | Expression Manager | public | 2013-03-11 20:44 | 2013-03-11 21:12 |
Reporter | wiz561 | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 2.00+ | ||||
Summary | 07655: 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 Create a heading for the array as "Satisfied", "Dissatisfied", or "N/A". Create another array: Why were you dissatisfied: Color was wrong 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. | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 130311 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | Mysql 5 | ||||
Server OS (if known) | Ubuntu Linux | ||||
Webserver software & version (if known) | Nginx | ||||
PHP Version | 5 | ||||
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 |
|