Hi all,

I'm new at OS and create application using both external DB (MySQL) and internal DB. I have problem when sort each column using SQL query it's not work.

I have to use SQL query instead of Aggregate to get data from both external DB and internal DB because of OS does not support join these DB together, the default sort of Table record is not working when I use SQL query

Here is my action, the Department, EmployeeDepartment tables are external DB, and the Employee is internal DB. I just reproduce the issue in my personal environment.

I attached my oml below, please help me take a look on this. 

Thank you.