help me please. how to "SELECT DISTINCT" in dataeditor?

reru.academic3

' Editor::inst( $db, 'tb_table' )
' ->field(
' Field::inst('tb_table.id_group'),
' Field::inst('tb_table.subjcode'),
' Field::inst('tb_table.subjgroup'),
' Field::inst('tb_table.term'),
' Field::inst('tb_table.stu_type'),
' Field::inst('tb_subjgroup.group_tname'),
' Field::inst('tb_faculty.fac_tname'),
' Field::inst('tb_course.subjname1'),
' Field::inst('tb_stu_type.id_type'),
' Field::inst('tb_stu_type.type_name'),
' Field::inst('tb_course.crhr'),
' Field::inst('tb_program.prg_tname'),
' Field::inst('tb_table.tea_sname'),
' Field::inst('tb_table.tea_sname2'),
' Field::inst('tb_table.tea_sname3'),
' Field::inst('tb_table.time'),
' Field::inst('tb_table.time2'),
' Field::inst('tb_table.time3'),
' Field::inst('tb_table.room'),
' Field::inst('tb_table.room2'),
' Field::inst('tb_table.room3'),
' Field::inst('tb_table.homeroom')
' )
'
' ->leftJoin('tb_subjgroup','tb_table.subjgroup','=','tb_subjgroup.id_subjgroup')
' ->leftJoin('tb_stu_group','tb_table.id_group','=','tb_stu_group.id_group')
' ->leftJoin('tb_program','tb_stu_group.id_program ','=','tb_program.id_program')
' ->leftJoin('tb_faculty','tb_program.id_faculty','=','tb_faculty.id_faculty')
' ->leftJoin('tb_course','tb_table.subjcode','=','tb_course.subjcode')
' ->leftJoin('tb_stu_type','tb_stu_group.id_type','=','tb_stu_type.id_type')
' ->where( 'tb_table.term', $_POST['term'])
' ->where( 'tb_faculty.id_faculty', $_POST['facultyId'])

allan

Hi,

The main editor data "fetch" doesn't have a "distinct" option since since it is expected that each row is already distinct via its primary key. If the primary key is not unique (i.e. making that row distinct) then there is no way to edit specifically that row.

Allan