{
  "fields": [{"type":"int","id":"_id"},{"type":"text","id":"select distinct"}],
  "records": [
    [1,"gn_person_qu.idnumber(rq.candidate) idi, gn_person_qu.lastname(rq.candidate)lnam,"],
    [2,"gn_person_qu.firstname(rq.candidate)fnam,"],
    [3,"gn_sex_qu.DESCRIPTION(  gn_person_qu.SEX(rq.candidate)   )gender,"],
    [4,"gn_person_qu.BIRTHCOUNTRY(rq.candidate) bcuntry, gn_country_qu.DESCRIPTION(gn_person_qu.BIRTHCOUNTRY(rq.candidate))bcoundes,"],
    [5," ac.CITY_CODE, ap_city_qu.DESCRIPTION(ac.CITY_CODE)citdes,"],
    [6,"rq.unit,REPLACE(ap_unit_qu.lastname(rq.unit),',','')uniname,"],
    [7,"ap_unit_tree_qu.GetFacultyOfUnit(rq.unit) fac,"],
    [8,"REPLACE(ap_unit_qu.lastname(ap_unit_tree_qu.GetFacultyOfUnit(rq.unit)),',','')facname,"],
    [9,"rq.GRADE,rq.FINAL_STEP_IN_GRADE  darga ,rq.STATUS_IN_STEP mamad,"],
    [10,"ap_grade_step_status_qu.DESCRIPTION(rq.GRADE,rq.FINAL_STEP_IN_GRADE ,rq.STATUS_IN_STEP)grdes"],
    [11,""],
    [12,"from ap_request rq, ap_candidate ac"],
    [13,"where"],
    [14,"rq.grade in(22, 49, 50, 62, 18,21,  23,  44, 45, 92, 94, 43   ) "],
    [15,"and "],
    [16,"rq.REQUEST_STATUS = 40 and rq.new_changed_request <> 5  and"],
    [17," rq.to_DATE >= to_date('01/10/2015','dd/mm/YYYY')"],
    [18," and rq.from_DATE <= to_date('30/09/2016','dd/mm/YYYY') and"],
    [19,"rq.candidate = ac.candidate"]
]}