1
queXS 1.8.0 - Changes since 1.7.6
3
New Feature: Allow for restricting the view of sample variables to operators
4
New Feature: Case status and assignment page allowing to view the current status of cases by questionnaire, and allow for the manual assigning to operators if required
8
CREATE TABLE IF NOT EXISTS `case_queue` (
9
`case_queue_id` bigint(20) NOT NULL AUTO_INCREMENT,
10
`case_id` bigint(20) NOT NULL,
11
`operator_id` bigint(20) NOT NULL,
12
`sortorder` int(11) NOT NULL,
13
PRIMARY KEY (`case_queue_id`),
14
UNIQUE KEY `case_id` (`case_id`),
15
KEY `operator_id` (`operator_id`)
16
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
18
CREATE TABLE IF NOT EXISTS `sample_import_var_restrict` (
19
`sample_import_id` bigint(20) NOT NULL,
20
`var` char(128) collate utf8_unicode_ci NOT NULL,
21
`restrict` tinyint(1) NOT NULL default '0',
22
PRIMARY KEY (`sample_import_id`,`var`)
23
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1
25
queXS 1.7.6 - Changes since 1.7.5
3
27
Fixed Bug: Define operator skills as for the assigning of cases to operators