View Issue Details

This bug affects 1 person(s).
 12
IDProjectCategoryView StatusLast Update
06504Bug reportsCentral participant databasepublic2013-03-02 16:34
Reporterlolo Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00RC9 
Fixed in Version2.00+ 
Summary06504: Central Participant Database: filtering by "survey links" does not work
Description

In the grid of participants, trying to filter by "Survey links" yields no results.

Steps To Reproduce

In Central Participants Database, have two participants: one linked to one survey, one not linked to nothing.

Then try to filter:
test 1) search criteria: "Survey Links" - "equals" - "0" -> no results
test 1) search criteria: "Survey Links" - "equals" - "1" -> no results

TagsNo tags attached.
Bug heat12
Complete LimeSurvey version number (& build)120817
I will donate to the project if issue is resolvedNo
BrowserSafari 5.1.7 (Mac)
Database type & versionMysql 5.5.24
Server OS (if known)Linux 2.6.27.52
Webserver software & version (if known)Apache 2
PHP Version5.3.14

Users monitoring this issue

Activities

lolo

lolo

2012-08-19 21:55

reporter   ~20536

Additional information: the filtering by 'Survey name' does not seem to be working either.

When expanding a participant (to reveal his/her attributes and linked surveys), survey names are all empty in the list of surveys (other fields are correctly populated).
This may be linked to the inability to filter by survey name.

lolo

lolo

2012-08-19 22:18

reporter   ~20537

Update 2: The display issue of survey names is actually due to survey base language vs admin language.

Let's say that a participant is linked to two surveys: a survey 'survey_en' (english language), and a survey 'survey_fr' (french language).

If admin is logged using english language, upon revealing linked surveys of participant:

  • row for survey 'survey_en' is present, and survey name is set
  • row for survey 'survey_fr' is present, but survey name is blank (empty)

likewise, If admin is logged using french language, upon revealing linked surveys of participant:

  • row for survey 'survey_en' is present, but survey name is blank (empty)
  • row for survey 'survey_fr' is present, and survey name is set

This probably interacts with filtering by survey name not working.

lolo

lolo

2012-11-15 14:14

reporter   ~22180

This issue should rather go in the "Central Participants Database" category

mdekker

mdekker

2012-11-30 14:56

reporter   ~22738

Lots of changes have been done and searching on survey name / survey count should be working. If next release (probably tuesday) doesn't fix this, feel free to reopen.

c_schmitz

c_schmitz

2012-12-04 13:16

administrator   ~22859

LimeSurvey 2.0+ build 121204 released.

lolo

lolo

2013-01-12 14:43

reporter   ~23621

Hello, I finally had the time to check this, but it seems to be still unsolved.
In the cpdb list of participants, when I filter by, say, "Survey links" "Greater than" "3" , nothing happens.
(the list still shows all participants regardless of the number of surveys they're linked to).

Also, the second issue is still there: when clicking "+" next to a participants to reveal its attributes & surveys, the surveys are there but all survey titles are empty.
This issue is related to the handling of languages: they are french surveys.
If I log in as administrator using the french interface then survey titles are visible. When I log in as administrator using the english interface then survey titles are blank.
Somehow it seems to be using the admin interface language to choose the survey title to display, which is wrong.

Thanks in advance, and sorry for not being able to give a feedback earlier.

lolo

lolo

2013-01-12 15:01

reporter   ~23622

Update: I also tested the filtering by survey name, and it does not seem to be working either (the list keeps showing all participants regardless of what I set for survey name).

PS: I'm currently on LS 2.00+ build 121231.

mdekker

mdekker

2013-01-15 11:46

reporter   ~23677

Your hint about the language has been helpful. Not really sure how to solve it though. It is difficult to make a choice on what language to use for display and search.

When we search in all languages, and present just one it might seem that the selection was wrong since the word does not exist in the title in the display language. I think the only workable solution, from a programming point of view would be to always use the base language of the survey otherwise it would result in numerous lookups for all surveys to see if they have a matching language or not.

lolo

lolo

2013-01-15 14:03

reporter   ~23686

Thanks for the answer. Yes I agree it makes much more sense to rely on the base language of the survey for display & search. Other languages of survey, or user/admin language should not come into play.

c_schmitz

c_schmitz

2013-02-24 16:26

administrator   ~24228

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11682

c_schmitz

c_schmitz

2013-02-26 20:03

administrator   ~24414

New version released.

c_schmitz

c_schmitz

2013-03-02 16:34

administrator   ~24493

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11741

Related Changesets

LimeSurvey: master 074f8c78

2013-02-24 14:52:46

c_schmitz

Details Diff
Fixed issue 06504: If admin language is not the same as survey language then survey names won't be shown for assigned surveys in central participants database Affected Issues
06504
mod - application/controllers/admin/participantsaction.php Diff File
mod - application/models/Participants.php Diff File
mod - application/models/Surveys_languagesettings.php Diff File
mod - application/views/admin/participants/displayParticipants_view.php Diff File

LimeSurvey: 2.1 ccf0d7d2

2013-02-24 14:52:46

c_schmitz

Details Diff
Fixed issue 06504: If admin language is not the same as survey language then survey names won't be shown for assigned surveys in central participants database Affected Issues
06504
mod - application/controllers/admin/participantsaction.php Diff File
mod - application/models/Participants.php Diff File
mod - application/models/Surveys_languagesettings.php Diff File
mod - application/views/admin/participants/displayParticipants_view.php Diff File

Issue History

Date Modified Username Field Change
2012-08-19 12:40 lolo New Issue
2012-08-19 21:55 lolo Note Added: 20536
2012-08-19 22:18 lolo Note Added: 20537
2012-08-19 22:21 lolo Issue Monitored: lolo
2012-08-20 13:15 c_schmitz Status new => assigned
2012-08-20 13:15 c_schmitz Assigned To => jcleeland
2012-10-14 13:43 Mazi Issue Monitored: aniesshsethh
2012-11-15 14:14 lolo Note Added: 22180
2012-11-15 14:14 lolo Status assigned => new
2012-11-15 14:48 c_schmitz Status new => assigned
2012-11-15 14:48 c_schmitz Category Tokens => Central participant database
2012-11-20 20:19 machaven Assigned To jcleeland => machaven
2012-11-21 04:50 liangweigang Issue Monitored: liangweigang
2012-11-30 14:56 mdekker Note Added: 22738
2012-11-30 14:56 mdekker Status assigned => resolved
2012-11-30 14:56 mdekker Fixed in Version => 2.00+
2012-11-30 14:56 mdekker Resolution open => fixed
2012-11-30 14:56 mdekker Assigned To machaven => mdekker
2012-12-04 13:16 c_schmitz Note Added: 22859
2012-12-04 13:16 c_schmitz Status resolved => closed
2013-01-12 14:43 lolo Note Added: 23621
2013-01-12 14:43 lolo Status closed => feedback
2013-01-12 14:43 lolo Resolution fixed => reopened
2013-01-12 15:01 lolo Note Added: 23622
2013-01-12 15:01 lolo Status feedback => assigned
2013-01-15 11:46 mdekker Note Added: 23677
2013-01-15 14:03 lolo Note Added: 23686
2013-02-24 15:49 c_schmitz Assigned To mdekker => c_schmitz
2013-02-24 15:52 c_schmitz Status assigned => resolved
2013-02-24 15:52 c_schmitz Resolution reopened => fixed
2013-02-24 16:26 c_schmitz Changeset attached => LimeSurvey master 074f8c78
2013-02-24 16:26 c_schmitz Note Added: 24228
2013-02-26 20:03 c_schmitz Note Added: 24414
2013-02-26 20:03 c_schmitz Status resolved => closed
2013-03-02 16:34 c_schmitz Changeset attached => LimeSurvey 2.1 ccf0d7d2
2013-03-02 16:34 c_schmitz Note Added: 24493
2021-08-06 05:13 guest Bug heat 6 => 12