View Issue Details

IDProjectCategoryView StatusLast Update
14589Bug reports[All Projects] Expression Managerpublic2019-03-01 16:27
ReportertammoAssigned To 
PrioritynoneSeveritymajor 
Status newResolutionopen 
Product Version3.15.x 
Target VersionFixed in Version 
Summary14589: Expression in end URL seems to be impossible
Description

I want to use the next expression in the end URL:

https://toolsforresearch.com/report.R?code={if(!is_empty(rd),rd,"demo")}

where rd is a short text question which generates a random code using the following expression:

{join(substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',rand(0,25),1),substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',rand(0,25),1),substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',rand(0,25),1),substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',rand(0,25),1),substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',rand(0,25),1),substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',rand(0,25),1))}-{SAVEDID}

but I end up with the screen as shown in the attachment: the EM code is the end url is not producing the right code.

TagsNo tags attached.
Complete LimeSurvey version number (& build)Version 3.15.9+190214
I will donate to the project if issue is resolvedNo
BrowserChrome
Database & DB-VersionMySQL
Server OS (if known)Centos
Webserver software & version (if known)Apache
PHP Version7.1.26

Relationships

related to 14113 confirmedLouisGac Ampersands are changed to & 

Activities

tammo

tammo

2019-03-01 13:26

developer  

Werkgelukmeter.png (124,805 bytes)
tammo

tammo

2019-03-01 14:06

developer   ~50727

Is there a workaround? Can these quotes be interpreted right in some way?

tammo

tammo

2019-03-01 14:24

developer   ~50728

OK, it does seem to work with single quotes.

DenisChenu

DenisChenu

2019-03-01 14:42

developer   ~50731

Can you check if " is saved as real " or as & quot ; in DB ?

tammo

tammo

2019-03-01 15:06

developer   ~50732

You mean the end url or the question? And where to find the end url in the db?

tammo

tammo

2019-03-01 15:34

developer   ~50733

Found it. Not very easy to find: in lime_surveys_languagesettings

https://toolsforresearch.com/report.R?code={if(!is_empty(rd),rd,"demo")} (no quotes, but &quot for ") (end url)

DenisChenu

DenisChenu

2019-03-01 16:27

developer   ~50735

Ok , then seems it when saving …

Issue History

Date Modified Username Field Change
2019-03-01 13:26 tammo New Issue
2019-03-01 13:26 tammo File Added: Werkgelukmeter.png
2019-03-01 14:06 tammo Note Added: 50727
2019-03-01 14:24 tammo Note Added: 50728
2019-03-01 14:40 DenisChenu Relationship added related to 14113
2019-03-01 14:42 DenisChenu Note Added: 50731
2019-03-01 15:06 tammo Note Added: 50732
2019-03-01 15:34 tammo Note Added: 50733
2019-03-01 16:27 DenisChenu Note Added: 50735