Skip to content

Translations de toutes les Questions d'un Container Master

Pour changer de container master code : Modifier le container master code des deux WHERE container.container_master_code= 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
SELECT
    container.id AS 'Container ID',
    container.container_master_code AS 'MASTER CODE',
    container.container_type_code as 'Container Type',
    exam_question.id AS 'Question ID',
    exam_question.name AS 'Question Name',
    REGEXP_REPLACE(translation.content::title, '<[^>]+>','','g') as title,
    REGEXP_REPLACE(translation.content::suggestion, '<[^>]+>','','g') as suggestion,
    REGEXP_REPLACE(translation.content::explanation, '<[^>]+>','','g') as explanation,
    `translation`.language_code AS 'Translation Language Code',
        translation.`content`
FROM container
     JOIN container_mode_pivot ON container.id = container_mode_pivot.container_id
     JOIN `mode` ON container_mode_pivot.mode_id = mode.id
     JOIN mode_item ON `mode`.id = mode_item.mode_id
     JOIN activity_mode_item_pivot ON mode_item.id = activity_mode_item_pivot.mode_item_id
     JOIN activity ON activity_mode_item_pivot.activity_id = activity.id
     JOIN activity_item ON activity.id = activity_item.activity_id
     JOIN activity_item_content_part_pivot ON activity_item.id = activity_item_content_part_pivot.activity_item_id
     JOIN exam_part ON activity_item_content_part_pivot.exam_part_id = exam_part.id
     JOIN exam_question ON exam_part.id = exam_question.exam_part_id
     JOIN `translation` ON `translation`.translatable_type = 'ExamQuestion' AND `translation`.translatable_id = exam_question.id
WHERE
    container.container_type_code = 'STANDARD'
  AND    container.container_master_code = 'BRIGHT_ESPANOL'
UNION
SELECT
    container.id AS 'Container ID',
    container.container_master_code AS 'MASTER CODE',
    container.container_type_code as 'Container Type',
    exam_question.id AS 'Question ID',
    exam_question.name AS 'Question Name',
    REGEXP_REPLACE(translation.content::title, '<[^>]+>','','g') as title,
    REGEXP_REPLACE(translation.content::suggestion, '<[^>]+>','','g') as suggestion,
    REGEXP_REPLACE(translation.content::explanation, '<[^>]+>','','g') as explanation,
    `translation`.language_code AS 'Translation Language Code',
        translation.`content`
FROM container
     JOIN container_mode_pivot ON container.id = container_mode_pivot.container_id
     JOIN `mode` ON container_mode_pivot.mode_id = mode.id
     JOIN activity_mode_pivot ON mode.id = activity_mode_pivot.mode_id
     JOIN activity ON activity_mode_pivot.activity_id = activity.id
     JOIN activity_item ON activity.id = activity_item.activity_id
     JOIN activity_item_content_part_pivot ON activity_item.id = activity_item_content_part_pivot.activity_item_id
     JOIN exam_part ON activity_item_content_part_pivot.exam_part_id = exam_part.id
     JOIN exam_question ON exam_part.id = exam_question.exam_part_id
     JOIN `translation` ON `translation`.translatable_type = 'ExamQuestion' AND `translation`.translatable_id = exam_question.id
WHERE
    container.container_type_code = 'STANDARD'
  AND
    container.container_master_code = 'BRIGHT_ESPANOL';

Keywords

exam_question title description suggestion container