queXS 1.12.0

Milestone information

Project:
queXS
Series:
main
Version:
1.12.0
Released:
2015-06-02  
Registrant:
Adam Zammit
Release registered:
2015-06-02
Active:
No. Drivers cannot target bugs and blueprints to this milestone.  

Download RDF metadata

Activities

Assigned to you:
No blueprints or bugs assigned to you.
Assignees:
4 Adam Zammit
Blueprints:
1 Implemented
Bugs:
3 Fix Released

Download files for this release

File Description Downloads

Release notes 

Complex quotas have been implemented. These quotas allow for multiple sample fields to be referenced when calculating completions instead of a single field. Also, time slots can be defined on a sample by sample basis as well as a questionnaire by questionnaire basis. Also included is a collection of bug fixes and translation/localisation updates.

Changelog 

View the full changelog

New Feature: Complex row quotas (see: https://blueprints.launchpad.net/quexs/+spec/complexquota) - Thank you Marco for sponsoring this feature
New Feature: Time slots extended to cover sample by sample as well as questionnaire by questionnaire - Thank you for sponsoring this feature

Fixed Bug: Check for available cases on no case available page is too time consuming
Fixed Bug lp:1436664 - System sort process fails where database name not 'quexs'
Fixed Bug lp:1452070 - New numbers still drawn when 'allow new numbers to be drawn' set to No
Fixed Bug lp:1459935 - When no operators have an extension assigned, questionnaires in test mode fail to create phone numbers for new cases

Translations: Updated from Launchpad - thank you especially to Russian and Spanish translators for updating your translations!

Database updates:

CREATE TABLE `questionnaire_sample_timeslot` (
`questionnaire_id` bigint( 20 ) NOT NULL ,
`sample_import_id` bigint( 20 ) NOT NULL ,
`availability_group_id` bigint( 20 ) NOT NULL ,
PRIMARY KEY ( `questionnaire_id` , `availability_group_id` , `sample_import_id` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;

CREATE TABLE `qsqr_question` (
   `qsqr_question_id` bigint(20) NOT NULL AUTO_INCREMENT,
   `questionnaire_sample_quota_row_id` bigint(20) NOT NULL,
   `lime_sgqa` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
   `value` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
   `comparison` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
   `description` text COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`qsqr_question_id`),
   KEY `questionnaire_sample_quota_row_id` (`questionnaire_sample_quota_row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE `qsqr_sample` (
  `qsqr_sample_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `questionnaire_sample_quota_row_id` bigint(20) NOT NULL,
  `exclude_var` char(128) COLLATE utf8_unicode_ci NOT NULL,
  `exclude_val` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `comparison` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`qsqr_sample_id`),
  KEY `questionnaire_sample_quota_row_id` (`questionnaire_sample_quota_row_id`),
  KEY `exclude_var` (`exclude_var`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

INSERT INTO qsqr_question (questionnaire_sample_quota_row_id,lime_sgqa,value,comparison)
SELECT questionnaire_sample_quota_row_id, lime_sgqa, value, comparison
FROM questionnaire_sample_quota_row
WHERE lime_sgqa != -1 AND lime_sgqa != -2;

INSERT INTO qsqr_sample (questionnaire_sample_quota_row_id,exclude_var,exclude_val,comparison)
SELECT questionnaire_sample_quota_row_id, exclude_var,exclude_val, 'LIKE'
FROM questionnaire_sample_quota_row;

ALTER TABLE `questionnaire_sample_quota_row`
  DROP `lime_sgqa`,
  DROP `value`,
  DROP `comparison`,
  DROP `exclude_var`,
  DROP `exclude_val`;

1 blueprint and 3 bugs targeted

Blueprint Priority Assignee Delivery
Create and import and export complex quotas Create and import and export complex quotas 1 Undefined Adam Zammit  11 Implemented
Bug report Importance Assignee Status
1436664 #1436664 System sort process fails where database name not 'quexs' 3 High Adam Zammit  10 Fix Released
1452070 #1452070 New numbers still drawn when 'allow new numbers to be drawn' set to No 3 High Adam Zammit  10 Fix Released
1459935 #1459935 When no operators have an extension assigned, questionnaires in test mode fail to create phone numbers for new cases 3 High Adam Zammit  10 Fix Released
This milestone contains Public information
Everyone can see this information.