select levelcp from gate.sc_role where idrole = 'assvm' and 1=1
(6.36 KB)
0.0010
select idtarget, namafile from gate.sc_target
where idmodul = 'siakad' and namafile is not null
and (softdelete = '0') and namafile in ('rep_krsmahasiswa', 'rep_kartuujian', 'rep_khsmahasiswa', 'rep_transkripsmt', 'rep_transkrip', 'rep_ijazah') order by namafile
(6.6 KB)
0.0008
select idjenjang as key,idjenjang||' - '||namajenjang as value from (select * from ref.lv_jenjangpendidikan where 1=1 order by urutan) x where ispt = '1'
(6.48 KB)
0.0018
select u.*, pu.namaunit as namafakultas, p.nama as ketua_prodi, pu.namaunit as namaparentunit, pu.jenisunit as jenisparentunit
from ref.ms_unit u
left join ref.ms_unit pu on pu.idunit = u.parentunit
left join akademik.ak_pegawai p ON p.nip = u.nipketua where 1=1 order by infoleft
(8.69 KB)
siakadcloud.data.key.siakadv1-product.bf8281364c170ae132515d2ffe768955 cache failure: Item with such key doesn't exist on the memcache server. (this is a notice and not an error)
0.0008
select r.canread, r.caninsert, r.canupdate, r.candelete, r.canvalidate, r.canother, t.idtarget, t.namatarget
from gate.sc_targetrole r
join gate.sc_target t on r.idtarget = t.idtarget
left join gate.sc_submodul s on t.idsubmodul = s.idsubmodul and (s.softdelete = '0')
where t.idmodul = 'admin' and r.idrole = 'assvm'
and t.namafile = 'data_kustomisasiwordv2' and (s.idsubmodul is null or s.isaktif = '1')
and (r.softdelete = '0' and t.softdelete = '0')
(6.81 KB)
Failed to save data at the memcache server!
Cache write error
0.0006
SELECT COUNT(*) FROM (SELECT *
FROM (
SELECT
t.*,
ta.namafile,
CASE ta.namafile WHEN 'rep_ktm' THEN 'Kartu Tanda Mahasiswa (KTM)' WHEN 'rep_krsmahasiswa' THEN 'Kartu Rencana Studi (KRS)' WHEN 'rep_kartuujian' THEN 'Kartu Ujian' WHEN 'rep_khsmahasiswa' THEN 'Kartu Hasil Studi (KHS)' WHEN 'rep_transkripsmt' THEN 'Transkrip Sementara' WHEN 'rep_transkrip' THEN 'Transkrip Akademik' WHEN 'rep_ijazah' THEN 'Ijazah Mahasiswa' WHEN 'rep_skpi' THEN 'Surat Keterangan Pendamping Ijazah (SKPI)' ELSE ta.namafile END AS filetarget
FROM master.templateword_v2 t
JOIN gate.sc_target ta USING (idtarget)
) x
where 1=1) _ADODB_ALIAS_
(7.08 KB)
0.0005
SELECT *
FROM (
SELECT
t.*,
ta.namafile,
CASE ta.namafile WHEN 'rep_ktm' THEN 'Kartu Tanda Mahasiswa (KTM)' WHEN 'rep_krsmahasiswa' THEN 'Kartu Rencana Studi (KRS)' WHEN 'rep_kartuujian' THEN 'Kartu Ujian' WHEN 'rep_khsmahasiswa' THEN 'Kartu Hasil Studi (KHS)' WHEN 'rep_transkripsmt' THEN 'Transkrip Sementara' WHEN 'rep_transkrip' THEN 'Transkrip Akademik' WHEN 'rep_ijazah' THEN 'Ijazah Mahasiswa' WHEN 'rep_skpi' THEN 'Surat Keterangan Pendamping Ijazah (SKPI)' ELSE ta.namafile END AS filetarget
FROM master.templateword_v2 t
JOIN gate.sc_target ta USING (idtarget)
) x
where 1=1 order by idtemplate LIMIT 10 OFFSET 0
(7.88 KB)
