- Модуль: workflow
- Путь к файлу: ~/bitrix/modules/workflow/classes/mysql/workflow.php
- Класс: CWorkflow
- Вызов: CWorkflow::GetHistoryByID
static function GetHistoryByID($ID)
{
$err_mess = (CWorkflow::err_mess())."
Function: GetHistoryByID
Line: ";
global $DB;
$ID = intval($ID);
$strSql = "
SELECT DISTINCT
L.*,
".$DB->DateToCharFunction("L.TIMESTAMP_X")." TIMESTAMP_X,
concat('(',U.LOGIN,') ',ifnull(U.NAME,''),' ',ifnull(U.LAST_NAME,'')) USER_NAME,
S.TITLE STATUS_TITLE
FROM
b_workflow_log L
LEFT JOIN b_workflow_status S ON (S.ID = L.STATUS_ID)
LEFT JOIN b_user U ON (U.ID = L.MODIFIED_BY)
WHERE
L.ID = ".$ID."
";
$res = $DB->Query($strSql, false, $err_mess.__LINE__);
return $res;
}