Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17129Bug reportsQuestion editorpublic2021-03-24 17:41
Reporterong Assigned Toollehar  
PriorityhighSeveritypartial_block 
Status closedResolutionduplicate 
Product Version4.4.7 
Summary17129: relevance equation changes automatically from OR to AND
Description

I have a relevevance equation that checks for a ranking of an item: If the item is being ranked, the question should show. I used the condition designer to create a relevance question and then changed it afterwards from AND to OR connections. When I changed ... something (can not say exactly when this happens) the relevance question is set to AND again!

Steps To Reproduce

don't really know.
I did change the presentation to anonymouse to create another screenshot or a bug.

Additional Information

relevance question after creating with condition designer
(((!is_empty(G01Q01_1.NAOK) && (G01Q01_1.NAOK == 12))) and ((!is_empty(G01Q01_10.NAOK) && (G01Q01_10.NAOK == 12))) and ((!is_empty(G01Q01_11.NAOK) && (G01Q01_11.NAOK == 12))) and ((!is_empty(G01Q01_12.NAOK) && (G01Q01_12.NAOK == 12))) and ((!is_empty(G01Q01_2.NAOK) && (G01Q01_2.NAOK == 12))) and ((!is_empty(G01Q01_3.NAOK) && (G01Q01_3.NAOK == 12))) and ((!is_empty(G01Q01_4.NAOK) && (G01Q01_4.NAOK == 12))) and ((!is_empty(G01Q01_5.NAOK) && (G01Q01_5.NAOK == 12))) and ((!is_empty(G01Q01_6.NAOK) && (G01Q01_6.NAOK == 12))) and ((!is_empty(G01Q01_7.NAOK) && (G01Q01_7.NAOK == 12))) and ((!is_empty(G01Q01_8.NAOK) && (G01Q01_8.NAOK == 12))) and ((!is_empty(G01Q01_9.NAOK) && (G01Q01_9.NAOK == 12))))

relevance question after I did my changes from AND to OR:
(((!is_empty(G01Q01_1.NAOK) && (G01Q01_1.NAOK == 12))) or ((!is_empty(G01Q01_10.NAOK) && (G01Q01_10.NAOK == 12))) or ((!is_empty(G01Q01_11.NAOK) && (G01Q01_11.NAOK == 12))) or ((!is_empty(G01Q01_12.NAOK) && (G01Q01_12.NAOK == 12))) or ((!is_empty(G01Q01_2.NAOK) && (G01Q01_2.NAOK == 12))) or ((!is_empty(G01Q01_3.NAOK) && (G01Q01_3.NAOK == 12))) or ((!is_empty(G01Q01_4.NAOK) && (G01Q01_4.NAOK == 12))) or ((!is_empty(G01Q01_5.NAOK) && (G01Q01_5.NAOK == 12))) or ((!is_empty(G01Q01_6.NAOK) && (G01Q01_6.NAOK == 12))) or ((!is_empty(G01Q01_7.NAOK) && (G01Q01_7.NAOK == 12))) or ((!is_empty(G01Q01_8.NAOK) && (G01Q01_8.NAOK == 12))) or ((!is_empty(G01Q01_9.NAOK) && (G01Q01_9.NAOK == 12))))

TagsNo tags attached.
Attached Files
relevance_eqchanges.png (190,951 bytes)
Bug heat6
Complete LimeSurvey version number (& build)4.4.7+210215
I will donate to the project if issue is resolvedNo
Browservivaldi (latest)
Database type & versionmysql 8.x
Server OS (if known)debian
Webserver software & version (if known)apache2
PHP Version7.3

Relationships

related to 16462 closedgabrieljenik Relavance Equation not in Sync with Condition Designed 

Activities

ollehar

ollehar

2021-03-10 17:59

administrator   ~63122

Can you reproduce this?

ong

ong

2021-03-10 18:04

reporter   ~63124

Last edited: 2021-03-22 20:47

This happened more than once (same question in the same questionaire). I would say it's reproduceable.

ollehar

ollehar

2021-03-11 13:17

administrator   ~63305

Last edited: 2021-03-22 20:47

Can you give us any hints on how you did it?

ollehar

ollehar

2021-03-11 13:18

administrator   ~63306

Last edited: 2021-03-22 20:47

You're not having multiple editors working on the same survey simultaneously, right?

ong

ong

2021-03-11 15:11

reporter   ~63311

Last edited: 2021-03-22 20:47

Hi,
no, not using multiple editors. Just one browser window (latest Vivaldi).
I was thinking that caching could be the part of the problem? I am developing databases and it's so strange to me, that a value, once saved to the database is changed when I edit something completely different.

c_schmitz

c_schmitz

2021-03-22 20:45

administrator   ~63564

Last edited: 2021-03-22 20:47

The problem here is the bad distinction between customized ExpressionScript and using the conditions designer.
In LS3 you could either use condition designer OR edit the relevance field manually.

Now you can use the condition designer AND edit the field afterwards - the condition however is not removed and at some point the conditions get translated to ExpressionScript again, overwriting the customization.

c_schmitz

c_schmitz

2021-03-22 21:00

administrator   ~63566

How it should work:

If a conditions exists and the user starts editing the condition directly (not using the condition editor), a warning message will be shown:
"Note: If you customize & save this condition you will not be able to use the condition editor for this, anymore."

If the conditions is customized and the question is saved, the condition data needs to be automatically removed.

A similar note should be shown if you use the condition editor and a customized condition already exists.

"Note: This question uses a customized condition. If you create a condition using this editor the current customized condition will be overwritten. "

c_schmitz

c_schmitz

2021-03-22 21:03

administrator   ~63567

Last edited: 2021-03-22 22:11

@ong: To prevent that the field get overwritten again, backup your custom condition (copy/paste to somewhere) remove the conditions from the editor first, then save your custom condition, again.

ong

ong

2021-03-23 08:04

reporter   ~63572

@c_schmitz
Yes, that sounds good, but my original problem why I did edit the condition by hand was, that I was unable to find a way to connect the conditions with the OR operator. Using the condition designer the operator was always AND.
Maybe there should be an easier way to use boolean operators to connect conditions in the condition designer.

c_schmitz

c_schmitz

2021-03-24 17:40

administrator   ~63593

The underlying issue will be resolved in 16462 so it behaves like in LS3.

Issue History

Date Modified Username Field Change
2021-02-25 08:58 ong New Issue
2021-02-25 08:58 ong File Added: relevance_eqchanges.png
2021-03-10 17:27 ollehar Priority none => high
2021-03-10 17:27 ollehar Steps to Reproduce Updated
2021-03-10 17:27 ollehar Additional Information Updated
2021-03-10 17:59 ollehar Assigned To => ollehar
2021-03-10 17:59 ollehar Status new => feedback
2021-03-10 17:59 ollehar Note Added: 63122
2021-03-10 18:04 ong Note Added: 63124
2021-03-10 18:04 ong Status feedback => assigned
2021-03-11 13:17 ollehar Note Added: 63305
2021-03-11 13:18 ollehar Note Added: 63306
2021-03-11 15:11 ong Note Added: 63311
2021-03-22 20:45 c_schmitz Note Added: 63564
2021-03-22 20:47 c_schmitz Sync to Zoho Project => |Yes|
2021-03-22 21:00 c_schmitz Note Added: 63566
2021-03-22 21:03 c_schmitz Note Added: 63567
2021-03-22 22:11 c_schmitz Note Edited: 63567
2021-03-23 08:04 ong Note Added: 63572
2021-03-24 17:38 c_schmitz Status assigned => confirmed
2021-03-24 17:38 c_schmitz Sync to Zoho Project Yes => |Yes|
2021-03-24 17:38 c_schmitz Relationship added related to 16462
2021-03-24 17:40 c_schmitz Note Added: 63593
2021-03-24 17:40 c_schmitz Status confirmed => closed
2021-03-24 17:40 c_schmitz Resolution open => duplicate
2021-03-24 17:41 c_schmitz Issue cloned: 17201