第一个查询nth_value(wos.endtime,1) OVER(PARTITION BY woas.workorderidORDER BY wos.endtime ASC ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as "Nth Onhold Starttime" from wo_status_info wos
LEFT JOIN wo_assessment woas O
if (wos.word.wordForms) { if (wos.word.wordForms更新:if (wos.word.wordForms && wos.word.wordForms[0].wordDefinitions && wos.word.wordForms[[0].wordDefinitionId;
if (<
select wo_status_history.entry_date as entry where wo_status_history.wos_auto_keyselect wo_status_history.entry_Date as close --where wo_status_history.wos_auto_key
AS "Técnico", std.STATUSNAME AS "Estado de solicitud" LEFT JOIN WorkOrderStates wosON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN AaaUser tiON td.USERID=ti.USER_ID
LEFT JOIN StatusDefinit