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")

    # -------------------------------------------------------------------------
Test Standard Data Table
dataset/ETHPy150Open sahana/eden/modules/unit_tests/s3/s3resource.py/ResourceDataTableFilterTests.testDataTableFilterStandard