Hello everyone.
I have 5 tables. I am using addons to get all the data together. The data is showed corectly. My question is, how can I get all of that data but using 3 filter:_pds.pds_idperiode,_sps.sps_id,_mss.mss_id
This is my response:
{ id: 13744, idperiodedaftar: 652, kodependaftar: 230201053, namapendaftar: NABILLA NAHTU RIZKI, isaktif: 1, nim: , password: 59a657bc3964508dc8ee246d1b2a9368, passwordsalt: 65674651e0b05, isvalid: 0, isfinal: 0, isdaftarulang: 0, idjenispilihan: S1, _pds: [ { pds_id: 652, pds_nama: PROGRAM SARJANA (S1), pds_idperiode: 20232}], _pps: [ { pps_id: 13744, pps_idpendaftar: 13744, pps_idsp: 2875, _sps: [ { sps_id: 2875, sps_idpd: 652, sps_idunit: 25201, sps_idjenispilihan: S1, sps_idkampus: 1, _mss: [ { mss_id: 25201, mss_namaunit: Teknik Lingkungan, mss_parentunit: 031030A3, mss_isaktif: 1}]}]}]},
Right now I just using get all records from pd_pendaftar_usahid and addons with custom join,query,eval,and return to get this response:
This is my tables relationships:
Please help me to solve it.
Thanks a lot.
{
id: 13744,
idperiodedaftar: 652,
kodependaftar: 230201053,
namapendaftar: NABILLA NAHTU RIZKI,
isaktif: 1,
nim: ,
password: 59a657bc3964508dc8ee246d1b2a9368,
passwordsalt: 65674651e0b05,
isvalid: 0,
isfinal: 0,
isdaftarulang: 0,
idjenispilihan: S1,
_pds: [
{
pds_id: 652,
pds_nama: PROGRAM SARJANA (S1),
pds_idperiode: 20232}],
_pps: [
{
pps_id: 13744,
pps_idpendaftar: 13744,
pps_idsp: 2875,
_sps: [
{
sps_id: 2875,
sps_idpd: 652,
sps_idunit: 25201,
sps_idjenispilihan: S1,
sps_idkampus: 1,
_mss: [
{
mss_id: 25201,
mss_namaunit: Teknik Lingkungan,
mss_parentunit: 031030A3,
mss_isaktif: 1}]}]}]},