<?xml version='1.0' encoding='UTF-8'?>
<pkd xmlns="http://www.intertrust.ru/schema/palette/pkd">
<sort name="Сортировка{name}" id="{id}">
<sql-field name="(CASE WHEN :defaultSort=TRUE THEN event.event_DT END) DESC, (CASE WHEN :sortingField ='from' AND :isAscending=false THEN COALESCE((SELECT f.Original_ShortName FROM SO_BEARDS f WHERE f.unid = event.event_from), event.event_From_1) END) DESC, (CASE WHEN :sortingField = 'created' AND :isAscending=false THEN event.event_DT END) DESC, (CASE WHEN :sortingField ='taskDueDate' AND :isAscending=false THEN event.task_Date END) DESC, (CASE WHEN :sortingField = 'from' AND :isAscending=true THEN COALESCE((SELECT f.Original_ShortName FROM SO_BEARDS f WHERE f.unid = event.event_from), event.event_From_1) END) ASC, (CASE WHEN :sortingField = 'created' AND :isAscending=true THEN event.event_DT END) ASC, (CASE WHEN :sortingField ='taskDueDate' AND :isAscending=true THEN event.task_Date END) ASC"/>
{SQL-request}"/>
<script lang="JavaScript"><[CDATA[..]]></script>
</sort>
</pkd> |