SELECT AMASEI,AMAHIN,AMATOK,AMAETD
FROM ZSTFI@L.AMAHINB WHERE AMASEI LIKE 'CF00156-S0A%';
hasil
AMASEI AMAHIN AMATOK AMAETD
CF00156-S0A01BA 12391-K1A -N010-M1 00004 0
CF00156-S0A01AA 12391-K1A -N010-M1 00072 0
CF00156-S0A01AA 12391-K1AA-N012-M1 00072 20191223
Command untuk stop glassfish server :
sudo systemctl stop glassfish
Command untuk start glassfish server :
sudo systemctl start glassfish
Login : system
Passwd : system23XX
mau nambah autorisasi untuk folder tertentu : RADAR/PLANING
sudo mkdir -p /opt/RADAR/PLANING
sudo chown -R system:system /opt/RADAR
begitu gaess ini untuk linux ubunto
jenis - jenis job tag
PK :(permintaan khusus)
EX : (job sisa hanya diisue ke warehouse)
X : job pastdue
R : job trial
J : m/c dan rubber
N : spring export
M : M/C export
C : Rubber only
W : job biasa
TS : Trial Sample
yang tidak diisu ke parts sementara adalah : PK,EX,TS,R
in Postgresql there is a way to select count with condition. in PostgreSQL 9.1 version cannot user Filter to get Select Count with Condition then should use CASE WHEN
first. I use this SQL
SELECT
COUNT(sjobstatus) FILTER (WHERE sjobstatus = 'CANCELLED') AS fclose
FROM rdr.xwkschrb
working in my local PC but not working in liver server due to different Postgreql version. then i change to this SQL then working
SELECT
COUNT(CASE WHEN sjobstatus = 'CANCELLED' THEN sjobstatus END) AS close
FROM rdr.xwkschrb "
RUBBER 1 LIME
RUBBER 2 GOLD
RUBBER 3 ROSE
RUBBER 1 & 2 LIGHT CORNFLOWER BLUE
RUBBER 1 & 3 LIGHT GREEN
RUBBER 2 & 3 TURQOISE
1. list chemical yang diambil dari NAV masih ke bawah.. Cek
2. aku benerin urutannya.. jd total lot 10, inc 8, outbound 6, aftercure 3.. jd stock 2 dan yg blm dikerjakan 2 lot gitu ya bu
