View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17996Bug reportsExpression Managerpublic2023-10-07 19:46
Reportermarcgold Assigned To 
PrioritynoneSeveritypartial_block 
Status acknowledgedResolutionopen 
Product Version3.25.20 
Summary17996: Relevance Equation giving incorrect functions
Description

Using an Array by Column and setting relevance on a previous multiple choice does not work as expected.

The LS Group file is attached.

Q6 - is a Multiple Choice Question
Q7 - Array By Column
We have 2 SubQuestions (columns) The Relevance Equation is Q6_SQ004 == "Y" and Q6_SQ005 == "Y" so that if ticked the column shows / doesnt show (there is a skip if neither ticked).

The problem is the Options disappear not the Subquestions.

Steps To Reproduce

Steps to reproduce

Use the attached file

Expected result

Either of the Subquestions (Columns) should show /not show
Actual result

The Options Showed / No Showed

TagsNo tags attached.
Attached Files
limesurvey_group_5180.lsg (14,707 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Group</LimeSurveyDocType>
 <DBVersion>366</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[5180]]></gid>
    <sid><![CDATA[4030]]></sid>
    <group_name><![CDATA[Questionairre]]></group_name>
    <group_order><![CDATA[3]]></group_order>
    <description/>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[84354]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[Q6]]></title>
    <question><![CDATA[Which of the following symptoms have you suffered from in the last 6 months, which were not as a result of taking a medicine that you can buy off the shelf in a pharmacist or supermarket?]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[H]]></type>
    <title><![CDATA[Q7b]]></title>
    <question><![CDATA[How often do you personally suffer from ... ?]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84367]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[Q8]]></title>
    <question><![CDATA[Compared to 6-12 months ago, how has the frequency which you suffer from diarrhoea/constipation (ask as relevant)  changed?]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </questions>
 <subquestions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[84356]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ001]]></title>
    <question><![CDATA[Trapped wind/Gassiness/Bloating]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84383]]></qid>
    <parent_qid><![CDATA[84382]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ001]]></title>
    <question><![CDATA[Diarrheoa]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[Q6_SQ004 =="Y"]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84357]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ002]]></title>
    <question><![CDATA[Stomach ache/Cramps (not related to period pains)]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84384]]></qid>
    <parent_qid><![CDATA[84382]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ002]]></title>
    <question><![CDATA[Constipation]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[Q6_SQ005 =="Y"]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84358]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ003]]></title>
    <question><![CDATA[Stomach heaviness, fullness or pressure]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84359]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ004]]></title>
    <question><![CDATA[Diarrhoea (urgent, frequent, loose or watery stools)]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84360]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ005]]></title>
    <question><![CDATA[Constipation (irregular, infrequent or difficult bowel movements)]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[5]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84361]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ006]]></title>
    <question><![CDATA[Indigestion/ heartburn]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[6]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84362]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ007]]></title>
    <question><![CDATA[Acid rebound, acid reflux, acid regurgitation, silent reflux, GORD/GERD]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[7]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84363]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ008]]></title>
    <question><![CDATA[Hemorrhoids]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[8]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[84364]]></qid>
    <parent_qid><![CDATA[84354]]></parent_qid>
    <sid><![CDATA[4030]]></sid>
    <gid><![CDATA[5180]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ009]]></title>
    <question><![CDATA[None of the above]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[9]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </subquestions>
 <answers>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A1]]></code>
    <answer><![CDATA[Less often than once a year]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A10]]></code>
    <answer><![CDATA[Daily]]></answer>
    <sortorder><![CDATA[10]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A11]]></code>
    <answer><![CDATA[Prefer not to say]]></answer>
    <sortorder><![CDATA[11]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A2]]></code>
    <answer><![CDATA[Once every 7-12 months]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A3]]></code>
    <answer><![CDATA[Once every 6 months]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A4]]></code>
    <answer><![CDATA[Once every 4-5 months]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A5]]></code>
    <answer><![CDATA[Once every 2-3 months]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A6]]></code>
    <answer><![CDATA[Once a month]]></answer>
    <sortorder><![CDATA[6]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A7]]></code>
    <answer><![CDATA[2-3 times a month]]></answer>
    <sortorder><![CDATA[7]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A8]]></code>
    <answer><![CDATA[Once a week]]></answer>
    <sortorder><![CDATA[8]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84382]]></qid>
    <code><![CDATA[A9]]></code>
    <answer><![CDATA[Every 3-4 days]]></answer>
    <sortorder><![CDATA[9]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[84367]]></qid>
    <code><![CDATA[A1]]></code>
    <answer/>
    <sortorder><![CDATA[0]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[84354]]></qid>
    <attribute><![CDATA[exclude_all_others]]></attribute>
    <value><![CDATA[SQ009]]></value>
   </row>
  </rows>
 </question_attributes>
</document>
limesurvey_group_5180.lsg (14,707 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)Version 3.28.4+220329
I will donate to the project if issue is resolvedNo
BrowserEdge MAC
Database type & versionPostgres
Server OS (if known)Ubuntu
Webserver software & version (if known)Nginx
PHP Version8.1

Relationships

related to 12277 confirmed Relevance equation on column of array-number question doesn't work 

Users monitoring this issue

duvemyster

Activities

ollehar

ollehar

2022-03-30 12:06

administrator   ~68832

For whomever does the fix, please add a test too.

gabrieljenik

gabrieljenik

2022-04-22 19:26

manager   ~69202

This should be tackled with 12277.
Not exact the same problem, but there is a lot in common in their solution

Issue History

Date Modified Username Field Change
2022-03-29 18:21 marcgold New Issue
2022-03-29 18:21 marcgold File Added: limesurvey_group_5180.lsg
2022-03-30 12:06 ollehar Note Added: 68832
2022-03-30 12:06 ollehar Bug heat 0 => 2
2022-04-22 18:23 gabrieljenik Relationship added duplicate of 12277
2022-04-22 18:24 gabrieljenik Relationship deleted 12277
2022-04-22 18:28 gabrieljenik Assigned To => gabrieljenik
2022-04-22 18:28 gabrieljenik Status new => assigned
2022-04-22 19:25 gabrieljenik Relationship added related to 12277
2022-04-22 19:26 gabrieljenik Note Added: 69202
2022-04-22 19:26 gabrieljenik Bug heat 2 => 4
2022-05-23 14:33 gabrieljenik Status assigned => acknowledged
2023-10-04 15:08 gabrieljenik Assigned To gabrieljenik =>
2023-10-07 19:46 duvemyster Issue Monitored: duvemyster
2023-10-07 19:46 duvemyster Bug heat 4 => 6