View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
07498Feature requestsConditionspublic2016-12-08 08:46
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynormalSeverityfeature 
Status closedResolutionduplicate 
Summary07498: Sometimes for some survey we need specific order for a people
Description

If we need to present some group to specific token, maybe in some order, or if we need to present some answer in specific order for some people, it's very difficult to do in javascript.

Additional Information

A possible solution: a SQL request with token attribute ( and code in)
For token survey, we can use an attribute for the order of an answer.

  1. Question attribute: order anwser with attribute (attribute selector or number).
  2. In the attribute: put the code of the answer separate with comma ( A1,A2,A5 )
  3. Use a SQL request to take the token, : SELECT * FROM $dbprefixanswers WHERE qid=$ia[0] AND language='$_SESSION['s_lang']' AND scale_id=0 AND code in ($attribute_token) ORDER BY FIELD( code,$attribute_token)

for each question type.

Same thing for group order with the new group code.

I already do it for ranking and list_dropdown question type. But i test it only in mySQL. I don't know if we can use " IN ($array) order by ($array) in msSQL and other SQL langage.

TagsNo tags attached.
Bug heat0
Story point estimate
Users affected %

Relationships

related to 11988 new Allow order of answers and sub question in 'the way admin user want' 

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-12-08 08:46 DenisChenu Relationship added related to 11988
2016-12-08 08:46 DenisChenu Assigned To => DenisChenu
2016-12-08 08:46 DenisChenu Status acknowledged => closed
2016-12-08 08:46 DenisChenu Resolution open => duplicate