Budy Sutjijati
02/03/2022, 1:59 PMSELECT
type,
tranid,
id,
BUILTIN.DF(custbody_rfi_trm_temp_shipstatus) as tempstatus,
TO_CHAR(createddate, 'DD/MM/YYYY HH24:MM:SS') AS createddatetime,
TO_CHAR(lastmodifieddate, 'DD/MM/YYYY HH24:MM:SS') AS lastmodifieddatetime,
TO_CHAR(current_date, 'DD/MM/YYYY HH24:MM:SS') AS currentdate
FROM
transaction
WHERE
transaction.type
LIKE '%ItemShip%'
AND
BUILTIN.DF(transaction.custbody_rfi_trm_temp_shipstatus) = 'PROCESSING'
ORDER BY lastmodifieddate desc
redfishdev
02/03/2022, 2:07 PM