Query retrieve order TAVI 'ready to pick'

minta tolong dibuatkan query untuk ngeretrieve order TAVI yang status nya 'ready to pick' (hanya ready to pick), minta tolong disiapin query nya, nanti aku akan butuh datanya ketika proses di magpie v2 sudah di cut-off dan mulai masuk periode SO.
mail@pastecode.io avatar
unknown
pgsql
7 months ago
525 B
5
Indexable
Never
select 
	"M8N3DATW9AP" as "StoreName",
	"ScYd0rirVdr" as "TrackingNum",
	"L9wUG36QNvd" as "OrderNum",
	"uvg23nGg8MR" as "OrderTime",
	"zCxpGlOMvw3" as "WarehouseStatus",
	"bKz0opEHSwS" as "OriginalStatus",
	"jenb7K4iFMX" as "DCName",
	"Vm7l04RQ6xI" as "OrganizationName",
	"fD5XlcDez6B" as "ShipperName"
from "e8b83099-7cca-4c26-abd1-67120be3dfbd"."ZcZi3bFNlL5" as "MO"
where "zCxpGlOMvw3" = 'Ready to Pick'
	AND ("M8N3DATW9AP" = 'SHOPEE TAVI' OR "M8N3DATW9AP" = 'LAZADA TAVI' OR "M8N3DATW9AP" = 'TOKOPEDIA TAVI')
Leave a Comment