jquery - Datatables Sort within rows selected -

i have table has multiple number of entries(rows) 5-10-50-all available user.

i able sort columns pertaining actual number of rows showing instead of sorted entire table. example? total table length 50 rows. initial load 5 rows. when click on column want sort based on 5 rows not entire 50.

is possible?

    select m1.number, m1.incident_id, dateadd(hh,8,m1.update_time)update_time, dateadd(hh,8,m1.open_time)open_time, m1.assignment, o1.full_name               probsummarym1 m1 left outer join operatorm1 o1 on m1.assignee_name = o1.name               status not in('closed','resolved')               , category <> 'event'               order open_time