第三十九章 终端输入 输出 - terminator
terminator
第三个位置参数：最多八个字符的字符串，其中任何一个都将终止READ 。这些终止符是协议中内置终止符的补充。请参阅使用终止符结束 I/O 操作。
portstate
第 4 个位置参数：按位置顺序最多包含 8 个字节的字符串，用于控制 COM 端口状态。端口状态字节如下（字节从1开始按从左到右的顺序编号）：
How to use order by in Query %DLIST ?
Hello My Friends,
I have a question how to use order by %DLIST, this is my code:
SELECT
$ListToString(%DLIST(DISTINCT MRDIA_ICDCode_DR->MRCID_Code),', ' ) ICDX,
$ListToString(%DLIST(DISTINCT (MRDIA_ICDCode_DR->MRCID_Desc || ' (' || MRDIA_DiagnosisType_DR->DTYP_Code || ')')),', ' ) Diagnose
FROM SQLUser.PA_Adm
LEFT JOIN SQLUser.PA_AdmInsurance ON (PAADM_RowID = INS_ParRef AND INS_Rank = 1)
LEFT JOIN SQLUser.PA_AdmPackage ON (PAADM_RowID = PACK_ParRef)
LEFT JOIN SQLUser.MR_Adm on MRADM_ADM_DR = PAADM_RowID
LEFT JOIN SQLUser.MR_Diagnos ON MRADM_RowId = MRDIA_MRADM_ParRef
LEFT JOIN SQLUser.OE_Order ON PAADM_RowID = OEORD_Adm_DR
LEFT JOIN SQLUser.OE_OrdItem AS OD1 ON OEORD_RowId = OEORI_OEORD_ParRef AND OEORI_Categ_DR = 20 AND OEORI_ItemStat_DR <> 1
LEFT JOIN SQLUser.OE_OrdItem AS OD2 ON OEORD_RowId = OD2.OEORI_OEORD_ParRef AND OD2.OEORI_Categ_DR = 11 AND OD2.OEORI_ItemStat_DR <> 1
WHERE
PAADM_ADMNo IS NOT NULL AND PAADM_Type = 'E'
AND PAADM_AdmDate >= '2024-11-01' AND PAADM_AdmDate <= '2024-11-25'
GROUP BY PAADM_RowId
and this is the result
.png)
and What I need is how to order by the Diagnose Colum like (M) for the first and (S) for second and (C008) for the last ?
like this one
.png)
Does anyone could help me ?
Thank You
Best Regards,
Steve Henry