select levelcp from gate.sc_role where idrole = 'assvm' and 1=1
(6.36 KB)
0.0013
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.0027
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)
0.0017
select idtarget, namafile from gate.sc_target
where idmodul = '' 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.54 KB)
0.0005
select idtarget, namafile from gate.sc_target
where idmodul = '' 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.54 KB)
0.0002
SELECT namafile FROM gate.sc_target WHERE idtarget = NULL LIMIT 1
(6.34 KB)
siakadcloud.data.key.siakadv1-product.a1a5659f76f229e13db40eb18d13194b cache failure: Item with such key doesn't exist on the memcache server. (this is a notice and not an error)
0.0020
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 = 'list_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!
