def test_get_list_multiple_dotted_order(self):
        """
        REST Api: Test get list order multiple dotted notation
        """

        class Model4Api(ModelRestApi):
            datamodel = SQLAInterface(Model4)
            list_columns = [
                "field_string",
                "model1_1.field_string",
                "model1_2.field_string",
            ]

        self.appbuilder.add_api(Model4Api)

        client = self.app.test_client()
        token = self.login(client, USERNAME_ADMIN, PASSWORD_ADMIN)

        # Test order asc for model1_1
        arguments = {"order_column": "model1_1.field_string", "order_direction": "desc"}
        uri = f"api/v1/model4api/?{API_URI_RIS_KEY}={prison.dumps(arguments)}"
        with model4_data(self.appbuilder.session, MODEL1_DATA_SIZE):
            rv = self.auth_client_get(client, token, uri)
            data = json.loads(rv.data.decode("utf-8"))
            # Tests count property
            self.assertEqual(data["count"], MODEL1_DATA_SIZE)
            # Tests data result default page size
            self.assertEqual(len(data[API_RESULT_RES_KEY]), self.model1api.page_size)
            i = 0
            self.assertEqual(
                data[API_RESULT_RES_KEY][i],
                {
                    "field_string": "test9",
                    "model1_1": {"field_string": "test9"},
                    "model1_2": {"field_string": "test9"},
                },
            )

            # Test order desc for model1_2
            arguments = {
                "order_column": "model1_2.field_string",
                "order_direction": "asc",
            }
            uri = f"api/v1/model4api/?{API_URI_RIS_KEY}={prison.dumps(arguments)}"
            rv = self.auth_client_get(client, token, uri)
            data = json.loads(rv.data.decode("utf-8"))
            # Tests count property
            self.assertEqual(data["count"], MODEL1_DATA_SIZE)
            # Tests data result default page size
            self.assertEqual(len(data[API_RESULT_RES_KEY]), self.model1api.page_size)
            i = 0
            self.assertEqual(
                data[API_RESULT_RES_KEY][i],
                {
                    "field_string": "test0",
                    "model1_1": {"field_string": "test0"},
                    "model1_2": {"field_string": "test0"},
                },
            )

        REST Api: Test get list order multiple dotted notation
        
tests/test_api.py