View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
07655Bug reports[All Projects] Expression Managerpublic2013-03-11 20:442013-03-11 21:12
Assigned Toc_schmitz 
StatusclosedResolutionunable 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.
I will donate to the project if issue is resolvedNo
LimeSurvey build number OR git commit ID130311
Database & DB-VersionMysql 5
Operating System (Server)Ubuntu Linux
Webserver software & versionNginx
PHP Version5
Attached Files

- Relationships

-  Notes
c_schmitz (administrator)
2013-03-11 21:12

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

Copyright © 2000 - 2016 MantisBT Team
Powered by Mantis Bugtracker