public List<Scholar_ResearchGroup_List> GetScholarList_ByResearchGroups(string id)
        {
            var dtSchlrRG = new DataTable();
            var query = @"SELECT C.NO_PEKERJA,
                            HG.GAMBAR,
                            C.NAMA,
                            AL.EMAIL_RASMI,
                            CASE
                            WHEN J2.DESKRIPSI_EN IS NOT NULL THEN
                            J2.DESKRIPSI_EN
                            ELSE J.DESKRIPSI_EN
                            END AS FAKULTI,
                            NVL(F.DESCRIPTION, '-') AS NICHE_AREA,
                            UPPER(D.DESCRIPTION ) AS RESEARCH_GROUP,
                            B.STAF_PK
                            FROM HR_STAF B
                            LEFT JOIN RMC_RARG A ON A.STAF_FK = B.STAF_PK AND A.TKH_HAPUS IS NULL AND A.STATUS_AKTIF='Y'
                            LEFT JOIN HR_MAKLUMAT_PERIBADI C ON C.MAKLUMAT_PERIBADI_PK = B.MAKLUMAT_PERIBADI_FK AND C.TKH_HAPUS IS NULL
                            LEFT JOIN RMC_RG D ON D.RG_PK = A.RG_FK AND D.TKH_HAPUS IS NULL AND D.STATUS_AKTIF='Y'
                            LEFT JOIN RMC_COE E ON E.PTJ_COE = A.PTJ_COE AND E.TKH_HAPUS IS NULL AND E.STATUS_AKTIF='Y'
                            LEFT JOIN RMC_RESEARCH_ALLIANCE F ON F.PTJ_RA_CODE = A.PTJ_RA AND F.TKH_HAPUS IS NULL
                            LEFT JOIN HR_KOD_JAWATAN I ON B.KOD_JAWATAN = I.KOD_JAWATAN AND I.TKH_HAPUS IS NULL
                            LEFT JOIN HR_FAKULTI J ON J.KOD_FAKULTI=SUBSTR(B.KOD_PTJ, 0, 3) AND J.TKH_HAPUS IS NULL
                            LEFT JOIN HR_FAKULTI J2 ON J2.KOD_FAKULTI=SUBSTR(B.KOD_PTJ_ASAL, 0, 3) AND J2.TKH_HAPUS IS NULL
                            LEFT JOIN SMU_PARAMETER K ON K.KOD=B.STATUS_ASSTATK AND K.TKH_HAPUS IS NULL AND K.KUMPULAN_FK=96
                            LEFT JOIN HR_ALAMAT AL ON ALAMAT_PK=C.ALAMAT_PEJABAT_fK AND AL.TKH_HAPUS IS NULL
                            LEFT JOIN HR_GAMBAR HG ON HG.MAKLUMAT_PERIBADI_FK=C.MAKLUMAT_PERIBADI_PK
                            WHERE I.KOD_JAWATAN_JPA IN ('DS45','DS51','DS52','DS53','DS54','VK05','VK06','VK07','DG44') AND I.AKADEMIK = 'Y'
                            AND B.TKH_HAPUS IS NULL AND B.STATUS_AKTIF='Y' AND D.RG_PK ='" + id + "'";

            dtSchlrRG = CF.getOracleDT(query);
            var s = dtSchlrRG.Rows.Count;
            string name, no_pekerja, research_group, staff_pk;
            var ObjRGList = new List<Scholar_ResearchGroup_List>();
            for (var i = 0; i < s; i++)
            {
                name = dtSchlrRG.Rows[i][2].ToString();
                no_pekerja = dtSchlrRG.Rows[i][0].ToString();
                research_group = dtSchlrRG.Rows[i][6].ToString();
                staff_pk = dtSchlrRG.Rows[i][7].ToString();
                var hash = HashHelper.IdEncode(no_pekerja);

                ObjRGList.Add(new Scholar_ResearchGroup_List
                {
                    NAME = name,
                    NO_PEKERJA = hash,
                    RESEARCH_GROUP = research_group,
                    STAFF_PK = staff_pk
                });
            }

            return ObjRGList;
        }