Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- subj.name AS subject,
- split_part(SOURCE.name, ' ', 1) AS SOURCE,
- CASE WHEN SOURCE.TYPE = 'OWN'
- THEN 'Внутренняя'
- ELSE 'Внешняя'
- END AS SrcType,
- macroregion.name AS macro,
- REPLACE(city.nameru, 'ё', 'е') AS city,
- msg.issuedatecreated + INTERVAL '3 hours' AS DATE
- msg.issuedatecreated + INTERVAL '3 hours' AS TIME,
- split_part(msg.issueurl, '#', 1) AS Url,
- msg.issueauthorname AS Author,
- msg.issuetext AS text,
- CASE WHEN msg.entrytone = 'NEGATIVE'
- THEN 'Негатив'
- WHEN msg.entrytone = 'NEUTRAL'
- THEN 'Нейтрал'
- WHEN msg.entrytone = 'POSITIVE'
- THEN 'Позитив'
- END AS Tone,
- cat.name AS Cat,
- Ответы,
- Вариаты закрытия инцидентов
- FROM monitoring_customerissues AS msg
- LEFT JOIN monitoring_projectcategories AS cat
- ON (msg.projectcategory_id = cat.id)
- LEFT JOIN geo_city AS city
- ON (city.id = msg.geocity_id)
- LEFT JOIN monitoring_macroregions AS macroregion
- ON (msg.monitoringmacroregion_id = macroregion.id)
- LEFT JOIN monitoring_projectsubjects AS subj
- ON (msg.projectsubject_id = subj.id)
- LEFT JOIN monitoring_projectsites AS SOURCE
- ON (msg.projectsite_id = SOURCE.id)
- WHERE msg.project_id = 18791
- AND msg.issuedatecreated >= :mindate
- AND msg.issuedatecreated <= :maxdate
- AND msg.deleted IS NULL
- ORDER BY msg.issuenumber ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement