View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
14289 | Bug reports | Survey participants (Tokens) | public | 2018-11-26 23:48 | 2021-03-07 21:02 |
Reporter | mfavetti | Assigned To | mfavetti | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.15.x | ||||
Summary | 14289: Token column is blank when selecting "Not completed" or "Not started" status for token export | ||||
Description | In the token status dropdown, selecting "Not completed" or "Not started" generates a CSV with a blank token column. Suspect this has to do with identically named columns overwriting each other in the leftJoin call for those two options. Since the where clause limits to where there is no row in the result table, the token column for the token table will be overwritten with a NULL from the token column for the result table. Can fix this by modifying the query's select clause. PR incoming | ||||
Steps To Reproduce | Create a survey | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 3.15.5+181115 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome 70.0.3538.110 | ||||
Database type & version | MariaDB 10.3 | ||||
Server OS (if known) | Linux Mint 19 | ||||
Webserver software & version (if known) | nginx 1.14.1 | ||||
PHP Version | 7.2.12 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2018-11-26 23:48 | mfavetti | New Issue | |
2018-11-26 23:48 | mfavetti | Status | new => assigned |
2018-11-26 23:48 | mfavetti | Assigned To | => mfavetti |
2018-11-27 01:09 | mfavetti | Note Added: 49792 | |
2021-03-07 21:02 | c_schmitz | Status | assigned => closed |
2021-03-07 21:02 | c_schmitz | Resolution | open => fixed |