'Test Standard Data Table'

def testDataTableFilterStandard(self):

    resource = current.s3db.resource('hrm_certificate_skill')
    vars = Storage({'bSortable_0': 'false', 'bSortable_1': 'true', 'bSortable_2': 'true', 'sSortDir_0': 'asc', 'iSortCol_0': '1', 'iColumns': '3', 'iSortingCols': '1'})
    (searchq, orderby, left) = resource.datatable_filter(['id', 'skill_id', 'competency_id'], vars)
    self.assertEqual(orderby, 'hrm_skill.name    asc')
